Instead of using the setting ANSI_PADDING = OFF, Isah will use the setting ANSI_PADDING = ON.
You can only use features such as indexed views and filtered indexes if ANSI_PADDING = ON.
The ANSI_PADDING setting is part of the code of table columns.
For columns created with ANSI_PADDING = OFF, the following rules apply.
If you assign a value to a varchar(n) or nvarchar(n) column, trailing spaces will be trimmed and in addition, if you assign a value to a varbinary(n) column, trailing zeros will be trimmed.
If you assign a value to a nullable char(n) or nchar(n) column, trailing spaces will be trimmed and in addition, if you assign a value to a nullable binary(n) column, trailing zeros will be trimmed.
For columns created with ANSI_PADDING = ON, the following rules apply.
If you assign a value to a varchar(n) or nvarchar(n) column, trailing spaces will be inserted and in addition, if you assign a value to a varbinary(n) column, trailing zeros will be inserted.
If you assign a value to a nullable char(n) or nchar(n) column, the column will be padded with spaces to the length of the column and in addition, if you assign a value to a nullable binary(n) column, the column will be padded with zeros to the length of the column.