1 out of 3 rated this helpful - Rate this topic

Column Data Types

The columns of the database tables are formatted in one of the following data types:

Text
UpperCase
LowerCase
Integer
DoubleInteger
Time/Date
Identifier
Property
Filename
WildCardFilename
Path
Paths
AnyPath
DefaultDir
RegPath
Formatted
FormattedSDDLText
Template
Condition
GUID
Version
Language
Binary
CustomSource
Cabinet
Shortcut

Send comments about this topic to Microsoft

Build date: 2/3/2012

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

FAQ

Category strings for MSI _Validation table

The "GUID" type needs to be written as "Guid" when used as a Category value inside the _Validation table.

History

4/1/2011
Simon J. Richter

4/1/2011
Simon J. Richter

What is the single letter prefix for each type?

Each type has a single letter used in the Column Definition Format [1]. For example, 's' is for Text and 'i' is for Integer. What are the letters for the other types?

[1] http://msdn.microsoft.com/en-us/library/aa367870.aspx

History

3/19/2010
ctaggart