diff options
| author | Munyoki Kilyungi | 2023-08-11 15:54:42 +0300 |
|---|---|---|
| committer | Munyoki Kilyungi | 2023-08-11 15:54:42 +0300 |
| commit | e06b245b7e5f4c979949bafa76e7e585439a3fc0 (patch) | |
| tree | 1531fc4e67f3020a50987b76b60410a64545b5b2 | |
| parent | 04212b59a0d5c0499fd7a0ae2baf7e46ab9ed7a0 (diff) | |
| download | gn-gemtext-e06b245b7e5f4c979949bafa76e7e585439a3fc0.tar.gz | |
Add fixing broken charsets as an entry to sql-tricks
Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
| -rw-r--r-- | topics/next-gen-databases/sql-tricks.gmi | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/topics/next-gen-databases/sql-tricks.gmi b/topics/next-gen-databases/sql-tricks.gmi index 97c492f..90f7727 100644 --- a/topics/next-gen-databases/sql-tricks.gmi +++ b/topics/next-gen-databases/sql-tricks.gmi @@ -9,3 +9,14 @@ WHERE CCSA.collation_name = T.table_collation AND T.table_schema = "db_webqtl" AND T.table_name = "Investigators"; ``` + +* Fixing broken character-sets: + +``` +ALTER TABLE Investigators CONVERT TO CHARACTER SET BINARY; +ALTER TABLE Investigators CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; +``` + +Read the following for more details: + +=> https://dev.mysql.com/blog-archive/debugging-character-set-issues-by-example/ Debugging character-set issues by example |