Re: Conversion problem with cast function

[Dmitry Tolpeko]

Hi Alberto,

You are right, MySQL converts 258 to 323528 byte sequence before inserting into a BINARY column.

Can you change your application to insert a hex literal instead of integer value to solve this problem? By the way hex literals are allowed in both SQL Server and MySQL.

MySQL:

  INSERT INTO tresult VALUES (0x00000102);

You can check that this binary value (bytes 00, 00, 01, 02) was inserted using HEX function:

 SELECT HEX(info) FROM tresult;

+-----------+
| HEX(info) |
+-----------+
| 00000102 |
+-----------+

Thanks,

Dmitry Tolpeko

--
SQLines - SQL Server to MySQL Database Migration Tools
http://www.sqlines.com