Announcement

Collapse
No announcement yet.

PostgreSQL setup - database encoding

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • PostgreSQL setup - database encoding

    Hi,

    I originally set up PostgreSQL 8.2 for use with Mirth 1.5. At the time, I just took the default encoding (SQL_ASCII) when Postgres created the database.

    Subsequently when doing maintenance with PgAdmin, I see a "tip" that says I should use something with more bits, like UTF-8.

    Should I switch? If so, can I do that by dumping the database with format=P (plain ascii) and then creating the new database with encoding <whatever you told me> and restoring from the SQL file I created?

    If I should switch, should I do this before or after I upgrade to Mirth 1.6?

    thanks,
    Olaf
Working...
X