Apache OpenOffice (AOO) Bugzilla – Issue 114618
Hebrew bug in mySQL database
Last modified: 2010-09-21 10:56:04 UTC
I have a Java application where I enter names etc in Hebrew. The application stores the information in a mySQL database. The application can read and write to the mySQL database with no problems. As an additional way to reach the database I want to use OpenOffice. I open the database and click on the Tables icon at which point it asks me for the password. Then I double click on one of the tables and it contents are displayed with Hebrew characters showing correctly. Up to this point, all is well. The problem comes if I want to modify one of the values. If I write Latin characters, or numbers, no problem. Even if I write the exact same Hebrew characters, no problem. On the other hand if I make a real change in the Hebrew characters, there is a problem. On a Windows XP machine it will pop up an error message saying I have illegal characters showing 0xE9,0xE7 or something similar. On an Ubuntu machine, no error message pops up but my Hebrew text turns into "???? ??". Thanks, Ilan
Please add some information about MySQL version, Connection type (JDBC, ODBC, native), driver version. You try to modify records, in Table Data View, or with form? On Ubuntu use OOo from Ubuntu or downloaded and installed from OOo site?
Created attachment 71773 [details] odb file
Sorry about the missing information. I will try to complete it. On XP I am running MySQL Server 5.0. My Ubuntu machine is not presently available, but I assume it is the same. I generally try to get all Ubuntu stuff directly from the repository (at least when possible). The Ubuntu is 10.04. From the odb file I see: java-driver-class="com.mysql.jdbc.Driver". (I will try to attach the odb file so you can see all the details.) Since I am using OO only as a "backup", I use the Table Data view and no form. Ubuntu comes native with OO, so it is from the repository. I have been using OO for years on XP and long ago erased Microsoft Office from my disk. Please let me know any way I can help.
In your setting I found that, your connection to MySQL you use Hebrew (ISO 8859-8) character set. I think this is the problem, OOo support UTF-8 coding. Change MySQL database/table coding to UTF-8 in any MySQL tool, in OOo you can not change it.
In my case the Java application is the primary owner of the database. OO is an additional method of looking at this data. My question is what will happen to all the data which is already in the database if I change to UTF-8? I certainly don't want to lose my data. I no longer remember why I chose the Hebrew character set instead of UTF-8. There may have been an issue with something in Java. In any case it seems not unreasonable to choose a Hebrew character set if I am working with Hebrew.
OOo support UTF-8, if you not change coding you can not edit data in OOo. Then you use java. I set it as invalid, and close. If you can give us more information with UTF-8 coded table, feel free to reopen it.
Invalid-> Closing.