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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: peter pilsl <pilsl(at)goldfisch(dot)at>
Cc: Richard Huxton <dev(at)archonet(dot)com>, PostgreSQL List <pgsql-general(at)postgresql(dot)org>
Subject: Re: 'order by' does "wrong" with unicode-chars (german umlauts)
Date: 2003-09-20 16:05:44
Message-ID: 24588.1064073944@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

peter pilsl <pilsl(at)goldfisch(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-09-20 16:17:50 Re: State of Beta 2
Previous Message Joshua D. Drake 2003-09-20 16:04:10 Re: This mail list and its policies