% isn't displayed back from mysql

[nightkarnation]

Ok... the --> % <-- character...is saved perfectly to mysql (from php) ... but when i want to retreive it with php (and send it to flash)...this is where the --> % <-- character is lost and not being displayed...

 

in other words the field with 75% is saved and when I grab it back from mysql it only displays 75 (without the %)

 

What should i do to fix this?

 

(I tried changing the table field to UTF- but still is not working (it works with these characters for example:  ó,í,é)

 

Thanx in advance!

Cheers,

[kenrbnsn]

Please post your code.

 

Ken

[nightkarnation]

Hope this helps:

 

if ($action == "retrieveOfferPercentage")
{

$email=$_POST['Email'];

$result = mysql_query("SELECT offerPercentage FROM offers WHERE seller = '$email'"); 
$cant = 0; 
    while($row=mysql_fetch_array($result))
{
	echo "offerPercentage$cant=$row[offerPercentage]&"; 
        $cant++;
    } 
    echo "cant=$cant&";
if($result) 
{ 
	$imdoneUpdate = true;
	echo "imdoneUpdate=".$imdoneUpdate;
} 
else 
{ 
	$imdoneUpdate = false;
	echo "imdoneUpdate=".$imdoneUpdate;
}
}

[Mchl]

What is the column datatype?

[nightkarnation]

field                    / type / ...

offerPercentage / text / latin1_spanish_ci

 

latin1_spanish_ci (currently setted, I have tried with different ones and UTF)

[PFMaBiSmAd]

So, is the % character present in the echo'ed output from your php script? Because, it is likely that you flash application is treating it as a special character and not rendering it.