-----BEGIN PGP SIGNED MESSAGE-----
>>>>> "Tom" == Tom Lane <tgl@sss.pgh.pa.us> writes:
Tom> Erich Stamberger <eberger@gewi.kfunigraz.ac.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@panix.com 76-15 113th Street, Apt 3B
rbroberts@acm.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-----