PDA

View Full Version : postgreSQL encoding format



teecee90
10-04-2009, 12:46 PM
Hi

The tutorial on the HM web site for setting up postgreSQL says to change the database endcoding format to SQL_ASCII but the setup guide on the FAQ ID #176 says to leave it as WIN1252.

Which is correct......or doesn't it make any difference?

teecee90
10-04-2009, 02:00 PM
By the way.....I will be restoring a database from a different laptop which I think has a SQL_ASCII databse. Do have to make sure the new database is also SQL_ASCII or can it be WIN1252 ?

fozzy71
10-04-2009, 05:43 PM
Hi

The tutorial on the HM web site for setting up postgreSQL says to change the database endcoding format to SQL_ASCII but the setup guide on the FAQ ID #176 says to leave it as WIN1252.

Which is correct......or doesn't it make any difference?

Technically they are both incorrect.

For a new DB we recommend you update to the newest HM and create a new UTF DB.


By the way.....I will be restoring a database from a different laptop which I think has a SQL_ASCII databse. Do have to make sure the new database is also SQL_ASCII or can it be WIN1252 ?

When doing the restore process choose ascii encoding when creating the new DB to restore to.