Experience with msyql setup for utf-8
Hi to all, I'm checking the setup of a new Koha site, and I'm sure that we will deeply use UTF-8. In /etc/mysql/my.conf, section [mysqld] I have insert: init-connect = 'SET NAMES utf8' character-set-server=utf8 collation-server=utf8_general_ci character_set_client=utf8 In fact is what is written here: http://wiki.koha-community.org/wiki/Encoding_and_Character_Sets_in_Koha Well, if I do a check on mysql with root user I see: mysql> show variables where variable_name LIKE "character_set%" OR variable_name LIKE "collation%"; +--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ | character_set_client | latin1 | | character_set_connection | latin1 | | character_set_database | utf8 | | character_set_filesystem | binary | | character_set_results | latin1 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | | collation_connection | latin1_swedish_ci | | collation_database | utf8_general_ci | | collation_server | utf8_general_ci | +--------------------------+----------------------------+ I use msyql 5.1 on Debian Do you think is a coerent situation ? Which experience do you have with mysql utf-8 setup ? Bye Zeno Tajoli -- Dott. Zeno Tajoli tajoliAT_SPAM_no_prendiATcilea.it fax +39 02 2135520 CILEA - Consorzio Interuniversitario http://www.cilea.it/disclaimer
[mysqld] default-character-set=utf8 character-set-server=utf8 [mysql] default-character-set=utf8 [client] default-character-set=utf8 If you change conf file, please restart service (of course..)
-----Oorspronkelijk bericht----- Van: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] Namens Zeno Tajoli Verzonden: donderdag 22 december 2011 12:48 Aan: koha@lists.katipo.co.nz Onderwerp: [Koha] Experience with msyql setup for utf-8
Hi to all,
I'm checking the setup of a new Koha site, and I'm sure that we will deeply use UTF-8.
In /etc/mysql/my.conf, section [mysqld] I have insert: init-connect = 'SET NAMES utf8' character-set-server=utf8 collation-server=utf8_general_ci character_set_client=utf8
In fact is what is written here: http://wiki.koha-community.org/wiki/Encoding_and_Character_Sets_in_Koha
Well, if I do a check on mysql with root user I see: mysql> show variables where variable_name LIKE "character_set%" OR variable_name LIKE "collation%"; +--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ | character_set_client | latin1 | | character_set_connection | latin1 | | character_set_database | utf8 | | character_set_filesystem | binary | | character_set_results | latin1 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | | collation_connection | latin1_swedish_ci | | collation_database | utf8_general_ci | | collation_server | utf8_general_ci | +--------------------------+----------------------------+
I use msyql 5.1 on Debian
Do you think is a coerent situation ?
Which experience do you have with mysql utf-8 setup ?
Bye Zeno Tajoli
-- Dott. Zeno Tajoli tajoliAT_SPAM_no_prendiATcilea.it fax +39 02 2135520 CILEA - Consorzio Interuniversitario http://www.cilea.it/disclaimer _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Zeno Tajoli <tajoli@cilea.it>
Well, if I do a check on mysql with root user I see: mysql> show variables where variable_name LIKE "character_set%" OR variable_name LIKE "collation%";
mysql lies as root. Use another user. Regards, -- MJ Ray (slef), member of www.software.coop, a for-more-than-profit co-op. Webmaster, Debian Developer, Past Koha RM, statistician, former lecturer. In My Opinion Only: see http://mjr.towers.org.uk/email.html Available for hire for various work http://www.software.coop/products/
On Fri, Dec 23, 2011 at 5:05 AM, <mjr@phonecoop.coop> wrote:
Zeno Tajoli <tajoli@cilea.it>
Well, if I do a check on mysql with root user I see: mysql> show variables where variable_name LIKE "character_set%" OR variable_name LIKE "collation%";
mysql lies as root. Use another user.
Regards, -- MJ Ray (slef), member of www.software.coop, a for-more-than-profit co-op. Webmaster, Debian Developer, Past Koha RM, statistician, former lecturer. In My Opinion Only: see http://mjr.towers.org.uk/email.html Available for hire for various work http://www.software.coop/products/
True, Here is our mysql with koha db and user +--------------------------+----------------------------+ | 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/share/mysql/charsets/ | | collation_connection | utf8_general_ci | | collation_database | utf8_unicode_ci | | collation_server | utf8_unicode_ci | +--------------------------+----------------------------+ Regards, Koustubha Kale Anant Corporation Contact Details : Address : 103, Armaan Residency, R. W Sawant Road, Nr. Golden Dyes Naka, Thane (w), Maharashtra, India, Pin : 400601. TeleFax : +91-22-21720108, +91-22-21720109 Mobile : +919820715876 Website : http://www.anantcorp.com Blog : http://www.anantcorp.com/blog/?author=2
Hi to all,
I'm checking the setup of a new Koha site, and I'm sure that we will deeply use UTF-8.
In /etc/mysql/my.conf, section [mysqld] I have insert: init-connect = 'SET NAMES utf8' character-set-server=utf8 collation-server=utf8_general_ci character_set_client=utf8
In fact is what is written here: http://wiki.koha-community.org/wiki/Encoding_and_Character_Sets_in_Koha
Well, if I do a check on mysql with root user I see: mysql> show variables where variable_name LIKE "character_set%" OR variable_name LIKE "collation%"; +--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ | character_set_client | latin1 | | character_set_connection | latin1 | | character_set_database | utf8 | | character_set_filesystem | binary | | character_set_results | latin1 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | | collation_connection | latin1_swedish_ci | | collation_database | utf8_general_ci | | collation_server | utf8_general_ci | +--------------------------+----------------------------+
I use msyql 5.1 on Debian
Do you think is a coerent situation ?
Which experience do you have with mysql utf-8 setup ?
Bye Zeno Tajoli
-- Dott. Zeno Tajoli tajoliAT_SPAM_no_prendiATcilea.it fax +39 02 2135520 CILEA - Consorzio Interuniversitario http://www.cilea.it/disclaimer _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Hi, I have been using utf8 extensively on www.granthalaya.org with Koha. FYI my mysql info looks same as yours and I have no faced any utf8 related
On Thu, Dec 22, 2011 at 5:17 PM, Zeno Tajoli <tajoli@cilea.it> wrote: problems once I have setup Zebra to use ICU. Regards, Koustubha Kale Anant Corporation Contact Details : Address : 103, Armaan Residency, R. W Sawant Road, Nr. Golden Dyes Naka, Thane (w), Maharashtra, India, Pin : 400601. TeleFax : +91-22-21720108, +91-22-21720109 Mobile : +919820715876 Website : http://www.anantcorp.com Blog : http://www.anantcorp.com/blog/?author=2
participants (4)
-
Koustubha Kale -
Marcel de Rooy -
mjr＠phonecoop.coop -
Zeno Tajoli