unicode error and problem
От | Paolo Supino |
---|---|
Тема | unicode error and problem |
Дата | |
Msg-id | 143CFA2E3C9B5D459E78DA18E3F15F899AB2AF@plague.telmap.com обсуждение исходный текст |
Ответы |
Re: unicode error and problem
Re: unicode error and problem |
Список | pgsql-general |
Hi I received a unicode CSV file from someone (the file was created on a windows system) and I'm trying to import it into postgresql. When it gets to a line that isn't ascii it prints the following error and aborts: "ERROR: copy: line 33, Invalid UNICODE character sequence found (0xd956)". When I created the db cluster with "-E unicode" and initdb was run with "-E unicode". As I wrote above the file was created on a windows system. I'm trying to import it to postgresql 7.3.5 on a Solaris 9 system. Postgresql was compiled by me with the following configure switches: ./configure --prefix=/usr/local --sysconfdir=/etc --sharedstatedir=/usr/local/share --localstatedir=/var --enable-locale --enable-recode --enable-multibyte --enable-nls --with-java --with-openssl=/usr/local --with-CXX --enable-syslog --with-includes=/usr/local/include --with-libraries=/usr/local/lib. Anyone knows how to solve this problem so that the file will be imported properlly?
В списке pgsql-general по дате отправления: