[Rt-devel] PostgreSQL 8.4.4 and rt3 encoding

Sharon.Belliveau at frb.gov Sharon.Belliveau at frb.gov
Thu Jul 29 09:54:15 EDT 2010

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?


  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
> as UTF8 could be changed to either latin1 or sql_ascii. I've been
> the list archives and RT's docs and can't seem to find a database
> 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:

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