Skip site navigation (1) Skip section navigation (2)

Re: BUG #5944: COPY FROM doesn't work with international characters

From: John R Pierce <pierce(at)hogranch(dot)com>
To: "Nathan M(dot) Davalos" <n(dot)davalos(at)sharedmarketing(dot)com>, PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #5944: COPY FROM doesn't work with international characters
Date: 2011-03-24 00:54:12
Message-ID: 4D8A9634.2060201@hogranch.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On 03/23/11 5:42 PM, Nathan M. Davalos wrote:
> Just in case the reply didn't go through the character in question is F1.
>
> I replied to the message using  pgsql-bugs(at)postgresql(dot)org, but I'm a wee bit new to the bug reporting stuff using the mailing list.
>
> The hex of the file in total is
> 32.33.30.30.30.32.09.41.6C.74.6F.20.44.65.73.65.6D.70.65.F1.6F.2C.20.53.2E.41.2E.20.44.65.20.43.2E.56.2E.0D.0A

k, thats certainly win-1252.  I see a tab after the 230002, then the 
rest of it is all one field, ending in a <CR><LF> sequence.


The table you're copying this data to, what fields does it have?

In response to

Responses

pgsql-bugs by date

Next:From: Nathan M. DavalosDate: 2011-03-24 00:59:01
Subject: Re: BUG #5944: COPY FROM doesn't work with international characters
Previous:From: Nathan M. DavalosDate: 2011-03-24 00:33:36
Subject: Re: BUG #5944: COPY FROM doesn't work with international characters

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group