character_set variables on mysqld start
Posted by:
Aida Jamak
Date: January 24, 2007 07:11AM
Is it possible to set character_set variables on mysqld start? I setup those variables, I even inserted init-connect='SET NAMES utf8' int my.cnf ([mysqld] section), but when I restart mysql, the variables are as they were before I set them to utf8.
I need this because I have an "on insert" trigger that, in some cases, inserts data in another table as well. The data that needs to be inserted is in utf8, and it gets inserted unless it contains special characters (č,š). When there is a special character, the rest of the string is ignored. If a special character is the first character of the string, an empty string gets inserted instead.
When I manually call procedures that the trigger calls, all strings are fine.
The default charset of the database is utf8 and the collation is utf8_bin.
Subject
Views
Written By
Posted
character_set variables on mysqld start
2747
January 24, 2007 07:11AM
1787
February 01, 2007 05:37AM
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.