SQL varchar column length for business/company names [closed]

Question

Is there a standard for varchar length relating to storing company/business names?

I have looked everywhere and cannot find an answer.

If not, what would be an ideal length to cover the majority of scenarios?

Answer 1

I'm going to go out on a limb here:

No

There is not in general, though there are some guidelines for some of these kinds of fields, for some organisations, in some countries (see answers to List of standard lengths for database fields).

You'll have to use best judgement. Quick google search the longest I could find was a little over 100 characters - if you're not stuck for space, throw in a few hundred to be safe, otherwise why are you strapped for space? Pull it out into a lookup table, then make the column in that table wide and move on; angsting over this will not earn you anything.