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 |
|
rdano
Starting Member
4 Posts |
 Posted - 2004-08-18 : 15:59:51
|
| Hi all, I am encounter some funny problem. Due to the limitation of the 3rd party software I have to use the chr field to store both English and Chinese. When I import the Chinese from Access and to SQL 6.5 it works fine. I am able to see the character in SQL enterprise manager.But when I try the same thing in the same OS Win2K same locale and have all the code page selected, on a SQL 2000. I got ???? in the table and when I read it, it display ??? as well. Any clue ?Thanks in advance.Rdano |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-18 : 16:23:21
|
| What happens when you view the data in Query Analyzer?Tara |
 |
|
|
rdano
Starting Member
4 Posts |
Posted - 2004-08-18 : 21:43:00
|
When I view the data in the Query Analyzer I got the '?????' in the field.If I enter Chinese to the 3rd party software (front-end) and have it saved to the SQL 2000 (back-end) field then it works ok. I am able to see the Chinese display in the 3rd party software. Although I won't able to see the Chinese in the SQL, instead it is some kinda symbol.However, for the Chinese that I import to the SQL 2000 server I still see the ?????I have all the code page selected on the WIN2K, using Tradition Chinese as default locale, default collate in SQL2000 and using chr data type in the field.Greatly appericated. Thanks. |
|
|
|
rdano
Starting Member
4 Posts |
Posted - 2004-08-21 : 13:12:06
|
| Is there anyone have any ideas on this? It is a SQL2000 issus or I setup something wrongly?Grealy appericated. |
|
|
|
rdano
Starting Member
4 Posts |
Posted - 2004-09-01 : 04:33:51
|
| The most funny thing is even with 6.5 when enter the data in the program front end by copy and paste, some chinese character appears to be ok and some will change to '?'.So it seems like the code page is incorrect?? |
|
|
|
|
|
|
Import Chinese in SQL 6.5 and SQL7