Re: Sigh, LIKE indexing is *still* broken in foreign locales

-----BEGIN PGP SIGNED MESSAGE-----

>>>>> "Tom" == Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

Tom> Erich Stamberger <eberger(at)gewi(dot)kfunigraz(dot)ac(dot)at> writes:
>> Another interresting feature of Czech collation is: H < "CH" < I

>> So what happens with "WHERE name like 'Czec%`" ?

Tom> The wrong thing, without doubt.

I think this is a conceptual problem: some languages use more than one
character to designate a single "letter" in their orthography. Even
more "familiar" languagues such as Spanish do this: ch, ll, rr. Maybe
they've changed since I was taught, but my Spanish dictionaries are
put "ciudad" before "chico" (in fact, the latter is in a separate
section after "C" and before "D").

Sorry if this doesn't help find a solution, though....

roland
- --
PGP Key ID: 66 BC 3B CD
Roland B. Roberts, PhD Unix Software Solutions
roberts(at)panix(dot)com 76-15 113th Street, Apt 3B
rbroberts(at)acm(dot)org Forest Hills, NY 11375

-----BEGIN PGP SIGNATURE-----
Version: 2.6.3a
Charset: noconv
Comment: Processed by Mailcrypt 3.5.4, an Emacs/PGP interface

iQCVAwUBOUEQFOoW38lmvDvNAQED5wQAnwW1BpbCeghJWXh/gTMezRfDfLq2eSPu
4+H0X6Xjm2Gbegrv1SiWlSCjD1yR/FYIgTQpbMCubXlAtadu5tc4auLGNsOdSNIC
3lT2Bc+En5BxT06dsX33QApU1B4GP73KFxSJu2+ngRMKExTFEojM7qzLlKfGzDeG
onaP+RPbtJc=
=Dlnw
-----END PGP SIGNATURE-----