[postgresql-it] locale

  • From: Roberto Marzialetti <roberto@xxxxxxxxxxxxxxx>
  • To: postgresql-it@xxxxxxxxxxxxx
  • Date: Wed, 23 Apr 2008 17:16:19 +0200

in pratica ho una CentOS con

[postgres@gundam bin]$ locale
LANG=en_US.UTF-8
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=

quando tento di creare un db con latin1 mi dice:

[postgres@gundam bin]$ createdb -E LATIN1 testdb
createdb: database creation failed: ERROR:  encoding LATIN1 does not match 
server's locale en_US.UTF-8
DETAIL:  The server's LC_CTYPE setting requires encoding UTF8.

devo cambiare il locale di tutta la macchina? :o/

grazie
Rob


Other related posts:

  • » [postgresql-it] locale - Roberto Marzialetti