From: | Jaume Teixi <teixi(at)6tems(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | COPY doesn't works with es_ES characters |
Date: | 2001-02-26 14:28:47 |
Message-ID: | 20010226152847.27891183.teixi@6tems.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
I finally percated that when data contains 'ñ' or 'à' it's impossible to
parse trought:
COPY products FROM '/var/lib/postgres/dadesi.txt' USING DELIMITERS '|' \g
it causes:
SELECT edicion FROM products;
edicion
-----------------
España|Nacional <-------puts on the same cell either there's an '|' in
the middle!!!
but changing 'ñ' for n
SELECT edicion FROM products;
edicion
-----------------
Espana <---------------it separates cells ok
so what's my solution for a text to COPY containing such characters?
Postgresql 7.0.2
Debian GNU/Linux 2.2
I have LANG=es_ES on postmaster.init
best regards,
jaume
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-02-26 15:37:04 | Re: Strangeness/bug when working with my own datatype in P ostgreSQL |
Previous Message | pgsql-bugs | 2001-02-26 14:03:18 | JDBC packaging error in 7.0.3 with RPM |