Re: Order by and strings

On Tue, Feb 9, 2010 at 11:21, Fredric Fredricson
<Fredric(dot)Fredricson(at)bonetmail(dot)com> wrote:
> Scott Marlowe wrote:
>
> On Tue, Feb 9, 2010 at 1:42 AM, Fredric Fredricson
> <Fredric(dot)Fredricson(at)bonetmail(dot)com> wrote:
>
>
> I use locale en_US.UTF-8 but why this should affect how leading characters
> in strings are ignored is beyond me.
>
>
> P.s. this page may shed some light on the subject:
>
> http://en.wikipedia.org/wiki/Collation
>
> OK, thanks. It did shed some light on the subject. Only I wonder what would
> happen if these sort algorithms where used on things like article numbers in
> the industry. That would confuse the hell out of the people there.

In case you are storing something like that, you may be better off
using bytea instead of text.

--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/