The FixedString Data Type will contain any character information and is defined by an exact length.


The length of the String data will be listed in the Max Length column.  If content to be imported differs from that length, the record will be marked as invalid and the file will not be able to be imported.


Acceptable Data Formats

  • Any ASCII or Unicode characters, excluding
    • Uppercase Letters
    • Lowercase Letters
    • Numbers
    • Underscore
    • Dash


Sample Data Specification

Field Name

Data Type

Requires Value?

Max Length

Related Table

LocationCode

String

Yes

32


City

String

No

64


StateCode

FixedString

No

2


Zip

String

No

10


CountryCode

FixedString

No

2


Area

String

No

64


Region

String

No

64



Page ID:3859-2334-2438