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)	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Server: Charsets	Severity:	S4 (Feature request)
Version:		OS:	Any
Assigned to:		CPU Architecture:	Any

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

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.

yes, but where? on what IRC?

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

Sebastian,

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

Sorry :(

Susanne

Page generated in 0.039 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.