Create a table like the following:
create table user (name varchar(4));
MySql:
insert into user (name) values ('antoaravinth');
The above statement works even though I have given the size of my varchar as 4! And retrieving gives me `anto`!!
Postgres:
Stops me there with the relevant exception! That shows how Postgresql is doing small things right.
After seeing this, I never used MySql!
Create a table like the following:
create table user (name varchar(4));
MySql:
insert into user (name) values ('antoaravinth');
The above statement works even though I have given the size of my varchar as 4! And retrieving gives me `anto`!!
Postgres:
insert into user (name) values ('antoaravinth');
Stops me there with the relevant exception! That shows how Postgresql is doing small things right.
After seeing this, I never used MySql!