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 |
|
haydn
Starting Member
5 Posts |
 Posted - 2007-09-28 : 16:33:22
|
| Hi,Could someone please tell me how to update data in a column that contains unicode data in SQL 2000?I know how to write update scripts on my own, but when it comes to Unicode character updates I can�ft manage. In the script that I have pasted below I can update the customer�fs details, but this only works if I update with Romaji characters (non-unicode).The data that I need to update is in Japanese Kanji, but when I use the 'Update' script below, the data is updated as all question marks (???????????). Is it very much harder to get the script to where it will handle Unicode characters and insert the correct data? UPDATE CUSTOMER_LANGUAGE_DETAILSSET FIRST_NAME = '‰h�s' WHERE CUSTOMER_ID = 1592 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2007-09-28 : 17:29:54
|
I assume the datatype is nvarchar or ntext? In that case:UPDATE CUSTOMER_LANGUAGE_DETAILSSET FIRST_NAME = N'‰h�s' WHERE CUSTOMER_ID = 1592 --Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
 |
|
|
|
|
|
Updating Unicode Data