From owner-freebsd-ports@FreeBSD.ORG Tue Aug 16 11:27:14 2011 Return-Path: Delivered-To: ports@FreeBSD.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 11FA8106566B; Tue, 16 Aug 2011 11:27:14 +0000 (UTC) (envelope-from 000.fbsd@quip.cz) Received: from elsa.codelab.cz (elsa.codelab.cz [94.124.105.4]) by mx1.freebsd.org (Postfix) with ESMTP id 5ABA48FC1A; Tue, 16 Aug 2011 11:27:13 +0000 (UTC) Received: from elsa.codelab.cz (localhost [127.0.0.1]) by elsa.codelab.cz (Postfix) with ESMTP id A788328423; Tue, 16 Aug 2011 13:27:11 +0200 (CEST) Received: from [192.168.1.2] (ip-86-49-61-235.net.upcbroadband.cz [86.49.61.235]) (using TLSv1 with cipher DHE-RSA-CAMELLIA256-SHA (256/256 bits)) (No client certificate requested) by elsa.codelab.cz (Postfix) with ESMTPSA id 0F6E928422; Tue, 16 Aug 2011 13:27:09 +0200 (CEST) Message-ID: <4E4A540C.8010503@quip.cz> Date: Tue, 16 Aug 2011 13:27:08 +0200 From: Miroslav Lachman <000.fbsd@quip.cz> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.9.1.19) Gecko/20110420 Lightning/1.0b1 SeaMonkey/2.0.14 MIME-Version: 1.0 To: ale@FreeBSD.org Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 7bit Cc: ports@FreeBSD.org Subject: FreeBSD Port: mysql-server-5.5.15 X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 16 Aug 2011 11:27:14 -0000 Hi, I am trying MySQL 5.5.15 as it is the default version now, but I have a problem with default charset. I used WITH_CHARSET=utf8 WITH_XCHARSET=all WITH_COLLATION=utf8_czech_ci on all our older MySQL servers (5.0 and 5.1). These knobs are no longer available, so how can I set default charset and collation? I tried following in my.cnf [client] default-character-set = utf8 [mysqld] character-set-server = utf8 collation-server = utf8_czech_ci But it gives me mysql> SHOW VARIABLES LIKE '%collation%'; +----------------------+-----------------+ | Variable_name | Value | +----------------------+-----------------+ | collation_connection | utf8_general_ci | | collation_database | utf8_czech_ci | | collation_server | utf8_czech_ci | +----------------------+-----------------+ mysql> SHOW VARIABLES LIKE '%character%'; +--------------------------+----------------------------------+ | Variable_name | Value | +--------------------------+----------------------------------+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | utf8 | | character_set_filesystem | binary | | character_set_results | utf8 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | /usr/local/share/mysql/charsets/ | +--------------------------+----------------------------------+ On an older versions (compiled with WITH_ knobs) I have: mysql> SHOW VARIABLES LIKE '%collation%'; +----------------------+---------------+ | Variable_name | Value | +----------------------+---------------+ | collation_connection | utf8_czech_ci | | collation_database | utf8_czech_ci | | collation_server | utf8_czech_ci | +----------------------+---------------+ mysql> SHOW VARIABLES LIKE '%character%'; +--------------------------+----------------------------------+ | Variable_name | Value | +--------------------------+----------------------------------+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | utf8 | | character_set_filesystem | binary | | character_set_results | utf8 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | /usr/local/share/mysql/charsets/ | +--------------------------+----------------------------------+ Note the difference in collation_connection! Is there any official way to restore the old behavior, or should I locally modify the port to support WITH_ knobs? It seems related to this bug: http://bugs.mysql.com/bug.php?id=34980 Thanks in advance Miroslav Lachman