469,604 Members | 2,235 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,604 developers. It's quick & easy.

SQl Svr 2000 - DTS - Multilingual Data handling

Hi All,

I'm trying to upload a delimited text file containing french characters to SQL server 2000 using DTS. After upload, all the french characters are messed up. I though I dont have some international language support in my Db, but when I tried to update same data using UPDATE command, it works. It means, my SQL DB is able to hold french characters (nVarchar column).
When I tried to open the file in DTS editor and see the preview all the characters are messed up. e.g. "André" gets converted to "André".
I think it is something to do with "file type" property for my "Text File Data source connection" in DTS, but right now it is only giving me options of ANSI, OEM and Unicode, but none of these is working.

Please help..... its very urgent.

Thank you for your help in advance.

Jul 13 '07 #1
1 1747
Ho Yeah. Its ME :-)
My source file was being created as ASCII hence my DTS with ASCII was working, but with no unicode.
Now, I've changed it (text file) to be produced as Unicode. My DTS also changed to Unicode, just WORKS fine. :-)

Thanks you for reading.

Jul 13 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Asim Qazi | last post: by
4 posts views Thread by Jim Adams | last post: by
3 posts views Thread by charliewest | last post: by
7 posts views Thread by Luc The Perverse | last post: by
2 posts views Thread by raju | last post: by
reply views Thread by guiromero | last post: by
reply views Thread by devrayhaan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.