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

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 (view raw or flat)
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/


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-2014 The PostgreSQL Global Development Group