https://bugs.freedesktop.org/show_bug.cgi?id=68426
Lionel Elie Mamane <lio...@mamane.lu> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |NOTOURBUG
--- Comment #13 from Lionel Elie Mamane <lio...@mamane.lu> ---
Try setting *both* "charset = utf8" in the ODBC DSN being used *and* the
LibreOffice character set option to "Unicode (UTF-8)". If it does not work,
reopen.
The whole story is that:
- LibreOffice and the MyODBC driver on the one hand
- the MyODBC driver and the MySQL server on the other hand
need to agree on what character set to use where. If the MyODBC driver
does conversion, these two decisions need not necessarily match.
My guess is that your LibreOffice is configured to use UTF-16 (because that is
the "System" default), but MyODBC/MySQL configured to use latin1 (the default)
or maybe utf8. Note that AFAIK MySQL does not support using UTF16 (maybe MyODBC
does, not sure).
Where it gets hairy is that MyODBC IMHO is buggy in that respect. Try to create
in MySQL a column with non-ASCII characters in its name. Then set LibreOffice
and MyODBC to "Western (ISO8859-1)" and "latin1", respectively. You'll notice
that the column names comes out wrong.
MyODBC has a "charset" parameter, so when it is set it *must* arrange for
everything to be in that charset when communicating with the application.
MyODC's design is to *not* set that charset for the communication with MySQL,
but to do conversion itself (probably for speed reasons on the server: do more
work on the client, rather than on the server). So it sets the MySQL server
variable character_set_results to NULL (overriding the default). Which leads
MySQL to give column names in character_set_system, which by default is UTF8...
But MyODBC does not do conversion there!
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
