I need some help understanding locales and what the impact upon my
database/application would be.
I am currently running 7.3.4 and have a database with tons of varchar
fields. However, when we query on one of the fields with a like, it
does not use an index. Apparently from the documentation,
Chris Hoover wrote:
> with the locale specifically set to C (initdb --locale=C ...). This
> has fixed the index usage problem, but I don't understand what
> ramifications if any it has on my database. Please help me
> understand what this means to me as the dba.
The sort order will be different.
Would you please be so kind to provide a bit more explanation? How will
the sort differ? Are the any good pages out there that would help me
understand the ramifications?
Thanks,
Chris
Peter Eisentraut wrote:
Chris Hoover wrote:
with the locale specifically set to C (initdb --locale=C ...).
Am Mittwoch, 1. September 2004 23:03 schrieb Chris Hoover:
> Would you please be so kind to provide a bit more explanation? How will
> the sort differ?
C sorts by byte value, which ends up being AB...Zab...z. en_US sorts using
"dictionary order", which means aAbB...zZ, accented characters appea