Greek characters problem - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Greek characters problem

Author

Topic

dimoss
Yak Posting Veteran

52 Posts

Posted - 2007-11-28 : 06:29:32

Hi,

I have a sql db with a table in which I store Greek text. I have changed the collation name of the columns which keep the Greek to "Greek_AI_AS" and the datatype of these columns are nvarchar or ntext.

However whenever I tried to add text from a web form the Greek characters does not show correctly and I get "?????".

The collation name of the sql db is Latin1_Generala_CP1_CI_AS. Do u think there is a collation conflict or the column collation overides the db one? Or there is something else which I don't know?

P.S. I have set the correct Codepage and response.CharSet for Greek language.

Any ideas would by valuable.
Thanks

Dimos

www.tabletennis.gr

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2007-11-28 : 07:04:56

The column collation overrides the DB collation. You would need to change all of your columns to be Greek_AI_AS.