| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk> |
| Cc: | Jaume Teixi <teixi(at)6tems(dot)com>, pgsql-hackers(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org, "Richard T(dot) Robino" <rickspam(at)wavedivision(dot)com>, Stefan Huber <schweinsaug(at)crosswinds(dot)net> |
| Subject: | Re: COPY doesn't works when containing ' ' or ' ' characters on db |
| Date: | 2001-02-27 17:19:01 |
| Message-ID: | 3309.983294341@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-hackers |
"Oliver Elphick" <olly(at)lfix(dot)co(dot)uk> writes:
> I think this happens when the front-end encoding is SQL_ASCII and the
> database is using UNICODE. Then, there are misunderstandings between
> front-end and back-end, so that a single character with the eighth bit
> set may be sent by the front-end and interpreted by the back-end as the
> first half of a UNICODE two-byte character.
I wondered about that, but his examples had one or more characters
between the eighth-bit-set character and the '|', so this doesn't seem
to explain the problem.
Still, if it went away after moving to ASCII encoding, it clearly is
a multibyte issue of some sort.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | lbottorff | 2001-02-27 21:55:46 | pg_hba.conf changes have no effect on cygwin/NT 4.0 |
| Previous Message | Alfonso Peniche | 2001-02-27 17:01:11 | Re: CHAR vs VARCHAR |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | The Hermit Hacker | 2001-02-27 17:26:03 | Re: Re[3]: Re: [PATCHES] A patch for xlog.c |
| Previous Message | Matthew Kirkwood | 2001-02-27 17:17:24 | Re: A patch for xlog.c |