Jaume Teixi <[EMAIL PROTECTED]> writes:
> 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!!!
Very odd. What LOCALE and multibyte encodings are you using, if any?
This seems like it must be a multibyte issue, but I can't guess what.
Also, which Postgres version are you running? If you said, I missed it.
regards, tom lane
