Jeff F wrote: >> 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.
if you plan on using unicode, its usually easier if you use utf-8/unicode on the db end of things too. how the data was entered is important, when things go wrong like this very often the encoding used to enter the data is not the same as that used to return it. or its stored in a mangled form that only the original mangler can understand. > 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. getting closer then. >> 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. ODBC? that will mangle your unicode data pretty good, use JDBC instead. possibly the issue. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235420 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
