Postgres Pro
Downloads
Home   >   mailing lists

Can I turn the case sensitive off - Mailing list pgsql-general

From Terence Chang
Subject Can I turn the case sensitive off
Date
Msg-id 006c01c3523c$1f24b2c0$09f1e9a7@PEANUTLEN
Whole thread Raw
Responses Re: Can I turn the case sensitive off
Re: Can I turn the case sensitive off
List pgsql-general
Tree view
All:
 
I don't remember I even seen a document saying PostgreSQL are case sensitive. I just figure out that my column name are case sensitive. Is there any way that I can turn it off or force the object name to all upper case?
 
Also, I have seen a lot of people having problem troubles to insert unicode into DB, but no clear answer out there.
I guess that I have been searching with wrong keyword or place. Is there a FAQ for this unicode issue? I did not see a Nchar or Nvarchar data type. What data type should I use?
 
thanks!
 

pgsql-general by date:

Previous
From: elein
Date:
Subject: Re: Fw: Is SQL silly as an RDBMS<->app interface?
Next
From: Alvaro Herrera
Date:
Subject: Re: Seemingly identical queries run at different speeds