On 7/25/2010 4:53 AM, Igor Ilyinsky wrote: > > Someone correct me if I am wrong, but if you enable "non-latin" text > for a datasource, cfqueryparam will treat ALL cf_sql_varchar data as > unicode. Meaning there is no way to specify a non-unicode (ansi) > string other than to NOT use cfqueryparam?
depends on the db driver, as far as i can remember its datadirect's JDBC driver for sql server. > I'm trying to weigh the value of enabling the "non-latin" option > versus the "N" hinting, but I can't find a way to enter single-byte > strings with cfqueryparam once the option is checked, and I think > it's silly to sacrifice 50% of my storage space for this > convenience. that's not the issue, its the hit the query takes converting non-unicode strings back & forth. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335710 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
