Franklin Schmidt wrote: > 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+0000 to U+007F (US-ASCII repertoire) > correspond to octets 00 to 7F (7 bit US-ASCII values)." > > http://www.faqs.org/rfcs/rfc3629.html
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 binary data like 0x00. -- Bruce Momjian <[EMAIL PROTECTED]> http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate