MySQL Forums
Forum List  »  PHP

charset / collation
Posted by: Andreas Schnederle-Wagner
Date: October 13, 2016 09:20AM

Hey there,
I got a Question about charset / collation when connecting with PHP to Mysql 5.7.

In our CMS I do a "mysql_query("SET NAMES utf8");" directly after connecting to the MySQL Server - now I saw that this SET Command is responsible for about 14% of all Queries we do (~500 Queries / Second) ...
Even if it won't bring much performance I guess - it should bring a bit - right?

Could someone point me in the right Direction which Config Options I must set within MySQL Server Config to get 100% same behaviour as with SET NAMES utf8?
(and where ... under [mysqld] or [client] ... ?)

character set / collation / connection ... ?

Thank you for the help, bye from Austria

Andreas Schnederle-Wagner

Options: ReplyQuote


Subject
Written By
Posted
charset / collation
October 13, 2016 09:20AM
October 13, 2016 09:32AM
October 13, 2016 12:12PM
October 14, 2016 09:17AM
October 14, 2016 02:58AM
October 17, 2016 04:21PM
October 18, 2016 09:41AM
October 18, 2016 11:22AM
October 16, 2016 04:03PM


Sorry, you can't reply to this topic. It has been closed.

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.