Get the App
SLTechnology News&Howtos  ›  Database  › 

Mysql View the database code and modify the code method

Shulou Source: shulou.com Published: 2022-06-01 16:56:39 10月03日 Update

Database coding is very important, if you do not correctly define the code, it will lead to the entire database is garbled, if you set the database to utf8, export to gb2312, definitely garbled, vice versa, you define what encoding, export with what encoding.

1. Check the show variables like 'character_set_database' of the database.

2, create the database and specify the encoding

Create database dc3688 character set utf8;3, modify the encoding format of the database alter database dc3688 character set utf8; database specified encoding and export encoding must be consistent with the article from http://www.dc3688.com/

Tags: Coding data database method garbled important consistent article format affirmation method Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno MariaDB MySQL Microsoft Linux Docker