Then you opened the right thread!!!
Look I have this problem with international characters like hebrew, japaneese etc. I can save these as Unicode in SQL Server 7, that's fine. When I look at the table contents in SQL Server I get like ??? ??, but when I query it from tha analyzer I get the correct font, so somehow it is converted.
Now if I query the same table from VB, I get the ??? ??, and can't seem to be able to show the characters. Ok, that´s not important because I have to show it on a browser, and I know browser can tranlate this, but I still get the ??? ??. Now I've searched for this and found that each character has a unicode value and tha works for example in ASP I would write ֘ for a special character and would get the correct Hebrew character.
Has anyone worked with this? my architecture is ASP-VB/COM-SQLServer7,
Thanks for your help
André
