> > 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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Reply via email to