| From: | Paolo Supino <paolo(at)telmap(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | unicode error and problem |
| Date: | 2004-03-24 10:33:27 |
| Message-ID: | 143CFA2E3C9B5D459E78DA18E3F15F899AB2AF@plague.telmap.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ogjunk-pg | 2004-03-24 10:37:13 | No pg_hba.conf entry for host localhost (was: Re: createused + createdb problems with passwords) |
| Previous Message | Richard Huxton | 2004-03-24 10:18:03 | Re: createused + createdb problems with passwords |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2004-03-24 13:30:28 | Re: pg_advisor schema proof of concept |
| Previous Message | Richard Huxton | 2004-03-24 10:25:25 | Re: where can I get the HTML docs |