Hi Arvydas, just a question concerning the following utf8 statements:
> 2. When you mark UTF-8 checkbox setup does this: > ALTER SCHEMA CHARACTER SET utf8 COLLATE utf8_general_ci > set names utf8 > set character_set_database=utf8 > SET CHARACTER SET latin1 > SET CHARACTER_SET_CONNECTION = utf8 > SET character_set_results = utf8 > SET character_set_server = utf8 It seems to me a contradiction to use the following statements with different character sets: > set names utf8 > SET CHARACTER SET latin1 See: http://dev.mysql.com/doc/refman/5.1/en/charset-connection.html : SET CHARACTER SET x means: SET character_set_client = x; SET character_set_results = x; SET collation_connection = @@collation_database; (Setting collation_connection also sets character_set_connection ) whereas SET NAMES x means: SET character_set_client = x; SET character_set_results = x; SET character_set_connection = x; Therefore, shouldn't it be enough to use: > ALTER SCHEMA CHARACTER SET utf8 COLLATE utf8_general_ci > set names utf8 ? BTW > set character_set_database=utf8 should not be necessary after altering the schema? BTW >SET character_set_server = utf8 should not be necessary after definining the default charset of the database. (and it won't be even possible on an managed server...). Thorsten _______________________________________________ dev-general mailing list [email protected] http://dir.gmane.org/gmane.comp.php.oxid.general
