This did not matter when testing for valid characters for regular identifiers since those cannot use Supplementary Characters. We need to make sure that we execute within a Database that has a default Collation that is Supplementary Character-aware.Testing for valid / invalid characters will be slightly tricky for a couple of reasons: And, the is being ignored as we can see here (since we get the exact same error, even without the INT We can first try to use delimiters with a name that would work even without them, just to make it easy: if this doesn’t work, then it can only be due to the delimiters and not the other characters being used. Now let’s try to declare a variable with a delimited name. Same as before: the only way to truly know is to check everything. non-delimited) identifiers, and with delimited identifiers, everything just works, right? Right? After all, the original question which sent me looking into identifiers was specific to regular (i.e. So, while it does take more time to do more extensive testing, it seems like we have little choice if we truly want to know how these things actually work.Īs much as I appreciate irony, I was about to move on, having done minimal testing on delimited identifiers and assuming that there wasn’t much else of interest there.

…based on my experiences, it seems that more often than not, doing an exhaustive test results in a slightly different answer that invalidates the previous conclusion (which was based on the limited test).

You see, way back at the very beginning (i.e.

Find invalid characters in sql