PDA

View Full Version : UTF8 and ASCII-SQL ?



mr_mooray
01-17-2010, 07:51 AM
Was going to run a manual Vacuum today and reindex. When I ran pgadmin III a pop up talking about ASCII and UTF came.

What is the difference, I know UTF is now recommended; but how can I convert my ASCII database to use UTF?

Patvs
01-17-2010, 03:04 PM
They're both very similar... they just use a different way to store some information. For example the symbol "%", ASCII saves as 045, and UTF8 saves it as C5.

If you want a UTF8 database, reinstall PostgreSQL (or install a different version on a different port) in the UTF8 format, create a UTF8 HoldemManager database, and reimport ALL your hands into a new database.

Note: this is too much work/hassle if you already have a perfectly fine working ASCII database.