Ryan Mitchell wrote: > Hey > > Im runnign CFMX with mysql as my db. Until about a month a go I was using > access, but now with mysql, when I insert info into a database I get certian > characters (' , ... etc) replaced by just mental stuff. It makes no sense!!
Use cfqueryparam. In the connectionstring, make sure you turn on unicode and specify the charset you are using. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4