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

Atom · CFML/ColdFusion · RSS

Remove or Clean High / Extended ASCII Characters in ColdFusion for XML Safeness


The other week I was reading Ben's Kinky Solution for removing high characters in ColdFusion strings. It's an unfortunate fact that ColdFusion's own tags do not work very well with the conversion of ASCII high characters. So with this in mind and inspired by the conversation in Ben's post I decided to create a simple… Continue reading Remove or Clean High / Extended ASCII Characters in ColdFusion for XML Safeness