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

Re: Charset and encoding

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: rosa(dot)carro(at)ii(dot)uam(dot)es
Cc: pgsql-novice(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: Charset and encoding
Date: 2001-05-25 01:02:51
Message-ID: 20010525100251J.t-ishii@sra.co.jp (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-novice
> > datname   datdba    encoding    datpath
> > ------------------------------------------------
> > courses      26                  7      courses
> 
> Hum. Look ok to me.
> 
> > I have tested with LATIN1 - LATIN5 and I haven't got any result...
> > I'd need the Spanish 'ñ' (that is what I insert)... 
> > Maybe I need to insert this character in a special way? The client is
> > set to the same encoding as the database is.
> 
> Can I have a physical copy of your database so that I could dig into
> the problem? I mean an archive file using tar of whole contents of
> $PGDATA...
> --
> Tatsuo Ishii

I got data from Rosa, and tested with PostgreSQL 7.0.3/Linux/x86
configured with --enable-multibyte=LATIN1 --enable-locale.

test=# select * from test;
 name |    descr     
------+--------------
 hola | Señalizacion
 hola | Señalizacion
 hola | Señalizacion
 hola | Señalizacion
(4 rows)

Seems ok to me. Maybe you have some probloems with your PostgreSQL
installation?
--
Tatsuo Ishii

In response to

pgsql-novice by date

Next:From: Seema NoorDate: 2001-05-25 15:12:16
Subject: time difference
Previous:From: harroldDate: 2001-05-24 18:32:00
Subject: Re: Importing data... (fwd)

pgsql-general by date

Next:From: Steve O'HaganDate: 2001-05-25 01:07:48
Subject: Re: OID wrap around
Previous:From: Ludwig MeyerhoffDate: 2001-05-25 00:03:09
Subject: Pg - Perl 5 prob

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