dbTalk Databases Forums  

Use IDs or strings?

comp.databases comp.databases


Discuss Use IDs or strings? in the comp.databases forum.



Reply
 
Thread Tools Display Modes
  #91  
Old   
--CELKO--
 
Posts: n/a

Default Re: Use IDs or strings? - 12-23-2008 , 05:27 PM






Quote:
How does one handle cars manufactured before VINs came into use?
You will be issued a VIN if you want to drive the vehicle on a public
road. If you build your own vehicle, then you inherit the VIN on the
engine block or you get issued one. If the manufacturer went out of
business before 1950, you get a dummy value from a DMV or national
agency. Hey, they want your money.

Here are some more details: http://www.vinguard.org/vin.htm

Quote:
How about books before ISBNs began to be used? Which identification systems are commonly used?
Having owned some bookstores in the past, it is much the same scheme.
We used a dummy language sub-code of 99 (97 is Esperanto), a Dewey
Decimal Classification and then a sequence within the DDC.

In retail, if you make a product in-house (bakery in a grocery store),
there are "open codes" in the UPC so you can bar-code the goods.

If you look for it, you will find a standard or two that will help and
give you validation and verification rules.



Reply With Quote
  #92  
Old   
Elmer Fudd
 
Posts: n/a

Default Re: Use IDs or strings? - 12-24-2008 , 11:04 AM






Thank you, great to know!

On Tue, 23 Dec 2008 15:27:34 -0800 (PST), --CELKO-- wrote:

Quote:
How does one handle cars manufactured before VINs came into use?

You will be issued a VIN if you want to drive the vehicle on a public
road. If you build your own vehicle, then you inherit the VIN on the
engine block or you get issued one. If the manufacturer went out of
business before 1950, you get a dummy value from a DMV or national
agency. Hey, they want your money.

Here are some more details: http://www.vinguard.org/vin.htm

How about books before ISBNs began to be used? Which identification systems are commonly used?

Having owned some bookstores in the past, it is much the same scheme.
We used a dummy language sub-code of 99 (97 is Esperanto), a Dewey
Decimal Classification and then a sequence within the DDC.

In retail, if you make a product in-house (bakery in a grocery store),
there are "open codes" in the UPC so you can bar-code the goods.

If you look for it, you will find a standard or two that will help and
give you validation and verification rules.





Reply With Quote
  #93  
Old   
Elmer Fudd
 
Posts: n/a

Default Re: Use IDs or strings? - 12-24-2008 , 11:04 AM



Thank you, great to know!

On Tue, 23 Dec 2008 15:27:34 -0800 (PST), --CELKO-- wrote:

Quote:
How does one handle cars manufactured before VINs came into use?

You will be issued a VIN if you want to drive the vehicle on a public
road. If you build your own vehicle, then you inherit the VIN on the
engine block or you get issued one. If the manufacturer went out of
business before 1950, you get a dummy value from a DMV or national
agency. Hey, they want your money.

Here are some more details: http://www.vinguard.org/vin.htm

How about books before ISBNs began to be used? Which identification systems are commonly used?

Having owned some bookstores in the past, it is much the same scheme.
We used a dummy language sub-code of 99 (97 is Esperanto), a Dewey
Decimal Classification and then a sequence within the DDC.

In retail, if you make a product in-house (bakery in a grocery store),
there are "open codes" in the UPC so you can bar-code the goods.

If you look for it, you will find a standard or two that will help and
give you validation and verification rules.





Reply With Quote
  #94  
Old   
Elmer Fudd
 
Posts: n/a

Default Re: Use IDs or strings? - 12-24-2008 , 11:04 AM



Thank you, great to know!

On Tue, 23 Dec 2008 15:27:34 -0800 (PST), --CELKO-- wrote:

Quote:
How does one handle cars manufactured before VINs came into use?

You will be issued a VIN if you want to drive the vehicle on a public
road. If you build your own vehicle, then you inherit the VIN on the
engine block or you get issued one. If the manufacturer went out of
business before 1950, you get a dummy value from a DMV or national
agency. Hey, they want your money.

Here are some more details: http://www.vinguard.org/vin.htm

How about books before ISBNs began to be used? Which identification systems are commonly used?

Having owned some bookstores in the past, it is much the same scheme.
We used a dummy language sub-code of 99 (97 is Esperanto), a Dewey
Decimal Classification and then a sequence within the DDC.

In retail, if you make a product in-house (bakery in a grocery store),
there are "open codes" in the UPC so you can bar-code the goods.

If you look for it, you will find a standard or two that will help and
give you validation and verification rules.





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.