I need to move a PostgreSql database from 8.3 Windows to 8.4 running on Linux (Ubuntu Server 12.04).
The restore aparently is ok, but when I try to show data in my program I get an error saying that some characters are not supported on WIN1252 encoding.
The original database has this properties:
Encoding: WIN1252 LC_CTYPE: English_United States.1252 LC_COLLATE: English_United States.1252
I can restore the database using LC_CTYPE = "C" and LC_COLLATE = "C", this way I get the unsupported characters in my program.
If I try to create the database using this command:
createdb -h 127.0.0.1 \ --encoding=WIN1252 \ --lc-ctype='English_United States.1252' \ --lc-collate='English_United States.1252' \ -T template0 -U postgres mydb
I get this error:
createdb: falló la creación de la base de datos: ERROR: el nombre de configuración regional «English_United States.1252» no es válido
First of all, how can I let my O.S. include this regional configuration?.