Well, the problem is probably the GNU readline library. postgresql supports
the character set you ask it to support, but if you want to use psql to get
the right characters into the database, you must have LC_ALL (or LANG) set
to a locale that has latin1 support, when you run psql. alas, "env
LANG=sv_SE.ISO8859-15 psql".
Of course, your terminal must also accept eight bit characters.
Unfortunately, readline does not support Meta- combinations and locale at
the same time,
it seems meta is using the 8:th bit.
--On onsdag, mars 12, 2003 17.29.54 -0300 Fernando Papa <fpapa@claxson.com>
wrote:
> I'm working with SQL_ASCII and can insert "acentos y eñes" without
> problem...
>
> --
> Fernando O. Papa
> DBA
>
>
>> -----Mensaje original-----
>> De: ApoloDNR [mailto:apolodnr@yahoo.es]
>> Enviado el: miércoles, 12 de marzo de 2003 13:25
>> Para: pgsql-admin@postgresql.org
>> Asunto: Re: [ADMIN] character set
>>
>>
>> Hi, my name is David, I had the same error, and at second
>> time I configure postgresql to support LATIN9, because I live
>> in Spain and needs the euro currency, but if you needn´t, you
>> can configure LATIN1 to support "acentos y eñe".
>>
>> Un saludo.
>>
>>
>> --- Sidar Lopez Cruz <sidarlopez@hotmail.com> escribió: > my
>> postgresql don't support á-é-í-ó-ú-ñ-Ñ, how do i get this support
>> > in postgressql...
>> >
>> > :-) Sidar Lopez Cruz
>> > - Cero Riesgo, S.A.
>> >
>>
>> =====
>>
>>
>>
>>
>>
>> David, apolodnr@yahoo.es
>>
>>
>>
>>
>> ___________________________________________________
>> Yahoo! Messenger - Nueva versión GRATIS
>> Super Webcam, voz, caritas animadas, y más...
>> http://messenger.yahoo.es
>>
>> ---------------------------(end of
>> broadcast)---------------------------
>> TIP 5: Have you checked our extensive FAQ?
>>
> http://www.postgresql.org/docs/faqs/FAQ.html
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>