Re: [SQL] How to Insert and retrieve multilingual (Hindi "an Indian language") into PostgreSQL

On 06/22/10 14:48, venkat wrote: I want to insert and retrieve multilingual (Hindi) into database.is PostgreSQL supports that ?if it is ... please guide me how to enable multilingual in the table. in addition to the previous advice ("just use UTF-8 for entire database c

Re: [SQL] ORDER BY is case insensitive

Bryan White writes: > I was suprised to find out that ORDER BY is case insensitive. Is > there a way to do a case sensitive ORDER BY clause? Text sort order is determined by the rules of the locale you're using, specifically the database's LC_COLLATE setting. Most implementations of en_US local

Re: [SQL] ORDER BY is case insensitive

Bryan White wrote: > I was suprised to find out that ORDER BY is case insensitive. Is > there a way to do a case sensitive ORDER BY clause? > > This transcript demonstrates what I am seeing: > > $ createdb bryan > $ psql bryan > psql (8.4.4) > Type "help" for help. > > bryan=# create table t (f

[SQL] ORDER BY is case insensitive

I was suprised to find out that ORDER BY is case insensitive. Is there a way to do a case sensitive ORDER BY clause? This transcript demonstrates what I am seeing: $ createdb bryan $ psql bryan psql (8.4.4) Type "help" for help. bryan=# create table t (f text); CREATE TABLE bryan=# insert into

Re: [SQL] How to Insert and retrieve multilingual (Hindi "an Indian language") into PostgreSQL

Hello PostgreSQL doesn't support multilangual tables now - etc it isn't more than one collation per database. But you can store any langual text when this language is supported by UTF8. Just use UTF8 encoding for your database. Regards Pavel Stehule see help for initdb and createdb commands

[SQL] How to Insert and retrieve multilingual (Hindi "an Indian language") into PostgreSQL

Dear All, I want to insert and retrieve multilingual (Hindi) into database.is PostgreSQL supports that ?if it is ... please guide me how to enable multilingual in the table. I am waiting for your great response. Thanks and Regards, Venkat