pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedInvalid Unicode Character Sequence found
4+ messages / 3 participants
[nested] [flat]
* Invalid Unicode Character Sequence found
@ 2004-03-24 12:24 Bulatovic Natasa <n.bulatovic@zim.mpg.de>
0 siblings, 1 reply; 4+ messages in thread
From: Bulatovic Natasa @ 2004-03-24 12:24 UTC (permalink / raw)
To: pgsql-sql
Hi All,
One very strange problem within the PostgreSql database.
When you issue the following command:
select id, title from docs where title like 'z%'; or
select id, title from docs where title like 'Z%';
It reports the following error:
ERROR: Invalid UNICODE character sequence found (0xc000)
I tried the same query on different tables in different databases -
gives the same error message.
The same error message appears to be even when the table is completely
empty!
Any ideas?
We run postgres 7.3.2 and default charset is UNICODE.
Cheers
Natasa
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Invalid Unicode Character Sequence found
@ 2004-03-26 21:43 Tom Lane <tgl@sss.pgh.pa.us>
parent: Bulatovic Natasa <n.bulatovic@zim.mpg.de>
0 siblings, 1 reply; 4+ messages in thread
From: Tom Lane @ 2004-03-26 21:43 UTC (permalink / raw)
To: Bulatovic Natasa <n.bulatovic@zim.mpg.de>; +Cc: pgsql-sql
"Bulatovic Natasa" <n.bulatovic@zim.mpg.de> writes:
> select id, title from docs where title like 'z%'; or
> select id, title from docs where title like 'Z%';
> It reports the following error:
> ERROR: Invalid UNICODE character sequence found (0xc000)
This is fixed in 7.3.6.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Invalid Unicode Character Sequence found
@ 2004-03-27 10:02 Markus Bertheau <twanger@bluetwanger.de>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: Markus Bertheau @ 2004-03-27 10:02 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Bulatovic Natasa <n.bulatovic@zim.mpg.de>; pgsql-sql
В Птн, 26.03.2004, в 22:43, Tom Lane пишет:
> "Bulatovic Natasa" <n.bulatovic@zim.mpg.de> writes:
> > select id, title from docs where title like 'z%'; or
> > select id, title from docs where title like 'Z%';
> > It reports the following error:
> > ERROR: Invalid UNICODE character sequence found (0xc000)
>
> This is fixed in 7.3.6.
I remember to have stumbled over this bug, too. I poked around in the
code a bit but found nothing that hinted to cause of the bug. So I
wonder what the cause of this bug was?
--
Markus Bertheau <twanger@bluetwanger.de>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Invalid Unicode Character Sequence found
@ 2004-03-29 07:33 Bulatovic Natasa <n.bulatovic@zim.mpg.de>
parent: Markus Bertheau <twanger@bluetwanger.de>
0 siblings, 0 replies; 4+ messages in thread
From: Bulatovic Natasa @ 2004-03-29 07:33 UTC (permalink / raw)
To: 'Markus Bertheau' <twanger@bluetwanger.de>; 'Tom Lane' <tgl@sss.pgh.pa.us>; +Cc: pgsql-sql
Yes, indeed very strange.
However, it is certainly fixed, because I also tried more advanced
version of postgres and this bug was not in there.
Regards
Natasa
> -----Original Message-----
> From: Markus Bertheau [mailto:twanger@bluetwanger.de]
> Sent: Saturday, March 27, 2004 11:02 AM
> To: Tom Lane
> Cc: Bulatovic Natasa; pgsql-sql@postgresql.org
> Subject: Re: [SQL] Invalid Unicode Character Sequence found
>
>
> В Птн, 26.03.2004, в 22:43, Tom Lane пишет:
> > "Bulatovic Natasa" <n.bulatovic@zim.mpg.de> writes:
> > > select id, title from docs where title like 'z%'; or
> > > select id, title from docs where title like 'Z%';
> > > It reports the following error:
> > > ERROR: Invalid UNICODE character sequence found (0xc000)
> >
> > This is fixed in 7.3.6.
>
> I remember to have stumbled over this bug, too. I poked
> around in the code a bit but found nothing that hinted to
> cause of the bug. So I wonder what the cause of this bug was?
>
> --
> Markus Bertheau <twanger@bluetwanger.de>
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2004-03-29 07:33 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-03-24 12:24 Invalid Unicode Character Sequence found Bulatovic Natasa <n.bulatovic@zim.mpg.de>
2004-03-26 21:43 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-03-27 10:02 ` Markus Bertheau <twanger@bluetwanger.de>
2004-03-29 07:33 ` Bulatovic Natasa <n.bulatovic@zim.mpg.de>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox