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

[kallem]

Hi

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?

[Rabbit]

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.