Home / server / Questions / 613408
In Process
Dan Hastings
Asked: 2014-07-18 09:54:28 +0800 CST

How to create a new MYSQL charset?

  • 772

I am trying to configure roundcube webmail and I get the error

"Can't initialize character set utf8 (path: /usr/share/mysql/charsets/))"

I fixed this before on my website by adding ;charset=UTF-8 to the end of the "mysql:host=" line for my db connection. This means a utf8 charset exists but it is being picky about the format.

I have tried adding the following to /usr/share/mysql/charsets/Index.xml

<charset name="utf8">
  <family>Unicode</family>
  <description>UTF8 Unicode</description>
  <alias>utf8</alias>
  <collation name="utf8_general_ci" id="33">
   <flag>primary</flag>
   <flag>compiled</flag>
  </collation>
  <collation name="utf8_bin"        id="83">
    <flag>binary</flag>
    <flag>compiled</flag>
  </collation>
</charset>

I still get the same error message. How do i add a new charset or overcome this issue with mysql requiring the charset to be specific.

I have tried searching through the php files for roundcube hoping to find the db connection line so i can add the - to uft8 but i am unable to find it.

linux

0 Answers