First check that the necessary columns are set to ntext or nvarchar, not text or varchar. If that's not the issue then put the N in front of each, as Paul mentioned. If that doesn't work, then what version of SQL Server are you on ... older versions may not support 8-bit entries ...
>never heard of this happening. what do you mean by "crash"? if you use plain >cfquery w/unicode hinting (ie N'this is unicode text to insert') what happens? >is the table designed to hold unicode data (ie uses the "N" datatypes)? are >you >using the JDBC (labeled "ms sql server") driver? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:328861 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4