The null character seems a good candidate and it works well in my tests. Problem with concatenation is that NULL is converted to an empty string, so both ('foo', NULL) and ('foo', '') which may represent different entities would be consider the same. I'm looking for an alternative to concatenation… I tried with checksum but it fails hard on collisions. |