>Collation's not the problem, but the Data Type of your columns might be. >Make sure you're using nvarchar & ntext (not varchar and text) [SQL Server] >and ensure that both page and form encoding allow Unicode, like using >charset UTF-8.
I'll +1 that, the data type is almost always the main culprit, most especially on data inserts or updates, to be 100% sure, set your data type on data insertion by preceding the letter "N" so e.g. <cfquery datasource="#application.dsn#" name="getthedata"> UPDATE tblName SET column = N 'the japanese chararcters' </cfquery> <cfquery datasource="#application.dsn#" name="getthedata"> INSERT INTO (column) VALUES(N'the japanese chararcters') </cfquery> cfqueryparam will do nicely actually...but I usually start with the above as a process of eliminination. The problem was a particular hassle on SQL Server 2K. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323341 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
