From: | Mahmoud Taghizadeh <m_taghi(at)yahoo(dot)com> |
---|---|
To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | strcoll_l an new approach for locale per column |
Date: | 2004-12-22 09:12:36 |
Message-ID: | 20041222091236.61241.qmail@web50707.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
in this list there is some discussion about adding
support locale per column.
as far as I know the final result was that:
because postgresql uses glibc locale functions, and
because glibc only handle one locale, postgresql also
suppor only one locale at the same time.
one solution was that use some help functions (such as
nls_sort, or strxfrm...) and use setlocale to support
other locale.
the main problem with these solutions was that
1. it is not standart
2. the overhead of setlocale is too high
as far as I investigate the glibc code, I found some
extention function such as strcol_l and strxfrm_l that
let you to pass locale to them. so you dont have to
change locale repeatedly.
I want to know the groups idea?
Best Regards
__________________________________
Do you Yahoo!?
Send holiday email and support a worthy cause. Do good.
http://celebrity.mail.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2004-12-22 09:41:40 | Re: Thoughts about updateable views |
Previous Message | Hannu Krosing | 2004-12-22 09:03:11 | Re: getting 'order by' working with unicode locale? ICU? |