On Mon, 19 Mar 2001 18:21:02 -0700, Keary Suska wrote:
>That is probably the issue. You cannot have nulls (\x0) in char fields in
>Postgres. I am not sure about text fields. I would recommend getting a hold
>of Bruce Momjian's Postgres book. The O'Reilly DBI book might cover this as
>well...
I'd check with one of the DBI mailing lists.
The O'Reilly DBI book contains nothing more than the DBD::Pg POD pages
and a discription of the features. And that doesn't look too promising.
It seems to indicate that PostGres just might convert your "text" into
another "character set", and possibly add space padding.
I'd go with base64. Yes, your data size increases by a third. But
neither of the above then hurts: base64 is Ascii, so compatible with any
ordinary character set; and ignores whitespace.
--
Bart.
