-
MODX Staff
- 10,725 Posts
Re: SET NAMES, be aware that MODx now uses SET CHARACTER SET (not SET NAMES) so that you will always be using the proper character set for the database you are connected to (i.e. SET CHARACTER SET will use the database_collation regardless of what you specify as the charset value).
In other words, you can’t override the database charset/collation -- you must set database_connection_charset to match your database to get the proper results.