| From: | Michael Meskes <meskes(at)postgresql(dot)org> |
|---|---|
| To: | Emmanuel Charpentier <charpent(at)bacbuc(dot)dyndns(dot)org> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [HACKERS] Case sensitivity issues |
| Date: | 2000-02-07 06:48:53 |
| Message-ID: | 20000207074853.A1134@fam-meskes.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Sun, Feb 06, 2000 at 10:51:34PM +0000, Emmanuel Charpentier wrote:
> I have lived that SQL database were not to be case-sensitive. However,
Which one? I have yet to work with one, that is unless you count Access as a
real database which it is not.
> This interface mostly works, but has some odd behaviour :
> /* Querying « usarrests » does ! Note that column names have been
> lowercased as well ... */
Sure. SQL is case insesitive by default. Quote your case-sensitive string
with double-quotes and it works.
Michael
--
Michael Meskes | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire!
Tel.: (+49) 2431/72651 | Use Debian GNU/Linux!
Email: Michael(at)Fam-Meskes(dot)De | Use PostgreSQL!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ansley, Michael | 2000-02-07 07:42:13 | RE: [HACKERS] ONLY |
| Previous Message | Timothy Dyck | 2000-02-07 06:41:26 | follow-up on PC Week Labs benchmark results |