dev-resources.site
for different kinds of informations.
How To Check mysqldump character-set
Published at
6/9/2021
Categories
mysql
mariadb
mysqldump
utf8
Author
katzueno
Author
8 person written this
katzueno
open
Learning from mistake.
mysqldump
doesn't respect database's collation, but mysql client.
Check your mysqldump default character set by typing
mysqldump --help | grep default-character-set
You always want to add --default-character-set
option
Example
mysqldump -h {$host} -u {$db_username} --password="{$db_password}" --default-character-set=utf8mb4 --single-transaction {$db_name} > {$SQL_file_name}
--single-transition
option is my preferences for the database which mainly uses InnoDB
utf8 Article's
23 articles in total
Reading UTF-8 char by char in C
read article
Go's UTF-8 Support: An Interesting Limitation
read article
Convert UTF8 to Windows 1250
read article
What every developer should know about Text Encoding
read article
unexpected EF BB BF
read article
UTF-8 strings in C (3/3)
read article
UTF-8 strings in C (2/3)
read article
Converting UTF (including emoji) to HTML
read article
UTF-8 strings in C (1/3)
read article
How to make all textual response as UTF-8 on Jooby
read article
How To Check mysqldump character-set
currently reading
U+FEFF (Zero-width space) - Fighting an invisible bug.
read article
Every Developer Must know how computer converts characters using UTF
read article
Decoding UTF-8
read article
Convert accentuated character to their ASCII equivalent in PHP
read article
Convert Unicode strings to ASCII with ColdFusion & JUnidecode
read article
Encoding mess with Javascript
read article
Displaying all printable* utf-8 characters using Rust
read article
Basic Latin Emoji-Style Pound Sign is Reserved
read article
Decoding the confusing world of encodings (Part 2)
read article
Decoding the confusing world of encodings (Part 1)
read article
Alien symbols in Jenkins!
read article
Let's Be Familiar with Character Encoding
read article
Featured ones: