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 |
|
Celia
Starting Member
8 Posts |
 Posted - 2005-06-30 : 12:04:55
|
| Hello.I'm extracting data from a data base in SQL Server (Windows) through BCP queryout. Some of the fields I'm extracting are stored in char or varchar fields, even when they have spanish characters and they must be downloaded using Unicode so these characters aren't loose. My BPC statement is:BCP... -wWhen I have data in flat files, I move them by FTP (binary) to an Unix server to load them into an Oracle data base. My Oracle data base is ready to accept UTF-8.I suppose SQL Server is using Unicode UTF-16. I'm using Unix commands:/usr/bin/iconv/usr/local/bin/iconvto convert UTF-16 file to UTF-8, but it doesn't work.Do you know how to export data from SQL Server with Unicode UTF-8, instead of UTF-16?Do you have any idea on how make compatible Unicode formats between Windows and Unix?Thanks |
|
|
Celia
Starting Member
8 Posts |
Posted - 2007-06-28 : 09:19:23
|
| Just in case this issue can be interesting for anybody, I found out sometime ago that SQL Sever uses UTF-16LE (UTF-16 Little Endian).[url]http://en.wikipedia.org/wiki/UTF-16[/url]This way I could solve this problem. |
 |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2007-06-28 : 11:21:29
|
| This must be nearly a record between a question being posed and an answer being received.....even when it was answered by the same person! I hope this problem got solved far faster than the elapsed time. Welcome back!! |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-06-28 : 11:29:08
|
| Even though there is big latency between question posed and answered, I really liked the spirit of posting solution for others' benefit. Especially, when there are so many around here who don't care to reply back once they get solution.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-06-28 : 12:38:39
|
should have waited 2 more days to post the answer though.  Celia, you must have a good memory!
elsasoft.org |
|
|
|
Celia
Starting Member
8 Posts |
Posted - 2007-06-29 : 03:03:03
|
| I could solve the problem quite a long time ago. Finding the solution was kind of hard. I forgot I have asked here for help, that's why I didn't post the reply before.Regards,Celia |
|
|
|
|
|
|
BCP out: UTF-16 to UTF-8