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

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: [email protected]
> For additional commands, e-mail: [email protected]
> 

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