snippetsqlMinor
What is an appropriate datatype for an RFID, and is there a standard definition for the format?
Viewed 0 times
definitionformatthedatatypewhatrfidappropriatestandardforand
Problem
I have a database that tracks people based on RFID tags embedded in their shoes. This data arrives in a
I am writing a report to extract RFIDs from these messages and store them in their own table. As long as the RFIDs follow this same pattern, I can find them. If the RFID format changes, my extraction process will fail.
Is there a standard format for RFID tags? What datatype would be best suited to store RFID tags?
I am going with
VARCHAR(MAX) column with other data mixed in, in no particular order. So far, all the RFID values are formatted like the following:AnnnnnnnnAnnAAAA (where A = 0-9 and n = A-Z)I am writing a report to extract RFIDs from these messages and store them in their own table. As long as the RFIDs follow this same pattern, I can find them. If the RFID format changes, my extraction process will fail.
Is there a standard format for RFID tags? What datatype would be best suited to store RFID tags?
I am going with
VARCHAR(20) for now.Solution
I don't like answering my own questions (feels like cheating) but here goes:
According to a post on StackOverflow there is no fixed datasize. RFIDS can vary in both length and format, depending on the industry.
I will stick with varchar(20) for my own purposes, because the batch of RFIDS that we purchased all fall within that size limit.
According to a post on StackOverflow there is no fixed datasize. RFIDS can vary in both length and format, depending on the industry.
I will stick with varchar(20) for my own purposes, because the batch of RFIDS that we purchased all fall within that size limit.
Context
StackExchange Database Administrators Q#15347, answer score: 6
Revisions (0)
No revisions yet.