General information
Forum:
Microsoft SQL Server
>The connection setting SET ANSI_PADDING controls the behavior that you're seeing. If SET ANSI_PADDING is ON, trailing blanks inserted into a varchar column are not truncated. If SET ANSI_PADDING is OFF, trailing blanks inserted into a varchar column ARE truncated.
>
>-Mike
ANSI nulls, padding, and warnings are off. The same connection works correctly on tables created in 6.5.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only