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

2011-10-26 Thread Josh Berkus
On 10/19/11 5:41 AM, Robert Haas wrote: > I don't think so. It's not really clear to me what the issue is. Is > there some confusion between the encoding of the file and the encoding > in use in the client session? It's odd that we would have a bug that > only affects win1252. I think it's quit

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

2011-10-19 Thread Robert Haas
On Tue, Sep 6, 2011 at 12:48 PM, Bruce Momjian wrote: > Josh Berkus wrote: >> I have another example of this issue with WIN1252.  This line in a copy >> file: >> >> 659446  828     1       /6???\bH@^W^Za$H???\b???@\\/    No >> valid or unique HTTP objects found in XML response. >> >> Into this tab

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

2011-09-06 Thread Bruce Momjian
Josh Berkus wrote: > I have another example of this issue with WIN1252. This line in a copy > file: > > 659446 828 1 /6???\bH@^W^Za$H???\b???@\\/No > valid or unique HTTP objects found in XML response. > > Into this table: > > Table "public.ep_tests" > Column | Type

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

2011-03-24 Thread Josh Berkus
I have another example of this issue with WIN1252. This line in a copy file: 659446 828 1 /6�\bH@^W^Za$H�\b�@\\/No valid or unique HTTP objects found in XML response. Into this table: Table "public.ep_tests" Column | Type | Modifiers -+--+-

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

2011-03-24 Thread Nathan M. Davalos
l character. -Original Message- From: pgsql-bugs-ow...@postgresql.org [mailto:pgsql-bugs-ow...@postgresql.org] On Behalf Of Nathan M. Davalos Sent: Wednesday, March 23, 2011 7:59 PM To: PostgreSQL Bugs Subject: Re: [BUGS] BUG #5944: COPY FROM doesn't work with international charac

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

2011-03-23 Thread Nathan M. Davalos
ssage- From: John R Pierce [mailto:pie...@hogranch.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&

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

2011-03-23 Thread John R Pierce
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 mailing list. The hex of the file in total is 32.33.30.3

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

2011-03-23 Thread Nathan M. Davalos
] BUG #5944: COPY FROM doesn't work with international characters On 03/23/11 4:32 PM, Nathan Davalos wrote: > ... > SET CLIENT_ENCODING TO 'WIN1251'; > copy tmpintermediate from 'thefile.txt'; > > > Sample contents of thefile: > 230002Alto Des

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

2011-03-23 Thread John R Pierce
On 03/23/11 4:32 PM, Nathan Davalos wrote: ... SET CLIENT_ENCODING TO 'WIN1251'; copy tmpintermediate from 'thefile.txt'; Sample contents of thefile: 230002 Alto Desempeño, S.A. De C.V. When using WIN1251 or WIN1252 I get nothing in the second field, it just ignores the data. Same thing for L

[BUGS] BUG #5944: COPY FROM doesn't work with international characters

2011-03-23 Thread Nathan Davalos
The following bug has been logged online: Bug reference: 5944 Logged by: Nathan Davalos Email address: n.dava...@sharedmarketing.com PostgreSQL version: 9 Operating system: Windows XP/2003 Description:COPY FROM doesn't work with international characters Details: I'm