Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Number of characters for license plate
Message
From
26/03/2013 04:42:16
 
 
General information
Forum:
ASP.NET
Category:
Coding, syntax and commands
Environment versions
Environment:
VB 9.0
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01569207
Message ID:
01569221
Views:
40
>>We have an application which negotiates with license plates. It is focused to be international. It currently supports Canada, United States and another country. I would like to know how many characters you are usually reserving for such a field in your application knowing that it could be used to store license plates from all over the world.
>
>Well - http://en.wikipedia.org/wiki/European_vehicle_registration_plates#Common_letter_and_digit_systems_between_countries
>
>If you *know* the country that the car is registered in then I suppose it would be possible to build up a Regex library with one or more entries for each country.
>
>Don't see a country in Europe listed that has more than 8 letters/digits. Don't recall seeing anything longer in non-European countries...

I like the regex idea - and the patterns will need changing as-you-go, ie start with a few countries and expand. Keeps one busy

Also, the format may change in some country over time
You need at least the country of registration - maybe the state as well - and the country (via the language set) should give you LTR or RTL reading order


I'd start with nvarchar(16) - maybe even nvarchar(12) - should be sufficient and the length can be changed over time

ps: I would not volunteer to write the regex patters for arabic, chinese, japanese
Gregory
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform