November 6, 2009 at 9:38 am
Need to be able to display Polish special characters - ż ł ś ę ź etc - I'm told that Proper display of such characters requires UTF-8 encoding.
Where or how do I get a list of what the availbale Database collations are ?
November 6, 2009 at 9:46 am
Jpotucek (11/6/2009)
Need to be able to display Polish special characters - z l s e z etc - I'm told that Proper display of such characters requires UTF-8 encoding.Where or how do I get a list of what the availbale Database collations are ?
Check the following:
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 6, 2009 at 3:05 pm
Jpotucek (11/6/2009)
Need to be able to display Polish special characters - z l s e z etc - I'm told that Proper display of such characters requires UTF-8 encoding.Where or how do I get a list of what the availbale Database collations are ?
If your SQL Server is 2005 Sp2 and up you could change to Polish collation by right clicking and going to design properties of the table. That said SQL Server uses UC-S2 which is similar to UTF 16 so you could encode Polish in UTF8 in your application layer and pass the data to SQL Server which is using either Polish Windows collation or SQL Server collation that is Accent sensitive. Post again if you still need help.
http://msdn.microsoft.com/en-us/library/ms143508.aspx
Kind regards,
Gift Peddie
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply