Bug #7782 Crash MySQL administrator when modifing a users fullname

• Submitted: 10 Jan 2005 19:53
• Modified: 11 Feb 2005 20:27
• Reporter: Martijn Starrenburg
• Status: No Feedback
• Category: MySQL Administrator
• Severity: S3 (Non-critical)
• Version: 1.0.18/1.0.19
• OS: Windows (WinXp)
• CPU Architecture: Any

[10 Jan 2005 19:53] Martijn Starrenburg

Description:
When I try to alter a users fullname in MySQL administrator 1.0.18; it will crash completely. Version 1.0.19. gives an error message:
After pressing the apply changes button

-.- A Dialog box with an errormessage: "Error while storing user information" 
-.- And a "Dos box" with an errormessage: 

**Message: [Invalid UTF-8] Error executing query (-?: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

Not a big issue but not nice

How to repeat:
See above

Suggested fix:
please check your code

[11 Jan 2005 14:44] Michael G. Zinner

Could you please drop the mysql.user_info table (if you don't have any important information stored there yet) or convert it to UTF8 ?

In 1.0.18 the mysql.user_info table was created with the current character set of the server. But it should be UTF8 in all cases.

MySQL Administrator 1.0.19 will then re-create the mysql.user_info, this time in UTF8.

Please report if the issue is still present then.

Thanks!

[11 Jan 2005 20:27] Martijn Starrenburg

When I change the mysql.user_info table colomns to UTF8.

Problem gone.

[14 Feb 2005 22:54] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".