trailing space in len() problem

  • In other words - it only matter what the ANSI_PADDING setting was when you created the tables or added the columns. If the server default was changed after the column was created, it wouldn't have changed the behavior.

    You might care to start by recreating the table now that you know the ANSI_PADDING is the same on both environments.

    Why not first check to see what the setting actually is on each server?

    SELECT so.name AS ObjName, sac.name AS ColName, sac.is_ansi_padded, so.type

    FROM sys.objects so

    INNER JOIN sys.all_columns sac

    ON sac.object_id = so.object_id

    ORDER BY so.name, sac.name

    Reference:

    http://www.sqlservercentral.com/Forums/FindPost762819.aspx

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply