Red Hat Bugzilla – Bug 79270
initdb does not use iso8859-1 for dbs
Last modified: 2007-04-18 12:48:56 EDT
From Bugzilla Helper:
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.1) Gecko/20021003
Description of problem:
after an rpm installation of postgresql special characters like umlauts are
stored in the database, but when it comes to sorting, they are not read correctly.
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1.create table xxx
2.insert a few lines with umlauts in it
3.select * from xxx order by name
Actual Results: search result is:
Expected Results: Ankanfte
when setting the LANG to en_US or de_AT and doing another initdb everything
works as expected.
Assigning to me.
Perhaps the initial initdb is being done in a locale with unexpected sorting
results? Sorting in non-C locales is not an issue that I am completely familiar
with, so questions directed to the PostgreSQL community would be better
answered. Either way, this is not a packaging bug AFAICT so I'm going to
resolve it NOTABUG.