Le Mercredi 1 Octobre 2003 20:05, Andreas Pflug a écrit :It's no problem storing non-UTF characters in an UNICODE database either, you will never notice until you try to convert.
This is not a bug of PostgreSQL, nor of pgAdmin.
SQL_ASCII database *should* contain only 7bit ascii characters. If you
use 8-bit characters, conversion is unpredictable (well, it *is*
predictable, but probably not what you'd like to see)
IMHO, SQL_ASCII database contain more than 7bit characters. I used it several times to store Frenc accentuated text and it worked like a charm. The name "ASCII" may not be well chosen. It contains more than ASCII presently.
Misusing the database is not a good idea on the long run.
Regards, Andreas
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html