From e06b245b7e5f4c979949bafa76e7e585439a3fc0 Mon Sep 17 00:00:00 2001 From: Munyoki Kilyungi Date: Fri, 11 Aug 2023 15:54:42 +0300 Subject: Add fixing broken charsets as an entry to sql-tricks Signed-off-by: Munyoki Kilyungi --- topics/next-gen-databases/sql-tricks.gmi | 11 +++++++++++ 1 file changed, 11 insertions(+) (limited to 'topics') 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 -- cgit v1.2.3