Conversion problem with cast function

[Alberto Molero]

Hi all, i have a little problem with cast function in mysql.
I want convert one database (with procedures) in SQL Server to MySQL.
In SQL Server i can do this: Cast(258 As Binary(4)) and return [0, 0, 1, 2], but in MySQL return [32, 35, 38, 00]. The cast function in MySQL convert the number into char and then convert it to binary(4).

I only want do the same that i do with SQL Server...
someone know any solution for this issue?

Table definition:
Create Table If Not Exists TResult(info varbinary(8000));

Insert sample
Insert into tresult (info) values (cast(258 as binary(4)));



Edited 1 time(s). Last edit at 12/03/2012 09:38AM by Alberto Molero.