SHINCHVEN'S HEXO

MySQL Character Set And Collation Fast Note

MySQL Character Set Collation
Count: 172Reading time: 1 min
2020/07/23 Share

MySQL Instance Character Set and Collation

Config via docker-compose File

docker-compose.yml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
version: '3.5'

services:

  mysql:
    image: mysql
    container_name: mysql
    restart: always
    command: [
      'mysqld',
      '--character-set-server=utf8mb4',         # character set server
      '--collation-server=utf8mb4_unicode_ci',  # collation-server
      ...                                       # your other configs
    ]

Config in my.cnf

edit my.cnf file

/etc/mysql/my.cnf
1
2
3
4
5
6
# append character configs to mysqld section of my.cnf file
[mysqld]
... # your other configs
collation-server = utf8mb4_unicode_ci
character-set-server = utf8mb4
init-connect = 'SET NAMES utf8mb4'

restart your mysql service

bash command
1
2
3
systemctl restart mysql
# or
service mysql restart

Database Character Set and Collation

[reference]

1
2
3
4
5
6
7
CREATE DATABASE db_name
    CHARACTER SET `utf8mb4`
    COLLATE `utf8mb4_unicode_ci`;

ALTER DATABASE db_name
    CHARACTER SET `utf8mb4`
    COLLATE `utf8mb4_unicode_ci`;

Table Character Set and Collation

[reference]

1
2
3
4
5
6
7
CREATE TABLE tbl_name (column_list)
    CHARACTER SET `utf8mb4`
    COLLATE `utf8mb4_unicode_ci`;

ALTER TABLE tbl_name
    CHARACTER SET `utf8mb4`
    COLLATE `utf8mb4_unicode_ci`;

Column Character Set and Collation

[reference]

1
2
3
4
5
6
7
8
9
10
11
CREATE TABLE t1
(
    col1 VARCHAR(5)
      CHARACTER SET `utf8mb4`
      COLLATE `utf8mb4_unicode_ci`
);

ALTER TABLE t1 MODIFY
    col1 VARCHAR(5)
      CHARACTER SET `utf8mb4`
      COLLATE `utf8mb4_unicode_ci`;

author: SHINCHVEN

permalink: https://atlassc.net/2020/07/23/mysql-character-set/

date: Thu Jul 23 2020 11:06:25 GMT+0800 (China Standard Time)

updated: Thu Jul 23 2020 11:38:49 GMT+0800 (China Standard Time)

license: Attribution-NonCommercial 4.0 International (CC BY-NC 4.0) - 知识共享署名-非商业性使用 4.0 国际许可协议

CATALOG
  1. 1. MySQL Instance Character Set and Collation
    1. 1.1. Config via docker-compose File
    2. 1.2. Config in my.cnf
      1. 1.2.1. edit my.cnf file
      2. 1.2.2. restart your mysql service
  2. 2. Database Character Set and Collation
  3. 3. Table Character Set and Collation
  4. 4. Column Character Set and Collation
Total : 39
2020
2019
2018
2017
2013
2010
2007
2000
AirPods Pro Apple accessory Aliyun Maven mirror Bandwagonhost VPS Screenshot macOS Windows GitLab docker docker-compose GitLab-runner Nginx Certbot SSL react vue chrome extension Android gitlab-runner gitlab pipeline subtitle VLAN media player VLC RSS Google reader generate artifact OnePlus 8 Series HydrogenOS OxygenOS Android 11 Developer Preview JWT JSONWebToken 微信小程序 Base64 IP whitelist diff defaultChecked Checkbox Ant design MySQL Character Set Collation Evernote 印象笔记国际版 OneNote GFW RecyclerView GHOST IN THE SHELL 2-step authentication 2FA NAS OracleCloud PowerDVD Blu-ray puppeteer commandline terminal DevOps download pending problem Ant Design getFieldDecorator Form User guide Windows Terminal Ant Design Pro i18n FeathersJS FeathersJS client HTTP RESTful CRUD Chinese Translation Community Android Storage Access Framework