Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #5944: COPY FROM doesn't work with international characters - Mailing list pgsql-bugs

From John R Pierce
Subject Re: BUG #5944: COPY FROM doesn't work with international characters
Date
Msg-id 4D8A9634.2060201@hogranch.com
Whole thread Raw
In response to BUG #5944: COPY FROM doesn't work with international characters  ("Nathan Davalos" <n.davalos@sharedmarketing.com>)
Responses Re: BUG #5944: COPY FROM doesn't work with international characters
List pgsql-bugs
Tree view 
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@postgresql.org, but I'm a wee bit new to the bug reporting stuff using the
mailinglist. 
>
> 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?

pgsql-bugs by date:

Previous
From: "Nathan M. Davalos"
Date:
Subject: Re: BUG #5944: COPY FROM doesn't work with international characters
Next
From: "Nathan M. Davalos"
Date:
Subject: Re: BUG #5944: COPY FROM doesn't work with international characters