char(n) [1]
nchar(n) [2]
nvarchar(n) [2]
varchar(n) [1]
1.
2.
1. Precision is required when using NUMBER unless you have set the data source property Campaign > partitions > partition N > dataSources > [dataSourceName] > UseSQLToRetrieveSchema to TRUE. If you do not specify a precision and do not set that data source property, Campaign assumes it can store the values in a data type that preserves 15 digits of precision. This can be problematic because, if the field holds values whose precision exceeds 15 digits, precision will be lost when the value is brought into Campaign.char(n) [1]
nchar [2]
nvarchar [2]
varchar(n) [1]
1.
2.
IBM Unica Campaign
8.5.0
|
Copyright IBM Corporation 2011. All Rights Reserved.
|
For more information, see our support and community site: Customer Central
|
|