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

[Kuba Zębalski]

Hi,
I would like to share with you my two notices:

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.

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?

3. OpenOffice is great, you are doing a good job guys!


Regards,

Jakub Zebalski

--
--------------------------------------------------------------------------
Jakub Zebalski
Phone: [phone]
Mobile: [phone]
e-mail: kuba@...

Signal sp. z o.o.
Phone/Fax: [phone],
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
--------------------------------------------------------------------------


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Frank Schoenheit, Sun Microsystems Germany]

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         frank.schoenheit@... -
- Sun Microsystems                      http://www.sun.com/staroffice -
- OpenOffice.org Base                       http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...