[Koha] Experience with msyql setup for utf-8

[Koustubha Kale]

On Fri, Dec 23, 2011 at 5:05 AM, <mjr at phonecoop.coop> wrote:

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