Issue 106291 - character set error
Summary: character set error
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Base
Classification: Application
Component: MySQL Connector/OOo (show other issues)
Version: OOo 3.1
Hardware: Other Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: dbaneedsconfirm
QA Contact: issues@dba
URL:
Keywords: needmoreinfo, oooqa
Depends on:
Blocks:
 
Reported: 2009-10-26 15:01 UTC by mag4
Modified: 2009-11-25 11:39 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description mag4 2009-10-26 15:01:11 UTC 
We have a MySQL 5.1.34 server with character set UTF-8 Unicode (utf8) and
collation utf8_general_ci. If we use ODBC connector everything is ok, but if we
use MySQL connector 1.0 accented letters and so on are wrong.
Comment 1 christoph.lukasiak 2009-10-28 12:40:31 UTC 
@mechtilde: may you have a look at it, thx
Comment 2 Mechtilde 2009-11-02 10:16:48 UTC 
I saw it some times before when I used the JDBC driver, nor with the nativ mysql
connector
Comment 3 mag4 2009-11-02 12:24:39 UTC 
Do you need some more info?
Comment 4 Mechtilde 2009-11-22 09:46:54 UTC 
yes can you attach some screenshots showing the problem

Which distribution do you use?

Do you use OpenOffice.org and the mysql connection from that distribution?
Comment 5 mag4 2009-11-25 11:27:34 UTC 
Thank you for your answer, due to your questions we discover that the problem is
not in the MySQL connector but in the ODBC connector.
We verify MySQL tables with Phpmyadmin and we find that accented letters and so
on match perfectly using MySQL connector and mismatch using ODBC connector.
We will now start use MySQL connector in production, correcting the errors due
to the ODBC connector.
I change the issue to INVALID, thank you very much!
Comment 6 Mechtilde 2009-11-25 11:39:08 UTC 
-> closed