trailing space in len() problem

• Nadrek

  SSC-Insane

  Points: 20039

  More actions

  September 27, 2012 at 8:22 am

  #1542931

  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