>> You also need to consider your collation settings. >> http://msdn.microsoft.com/en-us/library/ms144260.aspx
in this case, no you don't. > values(<cfqueryparam value=#arguments.name# > cfsqltype="cf_sql_varchar">,<cfqueryparam value=#arguments.writer# > cfsqltype="cf_sql_varchar">) if you're using cfqueryparam tags (and you should) you 100% need to set the String Format -- Enable High ASCII characters and Unicode for data sources configured for non-Latin characters *on* for that DSN (it's in the "advanced settings"). and yes it works fine: http://www.sustainablegis.com/unicode/ to test yourself see: http://www.sustainablegis.com/unicode/greekTest.cfm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:338980 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm