Collation

Hi,
I'm designing a new SQL 2000 DB and now I don't know what collation setting
to use.
The DB will store data for multiple languages ex. Japanese, English, Swedish
etc.
I'v looked at selecting SQL_Latin1_General_CP850_CI_AS, but is this the way
to go?
Any help on this would be appreciated.
Regards,
GoranGoran
Yes , it is ok.
"Goran Dzelovski" <info@.goran.se> wrote in message
news:umwROdDKEHA.1192@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I'm designing a new SQL 2000 DB and now I don't know what collation
setting
> to use.
> The DB will store data for multiple languages ex. Japanese, English,
Swedish
> etc.
> I'v looked at selecting SQL_Latin1_General_CP850_CI_AS, but is this the
way
> to go?
> Any help on this would be appreciated.
> Regards,
> Goran
>|||In addition to the other posts:
The problem is with sorting. The data is stored with a collation, this is tr
ue for Unicode as well. A
collation specifies, among other things, sorting and comparison rules. These
rules are language specific. If
you want the app to behave correctly for multiple languages for these things
, you need to add a COLLATE clause
for your queries that matches the language that the user prefers.
More info:
http://msdn.microsoft.com/library/t...lserver2000.htm
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Goran Dzelovski" <info@.goran.se> wrote in message news:umwROdDKEHA.1192@.TK2MSFTNGP11.phx.gb
l...
> Hi,
> I'm designing a new SQL 2000 DB and now I don't know what collation settin
g
> to use.
> The DB will store data for multiple languages ex. Japanese, English, Swedi
sh
> etc.
> I'v looked at selecting SQL_Latin1_General_CP850_CI_AS, but is this the wa
y
> to go?
> Any help on this would be appreciated.
> Regards,
> Goran
>|||Ok, thanks a lot for your help.
/Goran