Re: [PERFORM] Curious sorting puzzle

2006-06-07 Thread Ivan Voras
Tom Lane wrote: An ideal solution would be to have a "not-locale-affected-varchar" field type :) If you're just storing ASCII then I think bytea might work for this. Do you need any actual text operations (like concatenation), or this just a store-and-retrieve field? I've just tested bytea

Re: [PERFORM] Curious sorting puzzle

2006-06-07 Thread Tom Lane
Ivan Voras <[EMAIL PROTECTED]> writes: > The situation is this: we're using a varchar column to store > alphanumeric codes which are by themselves 7-bit clean. But we are > operating under a locale which has its own special collation rules, and > is also utf-8 encoded. Recently we've discovered

[PERFORM] Curious sorting puzzle

2006-06-07 Thread Ivan Voras
The situation is this: we're using a varchar column to store alphanumeric codes which are by themselves 7-bit clean. But we are operating under a locale which has its own special collation rules, and is also utf-8 encoded. Recently we've discovered a serious "d'oh!"-type bug which we tracked do