Jerry Sievers <jerry@xxxxxxxxxxxxxxxx> writes: > Hi. I am curious how/why the Pg 8.1.1 build on Solaris > SunOS $hostname 5.9 Generic sun4u sparc SUNW,Ultra-250 > chose LATIN9 charset as default. It probably deduced that from the locale setting (LANG or LC_ALL) that initdb was run in. Try "show lc_collate" if you don't remember what that was. regards, tom lane