Hrmmph forgot to change formulae to get int16 so I basically was getting a double int8 , anyway I updated it to get the good int16 now but I dont know how to get an int32 (sorry hehe ) if someone can get me the good formulae I will update it , also I dont know how to get a uint8 or an sint8 (is there any difference with the int8 to get it out of mysql ?)
this is the formulae I use to get int16
((ascii(mid(profile,263,1))*1)+(ascii(mid(profile, 264,1))*256)) as \'FEET\'
and this one for int8 , any help appreciated
ascii(mid(profile, 143, 2)) as \'RACE\'