Bug #37367 enlighten user about (always) required SET NAMES

• Submitted: 12 Jun 2008 13:41
• Modified: 17 Jun 2008 12:53
• Reporter: Sebastian Mendel (Basic Quality Contributor)
• Status: Won't fix
• Category: MySQL Server: Charsets
• Severity: S4 (Feature request)
• OS: Any
• CPU Architecture: Any

[12 Jun 2008 13:41] Sebastian Mendel

Description:
as a phpMyAdmin developer and as participant on MySQL and PHP mailing lists, i often came across problems resulting from charset problems

most of them are the result of wrong charsets which could be easily circumvent if only SET NAMES would be executed first after connecting

most people just do know nothing about SET NAMES and its requiremnt

How to repeat:
read through bug reports and mailing lists

Suggested fix:
 - generate a warning if SET NAMES is not executed first
 - add more documentation about SET NAMES 
 - try to auto-detect and set required charset in connectors
 - add charset option to connect functions in connectors

[13 Jun 2008 12:59] Susanne Ebrecht

Sebastian,

many thanks for writing a bug report.

I can understand your problem very good but we can't change something here.

The only think we (mysql and php) could do is document is as often as possible.

Please ping me on IRC that we can discuss this problem more deep.

[17 Jun 2008 12:53] Sebastian Mendel

yes, but where? on what IRC?

[17 Jun 2008 13:16] Jørgen Thomsen

This bug thread for phpMyAdmin also shows the problem
https://sourceforge.net/tracker/index.php?func=detail&aid=1994160&group_id=23067&atid=3774...

[17 Jun 2008 13:17] Susanne Ebrecht

Sebastian,

just forget my comment. I mixed you with another Sebastian.

Sorry :(

Susanne