PDA

View Full Version : NEED HELP...HEM Database Error Message



ImAKing
09-14-2009, 07:12 PM
Hey, I just purchased HEM and downloaded postgres 8.4. I and trying to create a database for HEM but i am getting an error code: ERROR: 22023: new encoding (SQL_ASCII) is incompatible with the encoding of the teplate database (UTF8).

Does anyone know what I can do from here to create a database?

Thanks!!!!!

ImAKing
09-14-2009, 07:13 PM
Hey, I just purchased HEM and downloaded postgres 8.4. I and trying to create a database for HEM but i am getting an error code: ERROR: 22023: new encoding (SQL_ASCII) is incompatible with the encoding of the teplate database (UTF8).

Does anyone know what I can do from here to create a database?

Thanks!!!!!

fozzy71
09-14-2009, 07:31 PM
Hey, I just purchased HEM and downloaded postgres 8.4. I and trying to create a database for HEM but i am getting an error code: ERROR: 22023: new encoding (SQL_ASCII) is incompatible with the encoding of the teplate database (UTF8).

Does anyone know what I can do from here to create a database?

Thanks!!!!!


Hey, I just purchased HEM and downloaded postgres 8.4. I and trying to create a database for HEM but i am getting an error code: ERROR: 22023: new encoding (SQL_ASCII) is incompatible with the encoding of the teplate database (UTF8).

Does anyone know what I can do from here to create a database?

Thanks!!!!!

No need for 2 threads.

Create a new UTF Database.

- http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=146

ImAKing
09-14-2009, 08:05 PM
No need for 2 threads.

Create a new UTF Database.

- http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=146

Yea sorry about that double thread....

But the problem is when i am at that second page (the create a database screen) there is nothing in the database part it is just blank. So when I go and try and create one that error message comes up....

fozzy71
09-14-2009, 08:25 PM
You are updated to the latest version of HM like I suggested? 1.09 Beta 30b?

Does your create a DB screen look like this:

http://www.holdemmanager.com/downloads/images/faqs/newutfdb.png



Did you already have postgresql installed before?

If you have Vista, please verify that UAC is still off. - http://www.holdemmanager.net/faq/afmmain.aspx?faqid=73. If it is on, please turn it off and reboot.

Add exceptions to the windows firewall, even if it is off. If you have a 3rd party firewall, uninstall it completely before installing HM/SQL - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=171


If you are still having issues:

Please update to the latest beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe.


1) Uninstall PostgreSQL from the Windows Control Panel.
2) manually delete the Program Files\Postgresql folders
3) run the command - start > run > cmd >

net user postgres /delete
4) reboot.
5) Install PostgreSQL 8.4, with your firewall uninstalled or turned off if windows firewall - http://www.enterprisedb.com/products/pgdownload.do#windows