COPY FROM encoding error
| От | Arnaud Lesauvage | 
|---|---|
| Тема | COPY FROM encoding error | 
| Дата | |
| Msg-id | 4562D2FE.40007@freesurf.fr обсуждение исходный текст  | 
		
| Ответы | 
                	
            		Re: COPY FROM encoding error
            		
            		 | 
		
| Список | pgsql-general | 
Hi list ! I am trying to migrate a database from MSSQL to PostgreSQL. I created the table in PostgreSQL, and I exported the data as CSV from MSSQL's Enterprise Manager. In the "Export Data" Wizard, I chose the option to export as UNICODE. In PostgreSQL, I try to load the data using : COPY mytable (col1, col2, col3) FROM 'mytable.csv' CSV; But I receive this error after some time : ERROR: invalid byte sequence for encoding "UTF8": 0xff État SQL :22021 Astuce : This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding". Contexte : COPY mytable, line 592680 I think that the encoding is OK because more than 500.000 lines are copied without problem, so there might be just one problematic character here. How can I solve this problem ? Thanks a lot ! -- Arnaud
В списке pgsql-general по дате отправления: