From: "Beto (dot)" <dunadanmontaraz(at)hotmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject:
Date: 2005-04-24 23:08:25
Message-ID: BAY22-F14D020F9DE83653CB08145AA2F0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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/

Browse pgsql-novice by date

  From Date Subject
Next Message John DeSoi 2005-04-25 00:20:26 Re: download
Previous Message Vitaly Belman 2005-04-24 08:48:57 Re: Passing multiple rows to a function?