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