COPY doesn't works with es_ES characters

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

Browse pgsql-bugs by date

  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