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

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

From: "Nathan M(dot) Davalos" <n(dot)davalos(at)sharedmarketing(dot)com>
To: "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:59:01
Message-ID: 2701CF596B80DC44815FDBFFF5881A1E0104C331@exchange01.sharedmarketing.com (view raw or flat)
Thread:
Lists: pgsql-bugs
AcNumber character varying(20),
AcName character varying(50)

The database itself is:
       ENCODING = 'UTF8'
       TABLESPACE = pg_default
       LC_COLLATE = 'English_United States.1252'
       LC_CTYPE = 'English_United States.1252'



-----Original Message-----
From: John R Pierce [mailto:pierce(at)hogranch(dot)com] 
Sent: Wednesday, March 23, 2011 7:54 PM
To: Nathan M. Davalos; PostgreSQL Bugs
Subject: Re: [BUGS] BUG #5944: COPY FROM doesn't work with international characters

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: Viner, AdrianDate: 2011-03-24 09:12:12
Subject: Service Wont Start
Previous:From: John R PierceDate: 2011-03-24 00:54:12
Subject: Re: BUG #5944: COPY FROM doesn't work with international characters

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