Re: big/small letters with oracle No2

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

 



"Torsten Lange" <t.lange@xxxxxx> wrote in message
news:40BC5D47.4010003@xxxxxxxxx
> > 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.

Hi Torsten,

you can use mb_strtolower() to convert the column names to lower case and
then ucfirst() to make the first letter uppercase:

echo ucfirst(mb_strtolower($fieldname));

Regards,

Torsten Roehr

-- 
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