Re: UNICODE problem on 7.4 with COPY

From: "Toby Doig" <toby(at)vibrantmedia(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: UNICODE problem on 7.4 with COPY
Date: 2003-12-01 17:38:44
Message-ID: 1C4B83A46A20F742B5BE5786E5140D8B024B963D@THEXCHBEX.services.byworkwise.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Same error as before

Toby Doig
Software Development Manager
Vibrant Media
toby(at)vibrantmedia(dot)com
0207 239 0134

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Gianni Mariani
Sent: 01 December 2003 16:37
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] UNICODE problem on 7.4 with COPY

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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

Browse pgsql-general by date

  From Date Subject
Next Message Rick Gigger 2003-12-01 17:41:20 Re: Humor me: Postgresql vs. MySql (esp. licensing)
Previous Message Toby Doig 2003-12-01 17:35:33 Re: Postgresql sql query - selecting rows outside a join