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

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


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

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

-- 
--------------------------------------------------------------------------
Jakub Zebalski 
Phone: +48 22 5389 156 or skype: signalbiuro
Mobile: +48 602 265 579 
e-mail: [email protected]

Signal sp. z o.o. 
Phone/Fax: +48 22 538 91 05, +48 22 828 07 53, +48 22 828 15 60,
00-302 Warszawa, ul. Mariensztat 8.
NIP: 526-03-02-700
Rejestr Przedsiębiorców prow. przez Sąd Rejonowy dla m-st. Warszawy
Sąd Gospodarczy, XIX WYDZ. GOSP. KRS 0000185874, KZ 50000PLN
--------------------------------------------------------------------------