Hi,
Im using postgresql 7.4.3 (rpm installation in redhat 8.0). Im saving names
and other data written in spanish language. The problem is that some values
(like names), contain some characters that are not correctly saved (like
'ñ', '°', etc). When i do psql -l, the column encoding says SQL_ASCII for
all db.
i tried "set server_encoding to 'UTF_8'", but it gave me an error.
how can i change the database encoding for one or all db's to add support
fot this special characters? is 'UTF-8' the right charset?
thanks.

_________________________________________________________________
MSN Amor: busca tu ½ naranja http://latam.msn.com/amor/