what would be the datatype of a feild containing fingerprints in sql database?

Question

1.00/5 (1 vote)

See more:

SQL-Server-2008

, +

I`m doing a project in which i have to save the fingerprints in sql database...what should be the data type of that field/column?

Posted 6-Jul-12 8:44am

Member 8341178

Add a Solution

Comments

[no name] 6-Jul-12 14:49pm

What is the datatype of the fingerprint in your project?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2012-07-06T08:51:00

Solution 1

That's going to depend on what you have them as in your app. If they are images as seems likely, then varbinary(max) would be a good choice. If they need additional info then you might want to store them in two fields to make separating them before use easier.

Posted 6-Jul-12 8:51am

OriginalGriff

Comments

Manas Bhardwaj 6-Jul-12 15:00pm

Correct +5!

Member 8341178 6-Jul-12 15:05pm

i have to get fingerprint from the database and then match that with the input given by the user.what should it be?

OriginalGriff 6-Jul-12 15:21pm

Probably, varbinary(max).
But you should know - you have the data from the scanner that you are going to compare it with, you have the algorithm you are going to use. I don't! :laugh:
Really, it's going to be up to you as we don't know how your app works, so anything other than a generic answer is going to be unhelpful, and may well lead you off on a wrong tangent.

I do not know how you need to organise your data in order to do fast, efficient, accurate matching. I am pretty sure that you aren't just going to take two images and say "are these identical" because that would be a silly way to do it. But I can't assume you are going to convert each curve into a Besel curve and then compare the equations that make them with the compare set either (and before you ask, no, I've never tried that method, I made it up as an example). The later method would want a very different data organisation from the former.

Tim Corey 6-Jul-12 16:07pm

Good advice. +5