"Daniel Verite" <dan...@manitou-mail.org> writes: > To me the question of what we should put in pg_collation.collctype > for the "ucs_basic" collation leads to another question which is: > why do we even consider collctype in the first place?
For starters, C locale should certainly act different from others. I'm not sold that arguing from Unicode's behavior to other encodings makes sense, either. Unicode can get away with defining that there's only one case-folding rule because they have the luxury of inventing new code points when the "same" glyph should act differently according to different languages' rules. Encodings with a small number of code points don't have that luxury. In particular see the mess around dotted and dotless I/J in Turkish vs. everywhere else. regards, tom lane