Thread: Database Encoding
can anyone provide a general primjer on pgsql encoding? i think i set my db up as ascii encoded. is this optimal for an english language db? my online host wants to default to latin1... which seems to support english also. with so many choices, i'm sure problems lurk around every corner. tia for any advice and background you give me, and other newbies, so that we can encode our db correctly based on our design criteria. __________________________________ Do you Yahoo!? Yahoo! Personals - Better first dates. More second dates. http://personals.yahoo.com
Hi, With my experience, latin1 is a good choice for english + others like scandic and german characters as well, even russian. So do your initdb with -E LATIN1, which creates a latin1 encoded template1 and then is the system default. BR, Aarni On Sunday 03 April 2005 23:46, you wrote: > can anyone provide a general primjer on pgsql > encoding? > > i think i set my db up as ascii encoded. is this > optimal for an english language db? my online host > wants to default to latin1... which seems to support > english also. > > with so many choices, i'm sure problems lurk around > every corner. > > tia for any advice and background you give me, and > other newbies, so that we can encode our db correctly > based on our design criteria. > > > > __________________________________ > Do you Yahoo!? > Yahoo! Personals - Better first dates. More second dates. > http://personals.yahoo.com > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org -------------- This is a bugfree broadcast to you from **Kmail** on **Fedora Core 2** linux system --------------
Here is some background info on character sets: http://www.cs.tut.fi/~jkorpela/chars.html latin1 is a superset of ascii. It will work fine for english language encoding. John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL On Apr 3, 2005, at 4:46 PM, <operationsengineer1@yahoo.com> wrote: > can anyone provide a general primjer on pgsql > encoding? > > i think i set my db up as ascii encoded. is this > optimal for an english language db? my online host > wants to default to latin1... which seems to support > english also. > > with so many choices, i'm sure problems lurk around > every corner. > > tia for any advice and background you give me, and > other newbies, so that we can encode our db correctly > based on our design criteria.