Dag-Egil
asked on
How to convert content in text file from codepage 65001 (UTF-8) to codepage 1252 during import
I have one textfile containg data in utf-8 format. When I make a new package in the designer i choose codepage 65001 (utf-8), and in the preview window all the characters looks correctly. When I import the file into SQL server and look at the table the characters shows "ugly" (this is for norwegian char). Any idea how to convert the data to codepage 1252 during import to SQL server+
Just to make sure I understood this correctly - are you trying to transparently convert UTF-8 encoded unicode data to be populated into a non-unicode backend table?
ASKER
Yes, that is what I try to do. (I have in the mean time changed how the text file is created, so now I make a non-unicode text file instead, so the "problem" is solved). But I am still interested in if this conversion is possible/recommended.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
OK, thanks a lot! I guess I stick to my non-unicode file as a permanent solution.
ASKER
Was this comment helpful? Yes No
Dag-Egil:
OK, thanks a lot! I guess I stick to my non-unicode file as a permanent solution.
Dag-Egil:
OK, thanks a lot! I guess I stick to my non-unicode file as a permanent solution.