In 188.8.131.52, I’m using the wonderful Compare Data to synchronize the data between two tables with the “Create Script” option. The generated statements work except when the difference between two column values is spaces on the source and nulls on the target. The generated statement says:
UPDATE MYSCHEMA.MYCOOLTBL SET SILLYCOL = ‘’ WHERE ROWID = ‘AAAcOfAAUAAHRM8AAJ’;
On a nullable column, this doesn’t do anything since the target is already nulls. It should be set to the same number of spaces as the source. Technically, since the source for this example is type NCHAR, the SQL should have the implicit string preceded with an “N”, as well, shouldn’t it?