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 |
|
dnf999
Constraint Violating Yak Guru
253 Posts |
 Posted - 2008-05-09 : 11:10:56
|
| Hi I need some help importing Chinese characters into my SQL Server 2005 database.I have the data in an access database, which contains a mixture of english and chinese characters.Now when I import this into SQL, the Chinese characters are not imported in correctly.I'm aware of that these characters may need to be imported as unicode, but I don't have an option to change this when importing from the Access table.Please can somebody assist.many thanks! |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2008-05-09 : 11:52:42
|
| have you passed the hurdle of being able to "directly" type, save and display (later) chinese characters into the SQL database?is your database defined with unicode data types Nchar or NVarchar, etc??have you investigated using an intermediatry step, unload to notepad file, re-load from notepad file? |
 |
|
|
dnf999
Constraint Violating Yak Guru
253 Posts |
Posted - 2008-05-09 : 12:00:50
|
| The aim is to get the chinese and english data into the database and convert the Supplier names into chinese via a unique Supplier Number join.I'm new to dealing with foreign characters, so am not sure how to check whether the database is set to unicode data types Nchar or NVarchar. I do know the Supplier table that will need updating has all columns set to nvarchar.Thanks |
|
|
|
Hommer
Aged Yak Warrior
808 Posts |
|
|
|
|
|
Import Chinese Characters help