[PLUG] unicode problem with Postgresql and Perl DBD::Pg

[Chris Jantzen]

On Mon, Feb 16, 2004 at 11:00:38AM -0800, Russell Senior wrote:
> For some random email messages, as I stuff them into a Postgresql
> table's text field via Perl DBD::Pg, I get a message along the lines
> of:
> 
>   DBD::Pg::st execute failed: ERROR:  Unicode characters greater
> than or equal to 0x10000 are not supported at ...
>
[..]
> 
> The email body contains some circumflected character or another.  
> 
> Me caveman.  How make work?

Without details, I'd suggest explicitly specifying the character set
of the data while inserting into the database. It looks like it has
guessed that you're trying to give it 32-bit Unicode, which very few
apps support.

-- 
chris kb7rnl =->
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
URL: <http://lists.pdxlinux.org/pipermail/plug/attachments/20040216/68c8f26f/attachment.asc>