COPY doesn't works with es_ES characters - Mailing list pgsql-bugs

From Jaume Teixi
Subject COPY doesn't works with es_ES characters
Date
Msg-id 20010226152847.27891183.teixi@6tems.com
Whole thread Raw
List 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

pgsql-bugs by date:

Previous
From: erik.berglund@eyeone.no
Date:
Subject: The driver told me to do it.
Next
From: Tom Lane
Date:
Subject: Re: Strangeness/bug when working with my own datatype in P ostgreSQL