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

[Jakub Zębalski]

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

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

--
--------------------------------------------------------------------------
Jakub Zebalski
Phone: [phone] or skype: signalbiuro
Mobile: [phone]
e-mail: jakub.zebalski@...

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

[Reizinger Zoltán]

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: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Jakub Zębalski]

Hi,
Unfortunately, it doesn't work either on version: MySQL 5.1.31-1ubuntu2,
I've just checked it on my desktop computer.

Any ideas? Should I change codepage manually in mysql configuration
file?

Thanks for help!

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: users-unsubscribe@...
> For additional commands, e-mail: users-help@...
>

--
--------------------------------------------------------------------------
Jakub Zebalski
e-mail: jakub.zebalski@...

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

[Frank Schoenheit, Sun Microsystems Germany]

Hello Jakub,

> 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

Hmm, can't reproduce it here - however, I am using a 5.1 server.

The MySQL connector works fine here, both in reading and writing such
data, whereas the Connector/ODBC has problems writing it (but no
problems reading it), and the Connector/J (not surprising) has no
problems in reading and writing.


However, I so far failed to completely understand MySQL's character set
/ encoding concept in all facets :), so it might be that there's
something different in the setup of our servers, which I can't imagine
at the moment.

I'd like to encourage you to submit an issue for this, component
"Database Access", sub component "MySQL Connector/OOo", at
http://www.openoffice.org/issues/enter_bug.cgi?component=Database%20access,
for further investigations by our QA team. Sorry for not having any
better idea at the moment.

Thanks & 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@...

[Jakub Zębalski]

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: users-unsubscribe@...
> For additional commands, e-mail: users-help@...
>

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

[Frank Schoenheit, Sun Microsystems Germany]

Hi Jakub,

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

great to hear, thanks for reporting this back.

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