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 |
|
Ravi0435
Starting Member
47 Posts |
 Posted - 2007-08-28 : 16:12:59
|
| hi all, I got a weird problem here, i hope your valuable suggestions will help me in solving it... we extract data from AS400 servers to our Extract Database(SQL Server) using SSIS. The data coming from china has a weird problem, Couple of columns come in chinese language, though we have set the respective columns as nvarchar(50) we see on our extract database that they are not chinese charecters but something really bad data symbols as: (9(+¦2¬ o|a&]2¬ o|a&]+N|( < ........etc.... I hope you are understanding what i mean ...may be i need to do something(probably change some properties) in the SSIS packages which extract data from the AS400 Servers. Has anyone encountered such a problem...I will look forward for your valuable suggestions. thanks,raviNothing much that i can do..!! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-28 : 21:19:08
|
| Need to put N in front of string like N'...' to tell sql the string is in unicode. |
 |
|
|
|
|
|
Problem with unicode characters.