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

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         [email protected] -
- Sun Microsystems                      http://www.sun.com/staroffice -
- OpenOffice.org Base                       http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -