Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Number of characters for license plate
Message
From
26/03/2013 08:58:30
 
 
To
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:
01569239
Views:
25
>>>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

:-}
Regex for Kanji - wouldn't know where to start....
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform