Geek asks and answers

Postgres Databases with Different Encoding

I tried to create databases with different encoding in postgres (I use PgAdmin as my database manager), but when I try to create a database with encoding without UTF8, PgAdmin shows me an error saying that I cannot create because it does not match my current language "Portuguese_Brazil_1252" and that the LC_Ctype configuration requires the encoding "WIN1252".

How to configure this in PostGres? I run it under a local test server with Windows XP (not my choice). Is it possible to create databases with different coding or is this behavior a PostGres limiter? Has anyone here already managed to handle this?

thank

+3
source share
1

docs:

(LC_COLLATE LC_CTYPE). C ( POSIX), , , . [...]

, , template0 .

( ):

  • template0 ( 1)

  • LC_COLLATE ( LC_COLLATE = 'C')

  • LC_CTYPE = ( LC_CTYPE = 'C')

CREATE ( PgAdmin )

template0/template1 ,

+8

More articles:


All Articles