DBD::SQLite & accented chars
am 29.12.2005 09:55:54 von rahedHi,
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