July 9, 2003 at 9:27 am
what setting is recommended for multi-lingual database?
(sql server 2000)
July 9, 2003 at 10:56 am
Depends on the languages. For languages of Western European origin the default code page 1252, accent sensitive, should do fine. For other languages you need to pick the appropriate code page for that language or family of languages (e.g. Cyrillic, Kanji, etc.)
July 9, 2003 at 11:38 am
we want a fully lingual database. no limit on # of languages.
July 9, 2003 at 11:49 am
You may use SQL collation as Dictionary order, case-insensitive, for use with the 850 (Multilingual) character set and manage character data in international databases with Unicode nchar, nvarchar, and ntext data types to replace char, varchar, and text data types.
July 10, 2003 at 1:11 am
be aware of the fact that unicodes doubles your space needs and therefore also slows down full-table scans
July 10, 2003 at 7:26 am
so I will be setting this collation at the database level. based on the information here, which collation do I choose from the "Collation Name" in E.M. when creating a new database?
July 10, 2003 at 9:53 am
You can specify collations at several levels in SQL 2000. The default collation that you select when you install SQL Server, on the database level when you create the database, on the table level when you create a table, and on the column level in a table. There is alot of good info on collations in Books Online, if you haven't already checked it out.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply