I've been a professional C, Perl, PHP and Python developer.
I'm an ex-sysadmin from the late 20th century.
These days I do more Javascript and CSS and whatnot, and promote UX and accessibility.
The biggest thing I learnt about character sets and mysql was that if they're not explicitly set everywhere, make sure you use mysqldump -r to dump a database and SOURCE to read them back in rather than just redirecting stdin/stdout and expecting it to work.
The biggest thing I learnt about character sets and mysql was that if they're not explicitly set everywhere, make sure you use mysqldump -r to dump a database and SOURCE to read them back in rather than just redirecting stdin/stdout and expecting it to work.
Can you elaborate more on that.