Thread: Again!! locale per column for postgreSQL

Again!! locale per column for postgreSQL

From
Mahmoud Taghizadeh
Date:
Qustion: is this approach is suitable for solving the need for locale per column in PostgreSQL ?
 
There is a function I attached to this mail. this function is similar to nls_sort.  this function is written by Karel Zak, I dont know if he had tried to submit this code or not.
 
In this distribution you will find file nls_string.c. It contains the
definition of function nls_string(text, text) which takes a string
parameter and a locale name and returns string describing the ordering.
So you can run

  select * from table order by nls_string(name, 'en_US.UTF-8')

or

  select * from table order by nls_string(name, 'cs_CZ.UTF-8')

or

  select * from table order by nls_string(name, 'C')

M. taghizade


Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!

Re: Again!! locale per column for postgreSQL

From
Karel Zak
Date:
On Wed, 2004-09-15 at 07:01 -0700, Mahmoud Taghizadeh wrote:
> Qustion: is this approach is suitable for solving the need for locale
> per column in PostgreSQL ?

> There is a function I attached to this mail. this function is similar
> to nls_sort.  this function is written by Karel Zak, I dont know if he
> had tried to submit this code or not.

I think good place for this function is in the PG's contrib tree. The
final solution for main tree have to be something different. I agree
with you that this function can be useful for multi-language databases.

Lates version is available at:
http://www.fi.muni.cz/~adelton/l10n/postgresql-nls-string/

    Karel

--
Karel Zak
http://home.zf.jcu.cz/~zakkr/