4 ms·
I would rather use Postgres and have a RDBMS that is quite strict and migrate data later instead of having a RDBMS that just does what it likes sometimes. For
by chrisandchris 6y ago
I would rather use Postgres and have a RDBMS that is quite strict and migrate data later instead of having a RDBMS that just does what it likes sometimes.
For example, query your table „picture“ with a first column „uuid“ (varchar) with the following query:
SELECT * FROM picture WHERE uuid = 123;
I don‘t know what you expect, I expect the query to fail because a number is not a string. MySQL thinks otherwise.
- cafard 6y agoIn Oracle it will fail, but only if uuid has characters that can't be parsed as numbers...
- chrisandchris 6y agoDoes that make it better? IMHO, it‘s even worse.