String Format

The Commerce database supports strings of 4000 characters. Since the Data Warehouse only supports strings of 512 characters, any string consisting of more than 512 characters will be truncated to 512 characters when it is imported.

For multi-valued strings, the count includes one additional character (the semicolon) per element, the length of the integer specifying the number of elements, plus one.

Copyright © 2005 Microsoft Corporation.
All rights reserved.