Hi, OK, now I have polish letters (ąśćźżęłóń) in OpenOffice when using MySql Native connector. I figured it out, that this connector, the same as JDBC connector, handles connection's code page different than ODBC connector. This is why my database with default charset being latin1 -- cp1252 West European worked fine with polish letters only when using OpenOffice and ODBC.
I changed database properties to below settings: Character set: utf8 -- UTF-8 Unicode Collation: utf8_polish_ci Quite obvious! and now I have polish letters using all three connectors (native, ODBC and JDBC). Jakub Dnia 2009-10-07, śro o godzinie 14:30 +0200, Reizinger Zoltán pisze: > Hi Jakub, > > Jakub Zębalski írta: > > Hi Frank, > > Thank you for your reply. > > I'm sorry I am replying so late, but somehow I did not receive your > > reply by email, but I found it accidentally in google when searching for > > solution. > > > > 1. The problem is with some letters typical for polish alfabet like > > ąśćźżęłóń. > > When I use MySql 5.1.5 odbc connector, OpenOffice Base shows these > > letters properly (I just select UTF8 coding in oo connector properties). > > > > When I use MySQL Connector for OpenOffice.org, polish letters are > > displayed improperly. > > Also when I type some new polish letters, after updateing the record I > > see question marks intead of them. > > > > I use Ubuntu Server with default instalation of MySql server, version: > > MySQL 5.0.51a-3ubuntu5.4 > > > > > > > Needs MySQL 5.1 or newer version. > Zoltan > > 2. I hope you will add this option from my proposal 2 below. For person > > with really many complicated queries inside macros it is really time > > consuming to switch to native mysql connector. > > > > > > Thank you in advance for your reply! > > > > > > > > > > Hi Jakub, > > > > > > sorry for the late response, but I hope late is better than never :) > > > > > >> 1. I'm having problems with polish letters in my database. > >> I'm using Ubuntu with OpenOffice 3.1 which connects to MySql server > >> through ODBC. The code page was set up automatically by OpenOffice and > >> only in OpenOffice Base polish letters look fine. > >> In MySql Query Browser, for e.g., there is no polish letters in that > >> database. > >> When I installed Sun MySQL Connector, I noticed there there were no > >> polish signs and it was not possible to set up the code page. > >> > > > > I do not completely get you here, sorry. Can you please describe in more > > detail what you're doing? Where do you enter the polish letters (in > > Base, or by other means)? Also, what does it mean that in Base the > > polish letters look fine, but with the MySQL Connector, there were no > > polish signs? > > > > > >> 2. Query paths comparison: native mysql driver to ODBC. > >> When you use OpenOffice and ODBC, when writing queries, there is no > >> neeed to write database name in query. You set it up only once, in > >> connection preferences. > >> In native mysql connector it works like JDBC, you have to repeat the > >> database name in every query. > >> Would it be possible to skip repeating the database name in query in > >> case when you type the database name in connection preferences? > >> > > > > Hmm, that'd be difficult. Not necessarily technically difficult, but: > > With the MySQL Connector, you see all databases on the server (which you > > have access to, of course). So, a statement like "SELECT * FROM <table>" > > is potentially ambiguous. > > > > (Note we prefer so understand this "all databases"-thing a feature, not > > a bug :), though future versions might allow to optionally disable it.) > > > > Ciao > > Frank > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
