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?
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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:335703 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
