Обсуждение: 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.