Re: 'order by' does "wrong" with unicode-chars (german umlauts)

peter pilsl <pilsl@goldfisch.at> writes:
> I get my text from a web-form, process it via perl and store it in postgreSQL
> via DBI-Interface. The unicode-text appears as multibyte in perl and I got the
> suspect that postgresql simply takes this multibyte-text and doesnt even
> reckognize that it could be unicode.

If you have set the database encoding as SQL_ASCII, then that's exactly
what it will (and should) do.  You need to make the database encoding
be unicode.

            regards, tom lane