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 |
|
Mr. Chip
Starting Member
1 Post |
 Posted - 2008-04-08 : 23:52:53
|
Hello,I am a brand new member. I wasn't sure which forum to post this question - but this one seemed best. Here is my situation. I have a custom web application that uses MSDE that generates forms for people to complete. I use Enterprise Manager to administer the database. I am not a DBA and do not have a lot of experience writing SQL code.I have one table that has a field specified as nvarchar 4000. This table is part of a web-based form that people complete. Some people typed their answers in Japanese (Kanji). When I use my standard method for exporting the table to Excel, all of the Kanji characters are replaced by ??? When I view the records inside of Enterprise manager I see the same thing.First, does anyone know if the original Kanji characters are somehow stored in the database? My server's default language is English (and I cannot change it to Japanese). So I am hoping (or should I say praying) the data is there and that the problem is that Enterprise Manager and my server do not know how to display it.Assuming the data is there, does anyone know how to use DTS or some other method to export the fields as Unicode text?Characters like & #21488; & #21271; (with spaces added to break the code) would be fine. Or I would be thrilled with actual Kanji like ? ?.Thanks in advance for your help.Chip |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-09 : 00:24:58
|
| I think you need kind of decoding tool for this. |
 |
|
|
|
|
|
Need Help Retrieving Japanese Language