Re: [GENERAL] Does LC_CTYPE affect performance, index use?

On Wed, 2013-11-20 at 14:57 -0500, Steven Dodd wrote: I've read that setting LC_COLLATE to something other than C / POSIX negatively affects performance, and disables use of indexes for LIKE, etc... It doesn't disable the use of indexes, you just need to create different indexes. Does the

[GENERAL] Does LC_CTYPE affect performance, index use?

I've read that setting LC_COLLATE to something other than C / POSIX negatively affects performance, and disables use of indexes for LIKE, etc... Does the same apply to LC_CTYPE? I am considering setting LC_COLLATE = C, and LC_CTYPE = en_US.UTF-8, and using LOWER() to case-fold strings for