Re: Database Encoding

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(at)postgresql(dot)org

--------------
This is a bugfree broadcast to you
from **Kmail**
on **Fedora Core 2** linux system
--------------