Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to store Chinese character in SQL7?Urgent!
- Thread starter anitalulu
- Start date
When installed you probably choose the default collation set for sql server. This basically means you can store just about anything an American key board can put out. However, it cannot store characters outside of that. For this to happen you must change your collation set to allow for Unicode characters or those other characters that come from languages like Chinese, Arabic or Cyrillic.
To do this is going to be a major issue if you already have data in database.
I don't remember all the particulars but I believe you will have to perform a full backup of the data in single user mode. Script all objects (tables, PK, FK, procs, views...) drop all indexes, delete your data, change your collation set, rebuild the master database, run the scripts to recreate your data objects and load the data from the backup.
Before doing this you might want to wait, someone else may have a better solution.
What about it, anyone else have an idea?
To do this is going to be a major issue if you already have data in database.
I don't remember all the particulars but I believe you will have to perform a full backup of the data in single user mode. Script all objects (tables, PK, FK, procs, views...) drop all indexes, delete your data, change your collation set, rebuild the master database, run the scripts to recreate your data objects and load the data from the backup.
Before doing this you might want to wait, someone else may have a better solution.
What about it, anyone else have an idea?
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question