Peter Eisentraut wrote: > Bruce Momjian wrote: > > However, I am wondering if we should create a character lookup during > > initdb that has the characters ordered so we can do: > > That won't work. Real-life collations are too complicated.
OK. > > Also, we mention you should use the "C" locale to use normal indexes > > for LIKE but isn't it more correct to say the encoding has to be > > SQL_ASCII? > > No, the locale decides the ordering. Oh, OK. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]