Re: Sun MySQL Connector/OOo (Beta) - code page + queries path

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]
>