3 ms·
do you have specific example? (sincerely interested)
by jypepin 10y ago
do you have specific example? (sincerely interested)
- eddd 10y agoI'd start with reading this one: https://grimoire.ca/mysql/choose-something-else https://grimoire.ca/mysql/choose-something-else
- mrmondo 10y agoThanks eddd, I would have probably linked to this also, it's easier to point to people who have done proper write-ups than write my own experiences as I think there's enough out there.
- eknkc 10y agoWas just dealing with this today: If some row is deleted due to a foreign key cascade constraint, delete triggers are not executed. When you delete directly, they run obviously. It's worse than having no trigger support.
- rmetzler 10y ago- MySQL example: for MySQL there is one thing called Collation, which decides about the correct ordering of chars in table values. The default was `latin1_swedish_ci` for years, not `utf8_unicode_ci` which might be more sensible. - Postgres Example: to set up Postgres correctly, you need a Postgres user in the OS, who runs the database. That should enforce to not run the database process as root.
- CoachRufus87 10y agoI spent this past week learning/solving this very issue. MySQL's utf8 character set doesn't actually include _all_ utf8 characters. Use utf8mb4 instead. Same goes for collation; use utf8mb4_unicode_ci.
- lathiat 10y agoThe good news is they are changing the defaults in 5.8: http://mysqlserverteam.com/sushi-beer-an-introduction-of-utf8-support-in-mysql-8-0/ http://mysqlserverteam.com/sushi-beer-an-introduction-of-utf...
- rmetzler 10y agoThanks for sharing this. I looked it up on SO [1] and since I'm from Germany, I'll stay with utf8_unicode_ci. > For examples, the Unicode collation sorts "ß" like "ss", and "Œ" like "OE" as people using those characters would normally want, whereas utf8mb4_general_ci sorts them as single characters (presumably like "s" and "e" respectively). [1]: http://stackoverflow.com/a/766996/104959 http://stackoverflow.com/a/766996/104959