Re: Unicode problem ??? - Mailing list pgsql-general

From John Sidney-Woollett
Subject Re: Unicode problem ???
Date
Msg-id 1185.192.168.0.64.1082559089.squirrel@mercury.wardbrook.com
Whole thread Raw
In response to Re: Unicode problem ???  ("Priem, Alexander" <ap@cict.nl>)
Responses Re: Unicode problem ???
List pgsql-general
Priem, Alexander said:
> Could this be due to the fact that the database was CREATED using
> SQL_ASCII
> encoding? Maybe your solution only works when the database was created
> using
> LATIN1 or UNICODE encoding.

Yes, I suspect

> Maybe I'll just try recreating the database using UNICODE or LATIN1
> encoding
> tomorrow. UNICODE seems the best, right? Or does LATIN1 have more
> possibilities than UNICODE?

Unicode has a larger character set than latin-1. But if you only need to
support latin-1 then use that... Of course, if you have to upgrade to
support unicode later, you'll wish you had started off using latin-1!

I'm no expert on this, so I hope this info is correct.

John Sidney-Woollett

pgsql-general by date:

Previous
From: "Stijn Vanroye"
Date:
Subject: Re: Unicode problem ???
Next
From: "scott.marlowe"
Date:
Subject: Re: upgrade postgres 7.1 to 7.4.2