> I have a number of tables in a SQL Server database that > have the NVarchar datatype. I want to use CFQUERYPARAM in > my insert and updates to these columns but also want to > support the Unicode functionality. How is this done? I > know if I insert without CFQUERYPARAM, place an 'N' prior > to the text, but what if I'm using CFQUERYPARAM? Thanks,
cfqueryparam handles it for you... <cfqueryparam value="#myvalue#" cfsqltype="cf_sql_varchar"> as long at the column is nvarchar, you should be golden. You may also want to set the form and url scopes to UTF-8 but iirc you would want to do that whether the data is stored in your database or not. There's a native function to ensure that form & url scopes are a particular character set -- the name escapes me at the moment -- it's getting late. :) s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://macromedia.breezecentral.com/p49777853/ http://www.sys-con.com/author/?id=4806 http://www.fusiontap.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200628 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
