adjusted length of numeric value
removed try catch block
added equal test for const char
changed length of numeric value
used capacity instead of size for varchar
fixed sql bind parameter
fufilled datatype test