Menu
Community /Pin to ProfileBookmark
@benanamenDec 14.2017 — #Question has already been answered under OP's alt user name here http://forums.devnetwork.net/viewtopic.php?f=1&t=144938 
@NogDogDec 14.2017 — #bigint only holds an integer, it just allows big ones. When you tried to load the [i]string[/i] "22d200f8670dbdb3e253a90eee5098477c95c23d" (which though it looks like a hexadecimal number it is actually just a string in this context), something -- probably your PHP code somewhere -- tried to convert it into an integer, was okay with the first two characters, than ran into a letter, and stopped trying.
In any case, I'd recommend making the activation code column larger, just in case: varchar only actually uses the number of bytes for each string being stored plus a few "bookkeeping" bytes on top of that, so you might as well make it varchar(255) or such, in case you ever decide to use something different.
Is Not BigInt Or VARCHAR (40) Not Big Enough To House sha1?
I want to know if BigInt is enough in size. I have created a registration.php where the user gets emailed an account activation link to click to verify his email so his account gets activated.
Account Activation Link is in this format:
[code=php]
$account_activation_link =
“http://www.”.$site_domain.”/”.$social_network_name.”/activate_account.php?primary_website_email=”.$primary_website_email.”&account_activation_code=”.$account_activation_code.””;
Account Activation Code is in this format:
$account_activation_code = sha1( (string) mt_rand(5, 30)); //Type Casted the INT to STRING on the 1st parameter of sha1 as it needs to be a STRING.
Now, the following link got emailed: [url]http://www.myssite.com/folder/[email protected]&account_activation_code=22d200f8670dbdb3e253a90eee5098477c95c23d
Note the account activation code that got generated by sha1: 22d200f8670dbdb3e253a90eee5098477c95c23d
But in my mysql db, in the “account_activation_code” column, I only see: “22”. The rest of the activation code is missing. Why is that ? The column is set to BigInt. Is not that enough to house the Sha1 generated code ? What is your suggestion ?
I changed mysql column type to VARCHAR(40) and then VARCHAR(160) and even to BINARY(40) but no luck.
The sha1 generates the account activation code to 40 digits in the account activation link that gets emailed to the user but the account_activation_code mysql column does not hold that 40 digit value. Only holds the first 2 or 3 digits. What is wrong ?
Using php 5.
Sign in
to post a comment7 Comments(s) ↴
0
@benanamenDec 14.2017 — #Question has already been answered under OP's alt user name here 0
@NogDogDec 14.2017 — #bigint only holds an integer, it just allows big ones. When you tried to load the [i]string[/i] "22d200f8670dbdb3e253a90eee5098477c95c23d" (which though it looks like a hexadecimal number it is actually just a string in this context), something -- probably your PHP code somewhere -- tried to convert it into an integer, was okay with the first two characters, than ran into a letter, and stopped trying.<i>
</i>21:15 $ php -a
Interactive shell
php > $test = '22ab123cd456';
php > echo $test;
22ab123cd456
php > $test2 = (int) $test;
php > echo $test2;
22
php > ^C
In any case, I'd recommend making the activation code column larger, just in case: varchar only actually uses the number of bytes for each string being stored plus a few "bookkeeping" bytes on top of that, so you might as well make it varchar(255) or such, in case you ever decide to use something different.