In the SAS Campaign Management component, the width of a text field
exported to a database table may not match the width specified in the
interface definition.

For example, if you add a field of type TEXT to an interface
definition and set the width of the field to be 20, then only enter 10
characters (including blank spaces) as the value of the TEXT field,
when the Export to database runs, the field in the resulting table
has a length of 10, not 20.  Also, if you enter a value longer than 20
characters, the width column does not expand to accomodate the longer
value.

If you create a field with only 1 blank, this will be created as a null
rather than a blank.  This will always be the case, even after the fix.


A Technical Support hot fix for this issue is available at:
http://ftp.sas.com/techsup/download/hotfix/cam75.html

If you are running Campaign Management with data in a DB2 database, and
you apply the hotfix, any TEXT fields added to the interface definition
with a value consisting of a single blank value are exported to the
database table as a NULL.

Even though a hotfix  is available, there is still an issue where if the
text width is assigned a width of 1 character, it gets exported as a
numeric, any width over 1 character is fine.

Operating System and Release Information

A fix for this issue for Campaign Management Component 7.5 is available at: