Changing character set of existing databases

Поиск
Список
Период
Сортировка
От Nicolas Michel
Тема Changing character set of existing databases
Дата
Msg-id 4AA90150.4010803@lemail.be
обсуждение исходный текст
Ответы Re: Changing character set of existing databases  (raghu ram <raghuchennuru@gmail.com>)
Список pgsql-admin
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?
2) Can I modify the defaut character set to create further databases in
UTF-8 by default?

Thank you so much,
nm

В списке pgsql-admin по дате отправления:

Предыдущее
От: Michael Monnerie
Дата:
Сообщение: type cast from bytea to varchar or whatever
Следующее
От: raghu ram
Дата:
Сообщение: Re: Changing character set of existing databases