Am Mittwoch, 21. April 2004 14:37 schrieb Priem, Alexander: > I have a PostgreSQL 7.4 database running, which was initdb-ed using > standard (SQL_ASCII) encoding, with -lc-collate=C option set. > > Everything is running fine, but I just discovered something funny. If text > containing characters like ë is inserted into the database (text field), > the inserting goes fine. When I view this data using phpPgAdmin (v3.2.1) it > looks fine, including these special characters.
You can try to update pg_database to change the database encoding to LATIN1. SQL_ASCII is only totally supported for, well, ASCII characters. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
