Re:Subject: big/small letters with oracle No2

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxx>
To: php-db@xxxxxxxxxxxxx
Message-id: <40BC5D47.4010003@xxxxxx>
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.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux