3 ms·
> how am I supposed to store email addresses in a database without collations? Not familiar with MySQL so trying to look that up, but with a constraint? Or jus
by OJFord 4y ago
> how am I supposed to store email addresses in a database without collations?
Not familiar with MySQL so trying to look that up, but with a constraint? Or just don't do that? - SO answer I found says 'it's much more useful to have johndoe@ and JohnDoe@ treated as the same than it is to support case sensitive email addresses'.. ok, it's also incompliant, but whatever's 'more useful’ I guess!