Re: sorting problem

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: CK Leung <ck(at)wecity(dot)com>
Cc: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: sorting problem
Date: 2009-05-04 08:55:09
Message-ID: 49FEAD6D.5090201@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

CK Leung wrote:
> I create a new database use UTF-8 and SQL_ASCII, same result found, how
> can i fix this problem ?

If I recall correctly, the collation order is set at initdb time, and
isn't bound to the database encoding. If that's right, you'd need to
dump all your databases, re-initdb with the new collation settings, and
re-load your databases.

--
Craig Ringer

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Marshall, Steve 2009-05-04 12:02:43 Re: sorting problem
Previous Message CK Leung 2009-05-04 07:12:35 Re: sorting problem