Search Postgresql Archives

Re: What encoding to use for English, French, Spanish

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



novnov wrote:
> My project is currently SQL_ASCII encoded. I will need to accomodate
> both French and Spanish in addition to English. I don't anticipate
> needing Far East languages. Reading here on the forums I come up with
> Latin9 as perhaps adequate. But others recommend unicode for
> relatively simple needs like my own.

LATIN9 or UTF-8 are the appropriate choices for your project.  The 
choice between these is mostly a matter of taste, unless there are 
additional requirements in the project.  Nowadays, many operating 
systems configure themselves to use Unicode by default, and so there is 
probably no reason to use a more restricted character set.

Note that some versions of PostgreSQL have various degrees of trouble 
with UTF-8 support.  Be sure to use the latest version.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux