Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sql_er
Constraint Violating Yak Guru
267 Posts |
 Posted - 2008-04-16 : 12:00:27
|
| Guys,I am using MSSQL Server 2000. My current version is shown below:Microsoft SQL Server 2000 - 8.00.2040 (Intel X86) May 13 2005 18:33:17 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1) Is it possible to store the words of many different languages in the same table and same column?For example, if I have a table with a column called 'WORD', and I want to store the words in English, Chinese, Greek, Hebrew, and Russian, how could I do that? Is it possible to do?Would having datatype as NVARCHAR be sufficient? What about table and/or column COLLATION?Thanks a lot in advance! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-16 : 13:12:41
|
| Yes you would need nvarchar (or nchar, ntext). Collation is dependent on how you want things sorted, so it depends on your requirement.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
sql_er
Constraint Violating Yak Guru
267 Posts |
Posted - 2008-04-16 : 13:49:45
|
| Are you referring to the ALPHABETICAL sorting?Thank you! |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-16 : 21:57:31
|
| >> What about table and/or column COLLATION?You can specify a collation for the column but not for data row. |
|
|
|
|
|
|
Storing different language words in same table