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
<tgl@sss.pgh.pa.us> wrote:
Robert James <
srobertjames@gmail.com> writes:
> Hi. I'm confused about the behavior of LIKE under utf8 locale.
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