sorry, i have bad English, but i try explain.
i connect libreoffice base with mysql from ODBC
pls see this pictures
i have this problem, this character wrong
and what i setting
Hello,
It appears to be an issue with the ODBC driver being used. Cannot give specific information as I do not have access to Windows. The MySQL ODBC package comes with two drivers - a w version for Unicode and an a version for Ansi. It is possible the wrong one is being used.
See ‘Choosing Unicode or ANSI Driver’ on this MySQL page →
Chapter 4 Connector/ODBC Installation
i found other decision. I use this guide jdbc instruction. But then i did it, I still same problem. I got same wrong character. But i edit on mysql server on linux how show this instruction. Now all work good.
Glad you have it working. For JDBC connector you only need to add ?charSet=UTF-8 to the end of the Datasource URL string. I do this using Firebird server with JDBC connection.