Re: [BUGS] BUG #3819: UTF8 can't handle \000

2007-12-17 Thread Franklin Schmidt
On Dec 17, 2007 1:28 AM, Bruce Momjian <[EMAIL PROTECTED]> wrote: > > Well, I realize 0x00 is a valid ASCII value and therefore a valid UTF8 > value but we have never had anyone complain they can't store the 0x00 > character because it doesn't mean anything in ASCII. They use bytea to > store bina

Re: [BUGS] BUG #3819: UTF8 can't handle \000

2007-12-17 Thread Franklin Schmidt
On Dec 17, 2007 12:54 AM, Bruce Momjian <[EMAIL PROTECTED]> wrote: > > Uh, as far as I know 0x00 is not a valid UTF8 byte value. I think it is a valid value. RFC 3629 says: "Character numbers from U+ to U+007F (US-ASCII repertoire) correspond to octets 00 to 7F (7 bit US-ASCII values)." ht

[BUGS] BUG #3819: UTF8 can't handle \000

2007-12-17 Thread Franklin Schmidt
The following bug has been logged online: Bug reference: 3819 Logged by: Franklin Schmidt Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: XP & Linux Description:UTF8 can't handle \000 Details: Trying to store \000 in a text f