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

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