General information
Title:
Create a case insensitive primary key in Oracle
We are in the process of converting VFP 6 application to run with an Oracle back-end.
We have solved a number of issues but have run into a brick wall with checking for duplicate record. It looks like Oracle is case sensitve.
We have put a Primary Key on our table.
For Example:
Table: ChargeCodes
Primary Key: ChargeCategory Char(4)
ChargeCode Char(8)
In the VFP world we would build the following index
INDEX ON Upper(ChargeCategory + ChrageCode) ...
Any thoughts on how to setup a Primary Key in Oracle that is case insensitive?
Help is greatly appreciated.
Vince
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only