Unicode characters can be placed in tests as regular characters. However, due to editors/IDEs sometimes handling whitespace in different ways you can add a placeholder for a specific Unicode point using <U+####>.
This will be replaced with the correct character before the test runs. This is only a feature of SQL Tests, so will not work in any other context.
The SQL standard names specific white space characters that must be valid separators, we already supported this but now they are codified into tests using the new syntax above.
Unicode characters can be placed in tests as regular characters. However, due to editors/IDEs sometimes handling whitespace in different ways you can add a placeholder for a specific Unicode point using
<U+####>.This will be replaced with the correct character before the test runs. This is only a feature of SQL Tests, so will not work in any other context.
The SQL standard names specific white space characters that must be valid separators, we already supported this but now they are codified into tests using the new syntax above.