<div class="gmail_quote">On Fri, Dec 23, 2011 at 5:05 AM,  <span dir="ltr"><<a href="mailto:mjr@phonecoop.coop">mjr@phonecoop.coop</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">

Zeno Tajoli <<a href="mailto:tajoli@cilea.it">tajoli@cilea.it</a>><br>
<div class="im">> 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>
</div>mysql lies as root. Use another user.<br>
<br>
Regards,<br>
<font color="#888888">--<br>
MJ Ray (slef), member of <a href="http://www.software.coop" target="_blank">www.software.coop</a>, a for-more-than-profit co-op.<br>
Webmaster, Debian Developer, Past Koha RM, statistician, former lecturer.<br>
In My Opinion Only: see <a href="http://mjr.towers.org.uk/email.html" target="_blank">http://mjr.towers.org.uk/email.html</a><br>
Available for hire for various work <a href="http://www.software.coop/products/" target="_blank">http://www.software.coop/products/</a></font></blockquote><div><br>True,<br>Here is our mysql with koha db and user<br><br>

+--------------------------+----------------------------+<br>| Variable_name            | Value                      |<br>+--------------------------+----------------------------+<br>| character_set_client     | utf8                       | <br>

| character_set_connection | utf8                       | <br>| character_set_database   | utf8                       | <br>| character_set_filesystem | binary                     | <br>| character_set_results    | utf8                       | <br>

| character_set_server     | utf8                       | <br>| character_set_system     | utf8                       | <br>| character_sets_dir       | /usr/share/mysql/charsets/ | <br>| collation_connection     | utf8_general_ci            | <br>

| collation_database       | utf8_unicode_ci            | <br>| collation_server         | utf8_unicode_ci            | <br>+--------------------------+----------------------------+<br><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> <br>

</div></div>