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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-11-20 : 07:24:53
|
| newsqlserveruser writes "Hello, We have Microsoft SQL Server 2000 with Service Pack 3a installed. In one of our databases, we have a table REQ with one of the fields COMMENT being defined as TEXT COLLATE SQL_Latin1_General_CP1_CI_AS. Now, when we try to view the COMMENT field, it shows us only English characters whereas the Chinese characters are displayed as ? as the database can support only English characters. Is it possible to store both English and Chinese characters in the same column of a table? If yes, then how can I store both English and Chinese characters in the same column in a table?Thanks in advance. New user. " |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-11-20 : 07:41:00
|
| What is the data type of the column? You need to have unicode data type like NCHAR or NVARCHAR.Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2006-11-20 : 10:32:43
|
| You need to use ntext. Text and Image datatypes are difficult to work with. Can you talk the users down to nvarchar(2000) or so? |
|
|
|
|
|
|
combination of english & chinese characters in same column