charset 'autodetect' problem
Posted by: Attila Nemeth
Date: March 30, 2005 03:28PM

Hi all!

I've recently upgraded from MySql 4.0.24 to 4.1.10a.
I have an application using this database via JDBC. MySqlConnector/J 3.0.14 is installed (I've also tried to connect with the latest Connector/J release, I have the same problem).

Here is part of the my.ini file:

[mysqld]
# The TCP/IP Port the MySQL Server will listen on
port=3306

# The default character set that will be used when a new schema or table is
# created and no character set is defined
default-character-set=latin2
default-collation=latin2_hungarian_ci

According to the documentation I've read if a client connects to the database, it should automatically use latin2 now. However, if I write latin2 characters to the database, I get ? characters instead. If I correct them in the database by hand and read them with my app they show up OK.
If I set the connection parameters and 'force' the connection to use latin2, everything is fine.
With version 4.0.24 everthing worked fine.

The problem is, I would like to use another application, of which I don't have the source, so I can't modify the connection parameters - that's why I would need this 'autodetect' feature to work correctly.

Anyone have any ideas?

Thanks,
Attila

Options: ReplyQuote


Subject
Written By
Posted
charset 'autodetect' problem
March 30, 2005 03:28PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.