Link to home
Start Free TrialLog in
Avatar of Dag-Egil
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+
Avatar of reb73
reb73
Flag of Ireland image

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?

 
Avatar of Dag-Egil
Dag-Egil

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
Avatar of reb73
reb73
Flag of Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
OK, thanks a lot! I guess I stick to my non-unicode file as a permanent solution.
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.