I'd be more than surprised if Oracle would not distinguish 'admin' from 'admin ' on insert, but I don't have an Oracle server handy to test. I can assure that this doesn't happen with Postgres (tested on 9.4 - 10)
Very interesting findings. I hope t never bump into issues like that :)
I'd be more than surprised if Oracle would not distinguish 'admin' from 'admin ' on insert, but I don't have an Oracle server handy to test. I can assure that this doesn't happen with Postgres (tested on 9.4 - 10)
Very interesting findings. I hope t never bump into issues like that :)
I'm not that familiar with Oracle but based on this sqlFiddle, I can confirm to you that this does work:
sqlfiddle.com/#!4/c0be1c/19813
Ran in Oracle SQLDev:
It is correct that Oracle automatically trims leading and trailing spaces.
Edit: I should mention that this is on 18.2