On Apr 6, 2005 10:22 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > David Gagnon <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] GPLS -- PINES Development Database Developer http://open-ils.org ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
