Case Sensitive Insert Query(Access)

Question

User-32636744 posted

 Hi,

I have an access database.

there is a record with "Junn" value in a column of table named "UserId".

I want to insert the "junn" value to this column.

But Error is: equal text in key column.(because of case sensitive)

How can I insert this value without this Error?

Thanks.

Answer 1

User-821857111 posted

I don't believe that you can make it case-sensitive.  Therefore, you will need to remove the No Duplicates  flag from the column if you want to add what are essentially duplicate values.

 

Answer 2

User1834899941 posted

I don't agree with Mike. I tested this in Oracle. If you use a VARCHAR2 cloumn, the data is stored in case sensitive form.

Give it a try in Access.

create table emp_data

(

userid VARCHAR2(10),username VARCHAR2(20)

)

alter table emp_data add constraint pk_emp_data PRIMARY KEY (userid);

insert into emp_data values('aa','Name3');

select * from emp_data

The result set is:-

userid         username

AA              Name1

BB              Name2

CC              Name3

-----------------------------------------------------------------------------

Please click Mark as Answer if this helped in solving your problem.

Answer 3

User-821857111 posted

I don't agree with Mike. I tested this in Oracle. If you use a VARCHAR2 cloumn, the data is stored in case sensitive form.

Give it a try in Access.

 

Access and Oracle are completely different.  You can't assume that what works with one database management system will work with another.  Oracle is a server-based system  Access is file-based.  Oracle has VARCHAR2 columns. Access doesn't.  Oracle supports stored procedures. Access doesn't.  You need to use Jet SQL with Access.  With Oracle, its PL/SQL.  etc, etc.....