On Wed, 3 Jun 2009, user2037(at)ymail(dot)com wrote:
> Strings with null characters produce exceptions when selected or
> inserted. Attempts to select messages with null bytes produces "ERROR:
> insufficient data left in message". And inserting produces "ERROR:
> invalid byte sequence for encoding \"UTF8\": 0x00".
>
> Since a null character is a valid UTF code point why is it rejected by
> the JDBC driver?
Because the server can't handle it. The server is written in C and tracks
all textual data as C strings which are null terminated. It cannot handle
intermediate null bytes, so the driver is just providing that message as
early as possible to you.
Kris Jurka