With Mysql 5 and CF 8 I needed to add this connection string to the datasource:
jdbc:mysql:// 127.0.0.1:3306/utf8demo?allowMultiQueries=true&characterEncoding=UTF8&characterSetResults=UTF8 Also the charset I used in MySql was: utf8 the colation was: utf8_general_ci; After that I was able to insert all the funny accents, Russian charsets and Asian charsets. Paul. On Wed, Feb 18, 2009 at 9:39 AM, Paul Hastings <p...@sustainablegis.com>wrote: > > Mike Little wrote: > > can anyone see what i may be doing wrong? > > what db driver (ie JDBC or ODBC, should be JDBC driver)? what ver of cf > (should > be something newer than cf5)? > > can you post the input code? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319485 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4