>cftalk_list wrote: >> I add data to a record that incluses curly quotes and other stuff, look at >> the data in the table and it looks fine. The characters are there. > >doesn't count and in fact pretty much never counts and very often confuses >people as to what's really happening--stick to what you see in cf delivered >pages. > >what encoding does the db use? how was the data added?
I'm not 100% sure that the database (mysql 5)uses utf-8. The data was added by a simple form on a cfm page to cfquery. > >> Now, when I display the data using coldfusion I get "little boxes". > >which usually means a rendering issue (as opposed to ?s which means your data >went bye-bye). this could result from something as simple as the wrong font to >a > minor encoding issue. That is interesting. I was getting the question marks, until I figured out the connection string to use utf8 on my datasource. Now the squares. > >> Curiously, all works fine on my development windows CFMX7 and mysql5 setup. > >what's different between the 2 servers? Development server is windows, >production server is Linux. On my develpment server, I've using a regular ODBC >datasource and the linux system is using the newest jdbc connector. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235419 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
