Skip site navigation (1) Skip section navigation (2)

From: "Beto (dot)" <dunadanmontaraz(at)hotmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Date: 2005-04-24 23:08:25
Message-ID: BAY22-F14D020F9DE83653CB08145AA2F0@phx.gbl (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
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?

MSN Amor: busca tu ½ naranja

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group