Unicode character support: SQL no - Access yes.

Hello all

I have a page with <%@Language=VBScript codepage=1253%> at the top, which supports Greek characters.

All Greek characters display correctly in the page except those coming from my database (SQL Server). They seem like I didn't have set the codepage value. I request these values and display them in a drop-down combo box.

Strange thing is, exactly the same page worked fine when it requested data from Access, but now I am using SQL Server and not display Greek characters. The problem appears only in my web host's database. When I was working locally on my PC it appeared fine!

Can anybody give ideas on the possible solution?

Thanks

Nick

Access is doing an enormous amount of formatting back and forth (often to the pain of the developer). In your case that was positive and eventually possible due to your Regional Settings. But I suspect SQL Server being setup maybe with English(American) settings. That doesn't cause pbs for that but the application that has to interpret it has to know what the bits and bytes are representing. Hence the codepage problem should be attacked

Make sure all char,varchar or text data types in MS SQL are setup as "nvarchar" and "ntext" to make the data independent from the collation page.
that did it for me.

thanks