Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> how to store data in mixed case in database
I am looking for a way to store data in oracle database in mixed case.
Instead of converting data on insertion to upper or lower case i need a
way to find to do this automatically when the data is being inserted so
it does not matter how its being retrieved. With the UPPER AND LOWER
function I can only do this when the data has been inserted and then
convert it into UPPER case in order to retrieve it in mixed case. is
there an init.ora parameter or some kind of session set up command that
can achieve that functionality. For instance in sql server the Case can
be set up before hand. does oracle has any such functionality.
thanks for any help in advance
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Oct 06 1999 - 11:46:17 CDT