https://bugs.freedesktop.org/show_bug.cgi?id=70850

[email protected] changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |NOTABUG

--- Comment #17 from [email protected] ---
Since no one else can see this problem, and two different client front ends
have the same problem on my network, the problem may be in my database server. 

I have spent more time investigating Mysql (MariaDb) options.  I could find
nothing that implied my server was configured to only handle characters <= x00,
and since it clearly does store characters >x00, and MySql(Native) works, I had
previously assumed it couldn't be the server configuration.

It was suggested elsewhere that I execute a mysql command:

  show variables like 'char%';

This showed that both the 'character set database' and 'character set server'
was Latin1.  I added:

[mysqld]
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8

to /etc/mysql/my.cnf.

The problem has now been resolved.  As far as I know I never set any of these
options previously, and never saw any need since it all worked properly,
storing characters well above x2000.  

I don't pretend to understand it, but all is now well with Mysql(JDBC).  Why
MySql(Native) was unaffected I will never know. 

I have accordingly closed the bug report.

I thank those who spent valuable time testing it for me previously.  I can only
assume their base mysql configuration was all utf8.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to