A module is using DBI to access a Microsoft®-Jet data base engine. "dbi:ADO:Provider=Microsoft.Jet.OLEDB.4.0;Data Source=${path};"
As far as I know, the data base engine stores text using UTF-8. Moreover, I have the habit of using utf-8 within my perl scripts, i.e., I encode my perl scripts with utf-8 and I read and write utf-8 files. Now it seems as if the texts I get from DBI were encoded with ISO-8859-1. Could it be possible that DBI is converting the UTF-8 obtained from the data base to ISO-8859-1? Possibly it considers ISO-8859-1 to be the "default client charset"? I would prefer to get to utf-8 from my data base. How can I get the utf-8 text stored in the data base? I already have tried to find some information about this, but to no avail. Looking for "UTF-8" in the DBI-manpage does not help and also regarding "DBI:Ado" I can not find a solution. Of course, I could convert ISO-8859-1 to UTF-8, but only for characters that can be represented with ISO-8859-1.