MySQL Forums
Forum List  »  Oracle

From ORACLE to MYSQL - CASE SENSITIVE problem with insert statement ...
Posted by: Fabio Petito
Date: June 07, 2007 09:25AM

Hi!!
I have this table in ORACLE:

create table pippo (
idpippo number(18),
cdesc varchar2(20)
)
create unique index udxpippo on pippo (cdesc asc);

whith this rows inside:
insert into pippo values (1, 'Malattie oncologiche');
insert into pippo values (2, 'Malattie Oncologiche');

In Oracle v10 I haven't problem to keep these rows because it is CASE SENSITIVE but when I try to migrate data to PIPPO in Mysql I've got this error:
ERROR 1062 (23000) at line 17197: Duplicate entry 'Malattie Oncologiche' for key 2

Can I turn on CASE SENSITIVE option in Mysql?

Fabio

Options: ReplyQuote


Subject
Views
Written By
Posted
From ORACLE to MYSQL - CASE SENSITIVE problem with insert statement ...
6403
June 07, 2007 09:25AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.