I'm working on a little app that I need to be able to store and retrieve strings with Unicode characters in them, using MySQL (version 5.0.37).
I'm able to create a table (via phpMyAdmin), set a field to use utf8 in varying ways, and do an insert (again via phpMyAdmin) into said field of a Unicode string. It shows up fine when browsing that way. However, bring CF into it and things go blooey. If I try and query that table, I get question marks for the Unicode characters. If I try and update the field in question via CF (got a tiny form, paste in some unicode, next page updates the record), it mangles said characters and inserts a completely different gibberishy string. I've been Googling around, and the only stuff I can find on this is around two to three years old, and so far, hasn't been a help. One issue is I'm on shared hosting, and have to go through the host's support folks to get some things done that normally I could do myself quickly, so I cannot see what the settings are, much less change them. Any pointers in the right direction would be very appreciated! --Scott ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297788 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4