[Rt-devel] PostgreSQL 8.4.4 and rt3 encoding
Peter C. Lai
peter at simons-rock.edu
Thu Jul 29 13:43:15 EDT 2010
Is there a reason why your DBA does not set the default encoding to UTF8?
It has been the standard default encoding throughout the entire 8.x postgresql
series.
Is there a reason why you cannot create the RT db with UTF8 before doing the
restore?
On 2010-07-29 09:54:15AM -0400, Sharon.Belliveau at frb.gov wrote:
> Per the DBA:
> The database cluster will be initialized with locale en_US.
> The default database encoding has accordingly been set to LATIN1.
> The default text search configuration will be set to "english".
>
> We RT admins would like to keep the encoding that will work best with RT
> and not be constrained for future RT upgrades. So, will we incur problems
> if we give in to setting the encoding to LATIN1 or SQL_ASCII?
>
> -Sharon
>
>
>
>
> From: "Peter C. Lai" <peter at simons-rock.edu>
>
> To: Sharon.Belliveau at frb.gov
>
> Cc: rt-devel at lists.bestpractical.com
>
> Date: 07/28/2010 05:05 PM
>
> Subject: Re: [Rt-devel] PostgreSQL 8.4.4 and rt3 encoding
>
>
>
>
>
>
> Why would you want this?!
>
> On 2010-07-28 04:13:48PM -0400, Sharon.Belliveau at frb.gov wrote:
> >
> > Hello -
> > We are working with RT 3.8. Our DBAs are upgrading our PostgreSQL
> > installation to 8.4.4. I was asked if the rt3 database, currently
> encoded
> > as UTF8 could be changed to either latin1 or sql_ascii. I've been
> searching
> > the list archives and RT's docs and can't seem to find a database
> encoding
> > recommendation. So,would anyone offer advice on which encoding method to
> > use or avoid? Any experience with PostgreSQL 8.4.4 to share?
> >
> > Sharon
> >
> > _______________________________________________
> > List info:
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel
>
> --
> ===========================================================
> Peter C. Lai | Bard College at Simon's Rock
> Systems Administrator | 84 Alford Rd.
> Information Technology Svcs. | Gt. Barrington, MA 01230 USA
> peter AT simons-rock.edu | (413) 528-7428
> ===========================================================
>
>
>
>
--
===========================================================
Peter C. Lai | Bard College at Simon's Rock
Systems Administrator | 84 Alford Rd.
Information Technology Svcs. | Gt. Barrington, MA 01230 USA
peter AT simons-rock.edu | (413) 528-7428
===========================================================
More information about the rt-devel
mailing list