Collations problems !

Hi All..
I'm having a bit of a problem with using collations in my MS
SQLServer2000..
The problem I have, is that I have 1 DB in 1 country,but I need to
support multible languages in the same table.. where I have stored
standart text using a Varchar..
The current collations doesnt support the polish and Danish language..
so what Collation will enable me to do that on the the table.. ?
I have thought about using this :
SQL_Latin1_General_CP1_CI_AS collation, but I'm not sure it will do it
for me..
Any Help ?
Best Regards
Lars Roed
*** Sent via Developersdex http://www.codecomments.com ***
<Lars> wrote in message news:ew$wqONbFHA.1660@.tk2msftngp13.phx.gbl...
> I'm having a bit of a problem with using collations in my MS
> SQLServer2000..
> The problem I have, is that I have 1 DB in 1 country,but I need to
> support multible languages in the same table.. where I have stored
> standart text using a Varchar..
> The current collations doesnt support the polish and Danish language..
> so what Collation will enable me to do that on the the table.. ?
> I have thought about using this :
> SQL_Latin1_General_CP1_CI_AS collation, but I'm not sure it will do it
> for me..
> Any Help ?
Go for nvarchar (unicode)
Regards, Wojtek
|||Hi there..
So using an Nvarchar will override the use of the collation.. and make
sure that the polish and estern european letters will remain intact ?
Thanx in advance
*** Sent via Developersdex http://www.codecomments.com ***
|||Nvarchar(Unicode) might be the best solution as suggested, but be aware of
the differencies compare to non-unicode. Unicode needs tvice the space and
the maximum size of a nchar or nvarchar column is 4000 characters versus
8000 characters for char and varchar. This might not at all be an issue for
you, but I find it usefull to be aware of.
If you haven't done it already it might be worth reading about collations in
Books On Line
Regards
Steen
Lars wrote:
> Hi there..
> So using an Nvarchar will override the use of the collation.. and make
> sure that the polish and estern european letters will remain intact ?
> Thanx in advance
>
> *** Sent via Developersdex http://www.codecomments.com ***
|||<Lars> wrote in message news:OVyAOiPbFHA.2876@.TK2MSFTNGP10.phx.gbl...
> So using an Nvarchar will override the use of the collation.. and make
> sure that the polish and estern european letters will remain intact ?
You will be able to store characters that do not occur simultaneously in
specific code pages (collations).
Converting varchar to nvarchar AFAIK should not corrupt any characters.
Collations occur in nvarchar columsn also, because they are responsible not
only for code pages. See BOL for more details.
Regards, Wojtek