On Thu, Sep 10, 2009 at 7:08 PM, Nicolas Michel <nicolas.mic...@lemail.be>wrote:
> Hello, > > I made a mistake an got a character set in SQL_ASCII as the defaut encoding > type : > > $ psql -l > List of databases > Name | Owner | Encoding > --------------+----------+----------- > cmp_crm | openerp | SQL_ASCII > cmp_crm_demo | openerp | SQL_ASCII > cmp_testcrm | openerp | SQL_ASCII > postgres | postgres | SQL_ASCII > template0 | postgres | SQL_ASCII > template1 | postgres | SQL_ASCII > (6 rows) > > I need to get them in UTF-8. -> > 1) Can I modify these existing databases to switch them into UTF-8? How? > you can't modify the existing database encoding. > 2) Can I modify the defaut character set to create further databases in > UTF-8 by default? > > you can change the default character set for new databases and use the below command for creation of new database with diff encoding. create database raghu template=template1 encoding='UTF-8'; Regards Raghu Ram > > > -- > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin >
