How to insert a string containing the *character in the mysql database

Question

I am using PHP and Mysql and am trying to add a NEXTEL and CLARO radio ID field:

23*4567

But when I check what was entered, I see that only recorded what was before *, so:

23

Using a normal query like this:

INSERT INTO tabela (id_radio) VALUES ("23*4567")

I tried to use the functions, but nothing worked.

addslashes()
mysql_real_scape_string()

Some function is needed for * to be accepted by mysql?

Answer 1

Just change the field type to scan and insert as string in the field.

Answer 2

If you use a parameterized query the bank will be able to insert special characters without any problem. You only need to escape the values if you are creating the query at hand, with fixed literals.

//$dbh é a sua conexão com o BD.
$stmt = $dbh->prepare("INSERT INTO tabela (id_radio) VALUES (?)");
$stmt->execute(array("23*4567"))

Answer 3

If the field that has the radio number is numeric(int, float, Numeric) change it to varchar, this also eliminates the problem of some number starting with zero as they are removed when they are left.

The code to alter the column type is this:

ALTER TABLE tabela MODIFY  campo varchar(50)

I did a test create a table with two columns and ran this Insert directly in the database

INSERT INTO radios(radio_int, radio_varchar) values(23*4567, '23*4567')

the result was

radio_int: 105041
radio_varchar: 23*4567

Answer 4

Try sending the character char * instead of the character itself for example:

INSERT INTO tabela (id_radio) VALUES ("23".CHAR(42)."4567")