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