Unicode characters support: no in SQL - yes in Access.

[Aaron Bertrand - MVP]

What datatype is the data stored in SQL Server? To utilize unicode, you
myst use nchar, nvarchar, or ntext... not char, varchar, or text.
[url]http://www.aspfaq.com/2354[/url]



"Nick" <ektorjr@hol.gr> wrote in message
news:0e3c01c361aa$a76ba490$a601280a@phx.gbl...

> Hello
>
> I have a page with 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 (which locates in
> the US). When I was working locally on my PC it appeared
> fine!
>
> Can anybody give ideas on the possible solution?
>
> Thanks
>
> Nick

[Nikos Drandakis]

It's nvarchar


*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!