Error inserting binary data into database

Question

I'm getting this error in my php script:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'M�Uɽފ�')' at line 1

and my code:

$Connection = mysql_connect("127.0.0.1", "root", "12345678");
mysql_select_db("database5", $Connection);

$Hashsz = "FF381278A9AB19274D9755C9BDDE8A82";
$HashBin = pack("H*", $Hashsz);

$Query = "INSERT INTO Hashes (Hash) VALUES ('{$HashBin}')";
if(mysql_query($Query, $Connection))
{
    echo "inserted";
}
else
{
    echo mysql_error();
}

the value type is: binary(16)

why?

You should convert the data to a text format. Check this answer out: stackoverflow.com/questions/14505673/…. — David Vartanian
– David Vartanian, Commented Oct 1, 2015 at 0:15

Community · Accepted Answer · 2017-05-23 10:27:00Z

0

With old mysql extension you should use mysql_real_escape_string to escapes your $HashBin. Even better you shoud use prepared statements and parameterized queries. Read "How can I prevent SQL-injection in PHP?" question.

edited May 23, 2017 at 10:27

CommunityBot

11 silver badge

answered Oct 1, 2015 at 0:12

Federkun

37.2k8 gold badges82 silver badges93 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jac0b Over a year ago

a question, is not it supposed that $HashBin is a binary data? why should I use that function?

Federkun Over a year ago

just print $HashBin and see what contains

Collectives™ on Stack Overflow

Error inserting binary data into database

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related