Re: 8.1 build on Solaris has LATIN9?

Please forgive the empty reply preceeding this note.

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

> Jerry Sievers <jerry(at)jerrysievers(dot)com> 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.

Thanks for this info.

Interesting, it was iso8859-15.

I inidb a new cluster and this time, I get SQL_ASCII. This is
without a hint of language or locale stuff in the ENV.

Guessing the postgres user's env has changed since the original
cluster creation.

Have a great weekend.

> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>

--
-------------------------------------------------------------------------------
Jerry Sievers 305 854-3001 (home) WWW ECommerce Consultant
305 321-1144 (mobile http://www.JerrySievers.com/