Thread: character set
my postgresql don't support á-é-í-ó-ú-ñ-Ñ, how do i get this support in postgressql...
:-) Sidar Lopez Cruz
- Cero Riesgo, S.A.
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
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
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) >