On Apr 6, 2005 10:22 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> David Gagnon <dgagnon@siunik.com> writes:
> > So am I right ? Is Postgresql using UTF-8 and don`t really understand
> > UNICODE file (UCS-2)? Is there a way I can make the COPY command with a
> > UNICODE UCS-2 encoding
>
> Postgres only supports UTF-8, not any other encoding of Unicode. Sorry.
>
You can use iconv to convert the file on a *nix-like system, and there
may even be a cygwin build if you're on Windows.
http://www.gnu.org/software/libiconv/
--
Mike Rylander
mrylander@gmail.com
GPLS -- PINES Development
Database Developer
http://open-ils.org