Eirikur Eiriksson (7/25/2016)
ChrisM@Work (7/25/2016)
Alan.B (7/25/2016)
Maybe it's Monday a Monday morning thing but even the small things are annoying me today. Just ran accross this:
[Gender] varchar(100) NULL,
It's fine! I've seen NVARCHAR for gender today. N'F' and N'M'. Really...
I've seen large systems (like National Statistics) go bonkers when those values have changed and once had to reject the proposal of "CM", "CF" and "UK", "Changed to Male", "Changed to Female" and "UnKnown" respectfully. Needless to say those were NVARCHAR(50) coming from an old MS-Access application:pinch:
😎
Heh... I can't wait until they declare such a thing to be PII and require it to be encrypted. 😛
--Jeff Moden
Change is inevitable... Change for the better is not.