Wulf's Various Things

User Tools

Site Tools

Trace: • Convert latin1 MySQL db to utf8 • Sound Switcher Indicator • SQLite Browser • Docker
howto:mysql-latin1-to-utf8

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
howto:mysql-latin1-to-utf8 [2022/03/25 15:42] – Wuffhowto:mysql-latin1-to-utf8 [2023/05/29 11:55] (current) – external edit 127.0.0.1
Line 8: Line 8:
 <code> <code>
 #change default only #change default only
-ALTER TABLE connex.contact CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;+ALTER TABLE tablename CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; 
 +#convert charset of data 
 +ALTER TABLE tablename convert to character set utf8mb4 COLLATE utf8mb4_unicode_ci;
  
-# +#changes for whole database 
-alter table connex.contact convert to character set utf8mb4 COLLATE utf8mb4_unicode_ci;+ALTER DATABASE databasename CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; 
 +ALTER DATABASE databasename convert to character set utf8mb4 COLLATE utf8mb4_unicode_ci;
 </code> </code>
  
howto/mysql-latin1-to-utf8.1648222949.txt.gz · Last modified: (external edit)