[Koha] Experience with msyql setup for utf-8

[Koustubha Kale]

On Thu, Dec 22, 2011 at 5:17 PM, Zeno Tajoli <tajoli at cilea.it> wrote:

> 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 at 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
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.katipo.co.nz/pipermail/koha/attachments/20111223/a3a21385/attachment.html>