Horton

Re: NLS support for postgreSQL

Shachar Shemesh <psql@shemesh.biz>

View thread
From: Shachar Shemesh <psql@shemesh.biz>
To: Mahmoud Taghizadeh <m_taghi@yahoo.com>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2004-08-22T23:49:04Z
Lists: pgsql-hackers 
Mahmoud Taghizadeh wrote:

>3. we are planning to add locale per column for
>postgreSQL, but I found that you had said its
>impossible.  am I right? do you have any paper about
>it?
>  
>
One of the ways to solve this is to have a special data type for this 
purpose. Check out the mssqlext project on pgfoundry 
(http://pgfoundry.org/projects/sql2pg/). In particular, check out the 
"varcharci" type, that has case preserving varchars. This may provide 
you with a starting point for what you are trying to do.

          Shachar

-- 
Shachar Shemesh
Lingnu Open Source Consulting ltd.
http://www.lingnu.com/