Re:Subject: big/small letters with oracle No2
| From: | Neil Smith [MVP, Digital media] | Date: | Tue, 01 Jun 2004 20:15:10 +0000 |
| Subject: | Re:Subject: big/small letters with oracle No2 | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-34621@lists.php.net to get a copy of this message | ||
You can just use the PHP function ucwords(strtolower()) on the results as you loop through them to create the Select list ;-)
So, this would convert NA to Na, and MG to Mg (as well as mG to Mg and MG to Mg ;-)
Cheers - Neil
At 10:41 01/06/2004 +0000, you wrote:
Date: Tue, 01 Jun 2004 12:41:11 +0200 From: Torsten Lange <t.lange@ufz.de> To: php-db@lists.php.net Message-id: <40BC5D47.4010003@ufz.de> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii; format=flowed Content-transfer-encoding: 7BIT Subject: big/small letters with oracle No2 But when using queries on the USER_... data dictionary, Oracle delivers always big letters, which is for chemical elements (NA vs. Na) or location names (ALICE SPRINGS vs. Alice Springs) and location codes often uncomfortable to read. It happend in the heat of the moment... The above is only the case for column names, i.e. the parameter columns (Na, Mg...). Locations etc. belonging of course to data sets. Torsten======================================================== CaptionKit http://www.captionkit.com : Production tools for accessible subtitled internet media, transcripts and searchable video. Supports Real Player, Quicktime and Windows Media Player. VideoChat with friends online, get Freshly Toasted every day at http://www.fresh-toast.net : NetMeeting solutions for a connected world.