| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Viner, Adrian | 2011-03-24 09:12:12 | Service Wont Start |
| Previous Message | John R Pierce | 2011-03-24 00:54:12 | Re: BUG #5944: COPY FROM doesn't work with international characters |