[Resolved] strlen and substr problem

Spudgun

I've got a string I'm trying to feed into the database. The string is over 8000 characters long which is longer than the db can store. What I am trying to do is count the length of the string, and then do a substring on it and feed it into to fields if the length is bigger than 8000. Both fields on the db are varchar set to a mx length of 8000.

$len = strlen($bodytext);
 print($len);
 if($len < "7999")
 {
  	$bodytext1 = $bodytext;
 	$bodyqryins1 = " insert into tbxlogemailtemplate (Email_ref,Header_Title,Subject_Line,Body_text) values (\"$emailref\",\"$headtit\",\"$subj\",'$bodytext') ";
 	$bodyqryins1res = mssql_query($bodyqryins1);
 }
 else
 {
 	$bodytext1 = substr($bodytext,0,7999);
 	$len1 = strlen($bodytext1);
                $len2=($len-$len1);
 	$bodytext2 = substr($bodytext, 8000,$len2);
 	$len3 = strlen($bodytext2);

$bodyqryins = " insert into tbxlogemailtemplate (Email_ref,Header_Title,Subject_Line,Body_text,Body_Text2) values (\"$emailref\",\"$headtit\",\"$subj\",'$bodytext1','$bodytext2') ";

 $bodyqryinsres = mssql_query($bodyqryins);
 }

When I do this, I get an error message saying a string greater than 8000 in length cannot be inserted..
Anyone got any idea?
Thanks

OhLordy

Why not change your data base so that you can accept larger strings? If you use the LONGTEXT type you have a limit of 4billion characters! That should be enough shouldn't it?
HTH
Rob

lanjoky

Echo the lengths once you creat them to the screen and tell us the values of each ... will help to see which substr is giving you problems...

Thanks

Spudgun

Ok - what I have is this:

Len is 8091
Len1 is 7999
Len3 is 92
Len2 is 92

So I would have thought that to get the remaining characters from the string wouldn't it be:
$var = substr($var, 7999,92);

Unless I'm being really daft that is.
Thanks for the help

lanjoky

I am thinking its

$var = substr($var, 7999);

that way it grabs from 7999 to the end of the string.

Spudgun

Hmm - just tried that and got:

Len is 8091
Len1 is 7999
Len3 is 92
Len2 is 92

Warning: mssql_query() [function.mssql-query]: message: Cannot create a row of size 8129 which is greater than the allowable maximum of 8060. (severity 16) in d:\intranet\emailer.php on line 82

The really strange thing here is even looking at the error message, I can't see how the size 8129 is being calculated!

Spudgun

Sorry guys. I've just worked it out (after spending the last day on this!!!)
Its MSSQL - it is only allowing me to post 8060 characters into the row at one time - its not substr and strlen as I thought.
I just need then to run two insert statements in the case of the varaible being more than 8000 characters - and thats it.

Thanks for your help again guys.