[h2] Re: VARCHAR comparison and trailing spaces

2019-10-09 Thread Evgenij Ryazanov
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

[h2] Re: VARCHAR comparison and trailing spaces

2019-10-09 Thread Evgenij Ryazanov
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

[h2] Re: VARCHAR comparison and trailing spaces

2019-10-09 Thread Fawzib Rojas
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