Click here to Skip to main content
15,906,816 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi,

I'm developing an application where I need to store information from the x.509 certificate into a SQL database. Where I'm stuck is I can't find the length of some of the data so I don't know how to define my table. I know I could use vardata(max), but I rather code something reasonable. The lengths I'm looking for are Serial Number, Issuer, Subject, Issuer Alternate Name, Subject Alternate Name.

Also, I need to make a unique key and I was thinking about using the Issuer+Serial number? Would that be unique enough?

Thanks,
Glenn
Posted
Comments
ZurdoDev 2-Jan-14 15:49pm    
I would suggest just making them NVARCHAR (100) then. or 200. And move on. :)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900