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 -- - Frank Schönheit, Software Engineer [email protected] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
