We recently ran into a problem (CFMX, SQL 2000, Win2K) where unicode data being passed into a <cfstoredproc> was not getting into the db as double-byte.  

This was resolved (after much hunting) by checking the "String Format" checkbox in the advanced datasource settings for the DSNs involved.

>From the CFMX documentation, one should enable this check box "if your application uses Unicode data in DBMSspecific Unicode datatypes such as National Character or nchar."

I'm wondering if anyone knows what is/whether there is any significant performance decrease associated with having this option enabled.  There are some people I'm working with who are thinking that it'd be valuable to have this box checked on some of our DSNs that don't currently need unicode support, but may in the not-so-near future.

Does anyone have any knowledge/experience with this option?

Thanks very much,

Evan
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to