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,
Goran
Goran
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 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/te...server2000.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
sqlsql

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