Board index   FAQ   Search  
Register  Login
Board index php forum :: Database mySQL & php coding

Should a hexadecimal number be stored as INT or VARCHAR ?

Codes here !

Moderators: macek, egami, gesf

Should a hexadecimal number be stored as INT or VARCHAR ?

Postby Tony121076 » Sat Apr 19, 2003 6:07 am

I need to use md5 to create a unique hexadecimal number for each user, but I don't know what type of column to store the result in. Is hexadecimal considered an integer?

Should a hexadecimal number be stored as INT or VARCHAR ?

Thanks in advance.
Tony121076
New php-forum User
New php-forum User
 
Posts: 28
Joined: Fri Jan 03, 2003 4:00 pm

Postby pootergeist » Sun Apr 20, 2003 3:54 am

unless you are using hex2dec conversion you could not insert an alpha character into an int field save the letter 'e'

you'd need VARCHAR(32) I think
pootergeist
New php-forum User
New php-forum User
 
Posts: 191
Joined: Wed Jan 29, 2003 7:11 am
Location: UK

Postby *JaH* » Sun Apr 20, 2003 6:24 pm

yep :)
*JaH*
New php-forum User
New php-forum User
 
Posts: 80
Joined: Fri Jan 31, 2003 4:18 pm


Return to mySQL & php coding

Who is online

Users browsing this forum: No registered users and 3 guests

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.