That's fascinating. But why would sql server create an index in a codeset that didn't match the column? You'd think that the index would match the declared type of the column automatically. I would think of that as a bug in sql server.
We're moving some applications to do more multilingual support soon and that sort of gotcha is something for me to keep in mind. Gotta convert everything to nvarchar. Thanks for giving us more info about the resolution. Judah On Fri, Feb 13, 2009 at 6:16 AM, Rick Root <rick.r...@webworksllc.com> wrote: > > On Thu, Feb 12, 2009 at 11:34 AM, Brad Wood <b...@bradwood.com> wrote: >> >>> resolving the way my database driver was configured >>> helped clear up a lot of problems by reducing the # of reads we were >>> doing. >> >> @Rick, can you provide any specifics on the above change? What did he >> change? How did it reduce reads? > > Sorry for having two threads on this issue but here are the specifics... > > Unicode support was enabled in the FR driver, and I'd created a > member_sessions table with a "char" field as the primary key.. not > nchar. So for that reason, the indexes weren't working very well > because of the data type mismatch... SQL ended up having to do a > convert() and ended up doing an index scan instead of an index seek I > guess.. something like that. > > So I disabled unicode support and then last night I converted my CHAR > fields to NCHAR and re-enabled unicode support in the driver. > > -- > Rick Root > New Brian Vander Ark Album, songs in the music player and cool behind > the scenes video at www.myspace.com/brianvanderark > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319303 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
