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

Re: COPY doesn't works when containing ' ' or ' ' characters on db

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-adminpgsql-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

In response to


pgsql-hackers by date

Next:From: The Hermit HackerDate: 2001-02-27 17:26:03
Subject: Re: Re[3]: Re: [PATCHES] A patch for xlog.c
Previous:From: Matthew KirkwoodDate: 2001-02-27 17:17:24
Subject: Re: A patch for xlog.c

pgsql-admin by date

Next:From: lbottorffDate: 2001-02-27 21:55:46
Subject: pg_hba.conf changes have no effect on cygwin/NT 4.0
Previous:From: Alfonso PenicheDate: 2001-02-27 17:01:11
Subject: Re: CHAR vs VARCHAR

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