- Organization varchar(200) NULL ,
- RealName varchar(120) NULL ,
- NickName varchar(16) NULL ,
- Lang varchar(16) NULL ,
- EmailEncoding varchar(16) NULL ,
- WebEncoding varchar(16) NULL ,
- ExternalContactInfoId varchar(100) NULL ,
- ContactInfoSystem varchar(30) NULL ,
- ExternalAuthId varchar(100) NULL ,
- AuthSystem varchar(30) NULL ,
- Gecos varchar(16) NULL ,
- HomePhone varchar(30) NULL ,
- WorkPhone varchar(30) NULL ,
- MobilePhone varchar(30) NULL ,
- PagerPhone varchar(30) NULL ,
- Address1 varchar(200) NULL ,
- Address2 varchar(200) NULL ,
- City varchar(100) NULL ,
- State varchar(100) NULL ,
- Zip varchar(16) NULL ,
- Country varchar(50) NULL ,
+ Organization varchar(200) collate NOCASE NULL ,
+ RealName varchar(120) collate NOCASE NULL ,
+ NickName varchar(16) collate NOCASE NULL ,
+ Lang varchar(16) collate NOCASE NULL ,
+ EmailEncoding varchar(16) collate NOCASE NULL ,
+ WebEncoding varchar(16) collate NOCASE NULL ,
+ ExternalContactInfoId varchar(100) collate NOCASE NULL ,
+ ContactInfoSystem varchar(30) collate NOCASE NULL ,
+ ExternalAuthId varchar(100) collate NOCASE NULL ,
+ AuthSystem varchar(30) collate NOCASE NULL ,
+ Gecos varchar(16) collate NOCASE NULL ,
+ HomePhone varchar(30) collate NOCASE NULL ,
+ WorkPhone varchar(30) collate NOCASE NULL ,
+ MobilePhone varchar(30) collate NOCASE NULL ,
+ PagerPhone varchar(30) collate NOCASE NULL ,
+ Address1 varchar(200) collate NOCASE NULL ,
+ Address2 varchar(200) collate NOCASE NULL ,
+ City varchar(100) collate NOCASE NULL ,
+ State varchar(100) collate NOCASE NULL ,
+ Zip varchar(16) collate NOCASE NULL ,
+ Country varchar(50) collate NOCASE NULL ,