Re: 8.1 build on Solaris has LATIN9?

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. Of course we can override this and
might if there's a good reason move to LATIN9 as default.

Afraid though of having anything go flakey when we import the
original DBs with LATIN1 encoding.

I saw a message already during an import to the effect of "can't do
conversion"...

Thanks

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

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.

regards, tom lane

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/

Jerry Sievers wrote:
> Afraid though of having anything go flakey when we import the
> original DBs with LATIN1 encoding.

LATIN1 and LATIN9 are almost the same, so unless you have Euro
characters or some other corner cases in your data, you should just go
ahead with this. Note that changing to SQL_ASCII, as you suggested in
a later mail, is likely to break much more.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/