On Tue, Feb 9, 2010 at 11:21, Fredric Fredricson <Fredric.Fredricson@xxxxxxxxxxxxx> wrote: > Scott Marlowe wrote: > > On Tue, Feb 9, 2010 at 1:42 AM, Fredric Fredricson > <Fredric.Fredricson@xxxxxxxxxxxxx> 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/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
