Обсуждение: Problems with localization
Hi everybody. It's my first message, I hope I'm in the right ml. I'm using postgresql 7.4.6 on gentoo 2004.2. I've set nls use flag in make.conf. I want to set locale to it_IT so that when I issue "select to_char(some_date, 'Day') from some_table" I see for example "Lunedì" instead of "Monday" ("Lunedì" is the italian translation for "Monday")... I think in part it works, because I see the psql initial message in italian, but I continue to see "Monday" instead of "Lunedì"... Any help would be appreciated. Thank you. Kamal ____________________________________________________________ 6X velocizzare la tua navigazione a 56k? 6X Web Accelerator di Libero! Scaricalo su INTERNET GRATIS 6X http://www.libero.it
On Sun, Jan 23, 2005 at 11:08:24PM +0100, kamal wrote: Hi, > I want to set locale to it_IT so that when I issue "select to_char(some_date, > 'Day') from some_table" I see for example "Lunedì" instead of "Monday" ("Lunedì" > is the italian translation for "Monday")... I don't think to_char() knows about i18n/l10n yet. So you'd need to patch it, or convince somebody to do it for you. -- Alvaro Herrera (<alvherre[@]dcc.uchile.cl>) "El que vive para el futuro es un iluso, y el que vive para el pasado, un imbécil" (Luis Adler, "Los tripulantes de la noche")
> I don't think to_char() knows about i18n/l10n yet. So you'd need to > patch it, or convince somebody to do it for you. Ah, ok, I see. I can't do it. I think I'll write it in PL/pgSQL. Thank you very much. Kamal ____________________________________________________________ 6X velocizzare la tua navigazione a 56k? 6X Web Accelerator di Libero! Scaricalo su INTERNET GRATIS 6X http://www.libero.it