Franklin Schmidt wrote: > > 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 field with UTF8 encoding causes an error. I > assume this is because Postgres is written in C, but it's still wrong. A > solution was suggested here: > > http://www.nabble.com/invalid-byte-sequence-for-encoding-%22UTF8%22%3A-0x00- > tp9058998p9096326.html > > "I can think of some ways the server could support it without extensive > changes .. e.g. use a modified UTF8 representation which stores \u0000 as > 0xc0 0x80 internally"
Uh, as far as I know 0x00 is not a valid UTF8 byte value. I suggest you use bytea to store 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 4: Have you searched our list archives? http://archives.postgresql.org
