Non English characters not recognized

asked 2019-11-18 22:15:20 +0100

vuille-jp gravatar image

I have contacts names and addresses in MySQL database. I connect to LO Writer, Calc or Base with ODBC. Tables open in LO but all non English characters are replaced by question marks. When I select the data source, I specify Unicode UTF-8 character set. I tried several other character sets, no success. My database collation is UTF8_general_ci This problem does not appear in MS Office Word or Excel. Data from same MySQL database connected with ODBC show all special characters OK (especially in French and German). What did I miss?

edit retag flag offensive close merge delete