>On 10/19/2011 12:11 PM, Mark Mandel wrote: >> Also, you may want to check the advanced datasource settings to see if there >> is a UTF-8 option that needs enabling. > >needed if you're using cfqueryparam (which you should) otherwise unicode >hinting: > >INSERT someTable(SomeTxtColumn) >VALUES (N'someKoreantextGoesHere') > >antique example here: http://www.sustainablegis.com/unicode/greekTest.cfm > >and it goes without saying use the JDBC driver not ODBC link or whatever.
I tried the N' option with and without cfqueryparam and it didn't work. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348219 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm