Re: [GENERAL] 8.1 build on Solaris has LATIN9?
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/ ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[GENERAL] 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 (mobilehttp://www.JerrySievers.com/ ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] 8.1 build on Solaris has LATIN9?
Jerry Sievers [EMAIL PROTECTED] 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 ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [GENERAL] 8.1 build on Solaris has LATIN9?
Please forgive the empty reply preceeding this note. Tom Lane [EMAIL PROTECTED] writes: Jerry Sievers [EMAIL PROTECTED] 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 (mobilehttp://www.JerrySievers.com/ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster