[Koha] Searching UTF-8 entries [Koha 3.01.00.002]

H. S. hs.samix at gmail.com
Tue Oct 7 15:26:52 NZDT 2008


On Mon, Oct 6, 2008 at 9:27 PM, Krishnan Mani <krishnanm75 at yahoo.com> wrote:

>
>
> 1.4.3 The MySQL server is it configured to use UNICODE?
>
> NB: mysqld service must be started.
> In a Terminal window, type the command mysql, then an SQL
> to display variables content server configuration.
> Text of query:
>
> show where variable_name variables like 'char%';
> UNQUOTE
>



In mysql that i have, I get this:

mysql> SHOW VARIABLES LIKE 'character\_set\_%';
+--------------------------+--------+
| Variable_name            | Value  |
+--------------------------+--------+
| character_set_client     | latin1 |
| character_set_connection | latin1 |
| character_set_database   | latin1 |
| character_set_filesystem | binary |
| character_set_results    | latin1 |
| character_set_server     | latin1 |
| character_set_system     | utf8   |
+--------------------------+--------+
7 rows in set (0.00 sec)


So even though my system is utf8, mysql databases are being created in
latin1. Is my understanding correct?

Thanks.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20081006/3cb1e096/attachment.htm 


More information about the Koha mailing list