Does anybody know of an idiot's guide to the ins and outs of selecting
database encoding? I remember reading on pgsql mailing lists about
gotchas when using some choices of locales or encodings with some
postgresql features. I recall that someone -- David Fetter, I think --
wrote something disparaging about SQL_ASCII.
My needs are simple: modern linux (suse 10), x86_64, pg 8.1.4, mostly
American English, occasional use of tsearch2. I don't understand the
tradeoffs between C, SQL_ASCII, UTF8, or any of the other possibilities.
Any recommendations? I'm in SQL_ASCII now, but I'm about to rebuild and
this is a good time to reconsider.
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
sfpug by date
|Next:||From: David Fetter||Date: 2006-08-03 23:08:12|
|Subject: Re: locale and encoding advice|
|Previous:||From: Casey Duncan||Date: 2006-08-01 18:48:52|
|Subject: Re: Second annual Harambee!!!! - PostgreSQL @ Linux World - call for volunteers, etc. |