Michael Kaplan wrote: > I'm using the JDBC driver that came with 6.1, the data is stored as nvarchar, > and to be perfectly honest, I'm not sure about your last question. I assume > it's stored as ucs2, since this Microsoft KB article says that's the way it > has to be: http://support.microsoft.com/kb/q232580/ .
back in the bad old cf5 days actually storing utf-8 was a (poor) workaround for not having unicode in cf. are you using cfqueryparam & maybe not turned on the unicode option for that dsn? got a public page we can see? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234032 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

