locked
Case Sensitive Insert Query(Access) RRS feed

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

    Tuesday, January 29, 2008 8:07 AM

Answers

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


    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, February 1, 2008 7:19 AM

All replies

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

     

    Tuesday, January 29, 2008 3:03 PM
  • 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.

    Friday, February 1, 2008 5:33 AM
  • 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.....


    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, February 1, 2008 7:19 AM