Ok, found a post (ironically it was MY post), asking the same but about
CHAR (not VARCHAR).
The solution was using "SET COLLATION EN STRENGTH PRIMARY"
After doing that before the creation of the table now the comparison
between 'testing' and 'testing ' reports they are the same.
My question i
Hello.
The current version of the SQL Standard is SQL:2016 plus corrigenda and
additional parts from 2019. Please, don't talk about SQL-92, it is
completely outdated, there are six (!) versions that were published after
it.
I don't have the very recent version of ISO/IEC 9075-2, but in previou
In some other use cases such strength is required for normal operation and
it is configurable in H2, but only in a new empty database, to change it
later database needs to be exported to SQL, edited (with some stream
editor) and re-created.
--
You received this message because you are subscrib