var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Compatibility Issues: MySQL and Oracle
Hello guys, im wondering if you could help me with compatibility issues between MySQL and Oracle databases. im having trouble finding it anywhere else.
Are they any Issues in compatibility, and if so what?
As MySQL has a lot of stupid behaviours (especially in a plain vanilla installation), there will be a lot of issues. Take the following statement:
This will work in a default MySQL installation but not in Oracle.
create table foo (start_date date);
insert into foo (start_date) values (date '2013-02-31');
The following code
will work in MySQL, but in no other DBMS.
create table foo (some_value int, other_value int);
insert into foo values (1,0);
The following statement will work in MySQL but not in Oracle
This is just a short list I can immediately think of.
create table foo (some_col varchar(64));
insert into foo (some_col) values ('foobar');
select * from foo where some_col = 2;
There are a lot more of these things and it's impossible to give you a complete list.