Bug #9830 UTF8 Database on Latin1 server

Submitted: 11 Apr 2005 23:40 Modified: 12 Apr 2005 3:25
Reporter: Vivienne Boogaard Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.1.5 OS:Windows (Win2K)
Assigned to: CPU Architecture:Any

[11 Apr 2005 23:40] Vivienne Boogaard
Description:
When trying to connect to a UTF8 database (innodb v4.1.10-standard-log) which exists on a Latin1 server, I am unable to see the table list for the UTF8 schema but I am able to connect to other databases that are Latin1 with the same account and password.  The message "fetching data" remains where the table list would usually display.  This is also a problem for Toad for MySQL but is not a problem for the MySQL Control Center 0.9.4-beta.  I am able to successfully connect using Putty for command line access.

character_set_client = latin1
character_set_connection = latin1
character_set_database = utf8
character_set_results = latin1
character_set_server = latin1
character_set_system = utf8
collation_connection = latin1_swedish_ci
collation_database = utf8_general_ci
collation_server = latin1_swedish_ci

How to repeat:
Create a Latin1 installation and then create a UTF8 database within the installation.

Try to connect to the new UTF8 database.

Suggested fix:
Allow full access to all databases using the relevant collection/character set for the database.
[12 Apr 2005 3:25] MySQL Verification Team
I wasn't able tio repeat with QB 1.1.6.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.045 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
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.