MySQL Bugs: #5858: It is impossible to read tables information from databases made in different co

Bug #5858	It is impossible to read tables information from databases made in different co
Submitted:	2 Oct 2004 11:44	Modified:	2 Oct 2004 21:14
Reporter:	k iv	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQLCC	Severity:	S2 (Serious)
Version:		OS:	Linux (Linux, may be others also)
Assigned to:		CPU Architecture:	Any

Description:
It is impossible to read tables information from databases made in different codepages. This is a usability problem for MySQL software (not only MySQLcc). If some databases are made using different code pages like Microsoft CP-1251, KOI8-R and Unicode it is a chalenge to manage them from the same MySQLcc installation. For example I am using SuSE 9.1 where Unicode is used. Nor MySQL commandline nor MySQL GUI software allows the user to switch code pages for particular table_views/databases. This is a problem when trying to manage tables with information written in different than Latin letters (For example - Cyrillic). Please if possible consider to made possible to
change the code pages in your tables views and may be for databases dump information. This will allow users to manage tables either in Unicode either in any other code pages and will be a good feature.

How to repeat:
Please use SuSE 8.1 and SuSE 9.1 installations. Try to made 2 data bases. Create 1 table in each. Made some VARCHAR field and put some non Latin (Cyrillic) data. Let first database will be made with CP-1251 and second with Unicode. Then please, try to manage them with MySQLcc from SuSE 8.1 and then witth MySQLcc from SuSE 9.1. From SuSE 9.1 you will see the CP1251 text data as non readable letters. The same will happen if you will try to do the same from SuSE 8.1 with the Unicode database.

Suggested fix:
1. If you will made available a new item in GUI menu, like View --> Character Coding --> *some code pages* (a menu like in any WEB Browser to choose the correct code page) it will solve the problem.
2. In more sofisticated software may be it could be made to know about code pages for the particular tables and show them corectly (Like some Microsoft software does it).
3. For command line tools I do not have idea how to solve this problem.

Thank you for your bug report!

We are only currently fixing critical bugs with control center as it is being
end-of-lifed and replaced by the new Administrator and Query Browser tools.

Best Regards

This problem is available in most MySQL software.
If you are only currently fixing critical bugs with control center as it is being end-of-lifed  please try to implement the proposed functionality in the replacement software.
Would you like this problem to be reported for every one affected MySQL software separately instead for MySQLcc? If so I can check it for all your software and post bug reports where aplicable.