postgresql - How do you change the character encoding of a postgres database? -


i have database set default character set sql_ascii. want switch unicode. there easy way that?

  1. dump database
  2. drop database,
  3. create new database different encoding
  4. reload data.

make sure client encoding set correctly during this.

source: http://archives.postgresql.org/pgsql-novice/2006-03/msg00210.php


Comments

Popular posts from this blog

mod rewrite - Doing external redirect. .htaccess NS flag not working. How to achieve similar results? -

mysql - How to insert just year and month into date field? -