Beta Branch update my.cnf templates to default to utf8 instead of latin1 in 123.0…

update my.cnf templates to default to utf8 instead of latin1 in 123.09beta01

For fresh 123.09beta01 installs MariaDB 10.1 now use my.cnf templates which default to utf8 instead of latin1 for each use by folks starting out on Centmin Mod LEMP stacks. Changing charset and collations of MariaDB MySQL is outlined at MariaDB MySQL - CentminMod.com LEMP Nginx web stack for CentOS for server side.

Continue reading...

---

123.09beta01 branch

• Branch: GitHub - centminmod/centminmod at 123.09beta01
• Commit History: Commits · centminmod/centminmod · GitHub

 

that's why it's only set to default to utf8 on fresh centmin mod installs.. if user uses mysqldump of sql file from old server and imports to new utf8 default server should be okay depending on what data is being imported

phpmyadmin users whatever is mysql server default charset and collations.

 

reversed part of these changes due to bug/incorrect variable seems not supported in [client] and [mysql] groups update my.cnf templates to default to utf8 instead of latin1 in 123.0… · centminmod/centminmod@f189cb1 · GitHub

so change

Code (Text):

[client]
socket=/var/lib/mysql/mysql.sock
default-character-set=utf8

[mysql]
default-character-set=utf8

to

Code (Text):

[client]
socket=/var/lib/mysql/mysql.sock

[mysql]

and restart MariaDB mysql server

 

the mysql client errors out on SSH command line. So could be just an issue with [mysql] group set one and not [client] as it seems from help command mysql client doesn't support it in MariaDB and [client] group doesn't need it as it autos to what system/server is set to.

 

what ever character_set_server / character_set_client is set to as outlined at MariaDB MySQL - CentminMod.com LEMP Nginx web stack for CentOS and Setting Character Sets and Collations - MariaDB Knowledge Base (though that article lists default-character-set=utf8 as valid for [mysql] group but mariadb 10.1 didn't like it for my tests hence reversed that change)

 

no.. once mysql is set to default to utf8 as outlined at MariaDB MySQL - CentminMod.com LEMP Nginx web stack for CentOS any mysql database created will default to utf8 regardless of how it's created i.e. via SSH command line or via phpmyadmin etc. Unless you use a php web app script and it installs and creates a mysql database with specifically set character set and collation of it's own as outlined at Setting Character Sets and Collations - MariaDB Knowledge Base

 

reverted for [mysql] not [mysqld]

 

yup

 

not via my.cnf, you do it via mysql database creation routine whether it is via php script you're installing, phpmyadmin set etc. But why latin1 ? any db with UTF8 works fine usually with latin1 anyway.

 

read https://community.centminmod.com/th...ge-the-maximum-column-size-is-767-bytes.9669/

basically developer needs to code their script to detect utf8mb4 and alter the index number characters appropriately