Thank you, Tom. I guess I'm a bit confused about things here. How can I find the locale of my database? (I wasn't able to find this in the docs). If I do have the locale set to 'C', do I loose anything by using utf8 for all text fields?
On Wed, Jul 22, 2009 at 4:31 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Robert James <srobertja...@gmail.com> writes: > > Hi. I'm confused about the behavior of LIKE under utf8 locale. > > UTF8 is not a locale, it's an encoding. If you're using C locale then > LIKE can use indexes, regardless of the encoding. If you're using > some other locale then you need a pattern_ops index. > > regards, tom lane >