Hi guys,
I got a big problem with my SQL 2000 DB, I got to enter polish chars in the fields and I don't seem to be able to. I tried setting the collation to SQL_Latin1_General_CP1250_CI_AS or SQL_Polish_CP1250_CS_AS or used the window collation in polish on the separate fields, I tried setting my new DB collation to SQL_Polish_CP1250_CI_AS. But nothing helped I tried to insert the phrase "Wyda?e? 200 punktów na gr? w ping-ponga." but every time the special chars like the "?" or the "ó" are gone and become normal "e" or "o".
Could somebody help me here cause I'm really not getting out of this one.
Hi!
Posted elsewhere by Dejan Sarka, SQL Server MVP :
"In SQL 2000 you can define collations on server, db and column level. This collation is used, for example if defined on column level for a varchar column, on all rows. If you need different collations in different rows of the same column, then you have to use unicode data types, in the example nvarchar. So, check the collation on all levels - server, db and column."
No comments:
Post a Comment