Re: UNICODE problem on 7.4 with COPY

From: Gianni Mariani <gianni(at)mariani(dot)ws>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: UNICODE problem on 7.4 with COPY
Date: 2003-12-01 16:37:02
Message-ID: 3FCB6E2E.70808@mariani.ws
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Toby Doig wrote:
...

>So, what is going wrong? Why can't I import this very simple unicode file?
>I've searched the archives and google, but to no avail.
>
>
try converting the file to utf-8.

iconv -t utf-8 -f utf-16 < unicode-file.txt > utf-8-file.txt

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Graham Leggett 2003-12-01 17:15:40 Postgresql sql query - selecting rows outside a join
Previous Message B. van Ouwerkerk 2003-12-01 16:25:51 Re: PostgreSQL from a newcomers perspective