[Dbi-interbase-devel] using utf8 with DBD::interbase

[luc w. <Wil...@pa...>]

	Hello All ,

i'm using the DBD::Interbase , version 0.41 module on a SuSE 8.2  (perl 5.8.0) 
with a interbase 6.0 database and have problems when storing/retrieving utf8 
characters in a varchar field.

When the utf8 string (default format of perl5.8) is stored , the normal utf8 
byte sequence is stored. when this field is restrieved back , it will be 
encoded back into utf8. because  of this , multi byte characters (>127) are 
double encoded . To solve this , i have to decode the string back again and 
mark it as utf8 before i can us is as a utf8 string.
for this , i'm using the "hidden" perl functions 
 ( someone  (DBD or interbase)

Whenis stor a utf8 character string , with valid utf8 charecters (> 127)
and retrieve this text back , it is "double" encoded in utf8 ,

So my question. How can i let DBD::interbase or DBI work correctly with utf8 
characters , knowing that interbase 6 doesn't  know utf8

	luc

-- 
Willems Luc
Email : willems.luc (at) pandora.be
GnuPG public key : http://users.pandora.be/willems.luc/keys/luc.gpg

 We the unwilling,
 led by the unknowing,
 are doing the impossible
 for the ungrateful.
 We have done so much for so long with so little
 We are now qualified to do anything with nothing

see http://www.perl.com/pub/a/2003/07/16/soto2003.html?page=1