[Rt-devel] PostgreSQL 8.4.4 and rt3 encoding

[Sharon.Belliveau at frb.gov]

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
===========================================================