DBD::SQLite & accented chars

DBD::SQLite & accented chars

am 29.12.2005 09:55:54 von rahed

Hi,

when doing sql statements through placeholders I can retrieve data from
SQLite DB seemlessly. But when I use do method (e.g. update) with where
clause containing accented strings the chars don't convert to utf-8
corectly and consequently the statement doesn't find any rows.

I use encode function from Encode module to convert Perl strings to
octets before manipulating db data. Using DBD::CSV the same way works
ok.

Does anyone know how to use do methods with DBD::SQLite to get correct
results?

Thank you.

--
Radek