Linux · MySQL · Server · Windows

MySQL lower/UPPER casing and ISO 8859, Unicode, UTF-8, UTF-16, UTF-32 Character Set Collations


By default MySQL uses the collation of latin1_swedish_ci character set for all columns. First off in case you are wondering the ci after the second underscore means case insensitive. All SQL queries targeting this column will ignore the letter case of the query values and the field data. Other collations that end with cs are case… Continue reading MySQL lower/UPPER casing and ISO 8859, Unicode, UTF-8, UTF-16, UTF-32 Character Set Collations