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
>|||Hi Goran,
Another way of implementing Multi Language databases is to
use as much as possible unicode columns, nchar, nvarchar &
ntext, which are language independant.
J
>--Original Message--
>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 true 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/techart/intlfeaturesinsqlserver2000.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.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
>|||Ok, thanks a lot for your help.
/Goran