<div class="gmail_quote">On Thu, Dec 22, 2011 at 5:17 PM, Zeno Tajoli <span dir="ltr"><<a href="mailto:tajoli@cilea.it">tajoli@cilea.it</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">

Hi to all,<br>
<br>
I'm checking the setup of a new Koha site, and I'm sure that we will<br>
deeply use UTF-8.<br>
<br>
In /etc/mysql/my.conf, section [mysqld] I have insert:<br>
init-connect = 'SET NAMES utf8'<br>
character-set-server=utf8<br>
collation-server=utf8_general_ci<br>
character_set_client=utf8<br>
<br>
In fact is what is written here:<br>
<a href="http://wiki.koha-community.org/wiki/Encoding_and_Character_Sets_in_Koha" target="_blank">http://wiki.koha-community.org/wiki/Encoding_and_Character_Sets_in_Koha</a><br>
<br>
Well, if I do a check on mysql with root user I see:<br>
mysql> show variables where variable_name LIKE "character_set%" OR<br>
variable_name LIKE "collation%";<br>
+--------------------------+----------------------------+<br>
| Variable_name            | Value                      |<br>
+--------------------------+----------------------------+<br>
| character_set_client     | latin1                     |<br>
| character_set_connection | latin1                     |<br>
| character_set_database   | utf8                       |<br>
| character_set_filesystem | binary                     |<br>
| character_set_results    | latin1                     |<br>
| character_set_server     | utf8                       |<br>
| character_set_system     | utf8                       |<br>
| character_sets_dir       | /usr/share/mysql/charsets/ |<br>
| collation_connection     | latin1_swedish_ci          |<br>
| collation_database       | utf8_general_ci            |<br>
| collation_server         | utf8_general_ci            |<br>
+--------------------------+----------------------------+<br>
<br>
I use msyql 5.1 on Debian<br>
<br>
Do you think is a coerent situation ?<br>
<br>
Which experience do you have with mysql utf-8 setup ?<br>
<br>
Bye<br>
Zeno Tajoli<br>
<font color="#888888"><br>
--<br>
Dott. Zeno Tajoli<br>
tajoliAT_SPAM_no_prendiATcilea.it<br>
fax +39 02 2135520<br>
CILEA - Consorzio Interuniversitario<br>
<a href="http://www.cilea.it/disclaimer" target="_blank">http://www.cilea.it/disclaimer</a><br>
_______________________________________________<br>
Koha mailing list  <a href="http://koha-community.org" target="_blank">http://koha-community.org</a><br>
<a href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br>
<a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
<br>
</font></blockquote></div>Hi,<br>
I have been using utf8 extensively on <a href="http://www.granthalaya.org">www.granthalaya.org</a> with Koha.<br>
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.<br>
<br clear="all">Regards,<br>Koustubha Kale<br>Anant Corporation<br><br>Contact Details :<br>Address  : 103, Armaan Residency, R. W Sawant Road, Nr. Golden Dyes Naka, Thane (w),<br>                Maharashtra, India, Pin : 400601.<br>

TeleFax  : +91-22-21720108, +91-22-21720109<br>Mobile     : +919820715876<br>Website  : <a href="http://www.anantcorp.com/" target="_blank">http://www.anantcorp.com</a><br>Blog : <a href="http://www.anantcorp.com/blog/?author=2" target="_blank">http://www.anantcorp.com/blog/?author=2</a>