Database in UTF8 with Coldfusion

When setting up a Coldfusion application, do not forget to add to your datasource the following connection string :

characterEncoding=UTF8&characterSetResults=UTF8

It will ensure that your data is correctly saved and fetched using UTF8. This is the coldfusion equivalent of the more commonly known SET NAMES 'utf8';

Tags : #database, #coldfusion, #utf8

Want to add something ? Feel free to get in touch on Twitter : @pixelastic