problem with inserting a forward slash in mysql table

Question

I got problem inserting the string "AM/PM" to my mySQL table

$timeFormat = mysql_real_escape_string($_POST['timeFormat']);

$sql="
UPDATE profiles
SET firstName = '$firstName', lastName = '$lastName', language = '$language', timeFormat = '$timeFormat'
WHERE profileId = '$profileId'
";
mysql_query($sql) or die('Error: '.mysql_error());

There is no error, but the table is only showing AM/ ??

Edit:

When I echo the $sql I get:

UPDATE profiles SET firstName = 'Johan', lastName = 'Lund', language = 'English', timeFormat = 'AM/PM' WHERE profileId = '27'

And, yes I have searched the web in a very long time before asking this question. Probably if you have any link from Stackoverflow. I have already overlooked it.

Answer 1

Check your datatype in the database If it's Varchar(3) then MySQL is truncating your data.

Answer 2

nothing wrong with this insert.
it's matter of how do you see the query result.

Answer 3

Looks like that slash is doing some type of escape upon INSERT. I assume its being interpreted as "malicious" by your php interpreter.

Run this:

if(get_magic_quotes_gpc())
echo "Magic quotes are enabled";
else
echo "Magic quotes are disabled";

Let me know the result.

Answer 4

Check your character set and collation for the table, I was able to fix this with a TEXT column if it is utf8 charset and utf8_bin collation, whereas latin1 was truncating after the forward slash.