By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,558 Members | 1,399 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,558 IT Pros & Developers. It's quick & easy.

sql server generated “Text File” data importing in to postgressql using copy command

P: 6

I have one text file generated using SQLServer 2005. While I am importing the text file into one of my PostgreSQL table using "copy" it is giving me the following error:

ERROR: invalid byte sequence for encoding "UTF8": 0xff

Can any one tell me what i need to do get the data from SQLServer 2005 to PostgreSQL?
Feb 12 '11 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 12,359
Since 0xFF is an invalid UTF8 sequence, the file was encoded with a different character set. You will need to import using that character set.
Feb 12 '11 #2

Post your reply

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