From: | "David Wall" <d(dot)wall(at)computer(dot)org> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org>, "Soma Interesting" <dfunct(at)telus(dot)net> |
Subject: | Re: upper() vs. lower() |
Date: | 2001-03-05 23:03:15 |
Message-ID: | 002b01c0a5c8$765b21a0$5a2b7ad8@expertrade.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I know that if you move towards unicode, you'll probably do better by going
to lowercase since I understand that there are more lowercase letters than
uppercase (for some odd reason!). I think it's related to the fact that
some languages have multiple lowercase letters that will map to a single
uppercase letter, so there's great "distinct-ness" with lowercase.
David
> Is there any reason why everyone suggests to use upper() to do a case
> insensitive search rather than lower()?
>
> Will initcap() capitalize each word in a column, or just the first word?
From | Date | Subject | |
---|---|---|---|
Next Message | Michelle Murrain | 2001-03-05 23:04:20 | Re: Getting lengths of variable fields |
Previous Message | Chris | 2001-03-05 23:02:51 | Re: Re: RPMs for PHP accessing PostgreSQL via ODBC over RedHat |