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 quite

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 br...@momjian.us 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???@\\/    pp/ppNo valid or unique HTTP objects found in XML response./p/p

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???@\\/pp/ppNo valid or unique HTTP objects found in XML response./p/p 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 Nathan M. Davalos
...@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 characters AcNumber character varying(20), AcName character varying(50

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�@\\/pp/ppNo valid or unique HTTP objects found in XML response./p/p Into this table: Table public.ep_tests Column | Type | Modifiers

[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:

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

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 Desempeño, S.A. De C.V. When using WIN1251 or WIN1252 I

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

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

2011-03-23 Thread Nathan M. Davalos
[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't go through the character in question