Re: confusing invalid UTF8 byte sequence error - Mailing list pgsql-hackers

From Valentine Gogichashvili
Subject Re: confusing invalid UTF8 byte sequence error
Date
Msg-id CAP93muUiXM6M9Y20oBZD7F7GQ_m=Oh1gcKr3hNH3G8Ruv4Ng9w@mail.gmail.com
Whole thread Raw
In response to confusing invalid UTF8 byte sequence error  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: confusing invalid UTF8 byte sequence error
List pgsql-hackers
Has anyone else ever found this error message confusing:
ERROR:  22021: invalid byte sequence for encoding "UTF8": 0xdb24
I think what is really meant is better expressed like this:
ERROR:  22021: invalid byte sequence for encoding "UTF8": 0xdb 0x24
Otherwise it looks like a codepoint or a 16-bit word (endianness?) or
who knows what.

Talking about this error, I find the lack of context in this error message more confusing... relative position or surrounding charachters would be really helpful, when searching for a problem with encoding... 

-- Valentine Gogichashvili

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Displaying accumulated autovacuum cost
Next
From: Tom Lane
Date:
Subject: Re: spinlocks on HP-UX