Apparently you will need to implement a UNICODE aware JDBC driver
http://archives.postgresql.org/pgsql-general/2004-01/msg01649.php
Martín
This email message and any files transmitted with it contain confidential
information intended only for the person(s) to whom this email message is
addressed. If you have received this email message in error, please notify
the sender immediately by telephone or email and destroy the original
message without making a copy. Thank you.
----- Original Message -----
From: "Alvaro Herrera" <alvherre@commandprompt.com>
To: "Martin Marques" <martin@bugs.unl.edu.ar>
Cc: <pgsql-general@postgresql.org>
Sent: Friday, May 11, 2007 9:33 AM
Subject: Re: [GENERAL] UTF-8 to ASCII
> Martin Marques escribió:
>> I have a doubt about the function to_ascii() and what the documentation
>> says.
>>
>> Basically, I passed my DB from latin1 to UTF-8, and I started getting an
>> error when using the to_ascii() function on a field of one of my DB [1]:
>>
>> ERROR: la conversión de codificación de UTF8 a ASCII no está soportada
>
> Well, the to_ascii() documentation says that it only supports LATIN1,
> LATIN2, LATIN9, and WIN1250. This is on a footnote.
>
> I do think that there's something strange on the vicinity anyway,
> because using convert() expliciting the conversion function gives a
> mismatching error for me (local environment is UTF8, as is
> client_encoding):
>
> alvherre=# select convert('Martín' using utf8_to_ascii);
> ERROR: character 0xc3 of encoding "MULE_INTERNAL" has no equivalent in
> "SQL_ASCII"
>
>
> Why on earth is it talking about MULE_INTERNAL?
>
> --
> Alvaro Herrera
> http://www.CommandPrompt.com/
> PostgreSQL Replication, Consulting, Custom Development, 24x7 support
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>