[Problem] Data from Mu Database

[Kernal112]

Hi guys when i was pulling some data from my database i came across a problem observe:

$dbhost   = "test";      $db       = "MuOnline";       $user     = "sa";     $password = "12345";   
    @mssql_connect($dbhost,$user,$password) or die("Não foi possível a conexão com o servidor!");    @mssql_select_db("$db") or die("Não foi possível selecionar o banco de dados!");        $sql = mssql_query('SELECT * FROM Character WHERE Name = "test"');
    $data = mssql_fetch_array ($sql);
        echo $data['Inventory']; 

He display this:

@Pÿÿÿÿÿ5`ÿÿÿÿÿ-pÿÿÿÿÿ-€ÿÿÿÿÿ-ÿÿÿÿÿ- ÿÿÿÿÿ-°ÿÿÿÿÿ
Ë"p]Àÿÿÿÿÿ
@ÐÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿàÿÿÿÿÿÿàÿÿÿÿÿB "2RÐÿÿÿÿÿÿàÿÿÿÿ

But in data field i have this:

0x0B8430002268BE04000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF011D3C0000000000007000FFFFFFFFFF011D410000000000008000FFFFFFFFFF011D3F0000000000009000FFFFFFFFFF011D37000000000000A000FFFFFFFFFF011D39000000000000B000FFFFFFFFFF0238D20021C7CD4000C000FFFFFFFFFF0100A3000000000000D000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF14101E000000000000D000FFFFFFFFFF14081E000000000000D000FFFFFFFFFF0600FF000000000000E000FFFFFFFFFF0600FF000000000000E000FFFFFFFFFF02009E000000000000E000FFFFFFFFFF0600FF000000000000E000FFFFFFFFFF0600FF000000000000E000FFFFFFFFFF0D000100226EED0000E000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0F0001000000000000C000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0600FF000000000000E000FFFFFFFFFF0600FF000000000000E000FFFFFFFFFF0600FF000000000000E000FFFFFFFFFF0600FF000000000000E000FFFFFFFFFF0600FF000000000000E000FFFFFFFFFF060023000000000000E000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0F0001000000000000C000FFFFFFFFFF0F0001000000000000C000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF02005D000000000000E000FFFFFFFFFF0200FF000000000000E000FFFFFFFFFF0200FF000000000000E000FFFFFFFF

How i can display the correct data ? The field is a varbinary(3792) null. Its required convert the field when selecting or something?
Thanks for~the attention.

[MentaL]

[invasionGB]

Use the hexdec function

echo hexdec($data['Inventory']);

[Kernal112]

i use this

echo hexdec($data['Inventory']); 

and show this number:

34226 

- - - Updated - - -

but i need all this code from the field

0x0B8430002268BE04000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF011D3C0000000000007000FFFFFFFFFF011D410000000000008000FFFFFFFFFF011D3F0000000000009000FFFFFFFFFF011D37000000000000A000FFFFFFFFFF011D39000000000000B000FFFFFFFFFF0238D20021C7CD4000C000FFFFFFFFFF0100A3000000000000D000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF14101E000000000000D000FFFFFFFFFF14081E000000000000D000FFFFFFFFFF0600FF000000000000E000FFFFFFFFFF0600FF000000000000E000FFFFFFFFFF02009E000000000000E000FFFFFFFFFF0600FF000000000000E000FFFFFFFFFF0600FF000000000000E000FFFFFFFFFF0D000100226EED0000E000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0F0001000000000000C000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0600FF000000000000E000FFFFFFFFFF0600FF000000000000E000FFFFFFFFFF0600FF000000000000E000FFFFFFFFFF0600FF000000000000E000FFFFFFFFFF0600FF000000000000E000FFFFFFFFFF060023000000000000E000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0F0001000000000000C000FFFFFFFFFF0F0001000000000000C000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF02005D000000000000E000FFFFFFFFFF0200FF000000000000E000FFFFFFFFFF0200FF000000000000E000FFFFFFFF

[invasionGB]

Normally you should be able to see the data printed. hexdec and and bin2hex are your friends. Take a look on them

[Kernal112]

hm, looki i try this

$dteste = bin2hex($data['Inventory']); 
echo $dteste; 

and show

051d380000000000005000ffffffffff0e1d350000000000006000ffffffffff031d2d0000000000007000ffffffffff031d2d0000000000008000ffffffffff031d2d0000000000009000ffffffffff031d2d000000000000a000ffffffffff031d2d000000000000b000ffffffffff011bcb0022705d0000c000ffffffffff010028000000000000d000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0600ff000000000000e000ffffffffff0200ff000000000000e000ffffffffff42000a002232520000d000ffffffffff0600ff000000000000e000fffffff...

but not

0B8430002268BE04000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF011D3C00000000000FFFF...

- - - Updated - - -

i think i'm making this wrong because i already have the hex in the field.

[invasionGB]

hm, looki i try this

$dteste = bin2hex($data['Inventory']); 
echo $dteste; 

and show

051d380000000000005000ffffffffff0e1d350000000000006000ffffffffff031d2d0000000000007000ffffffffff031d2d0000000000008000ffffffffff031d2d0000000000009000ffffffffff031d2d000000000000a000ffffffffff031d2d000000000000b000ffffffffff011bcb0022705d0000c000ffffffffff010028000000000000d000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0600ff000000000000e000ffffffffff0200ff000000000000e000ffffffffff42000a002232520000d000ffffffffff0600ff000000000000e000fffffff...

but not

0B8430002268BE04000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF011D3C00000000000FFFF...

- - - Updated - - -

i think i'm making this wrong because i already have the hex in the field.

bin2hex should display whatever you have stored in that field. The only difference is that you won't see el 0x. Check your code. Maybe you doing something else with the data before parsing it to the bin2hex function.

[Kernal112]

hm this is so stranger because this is all code i have in page:

$dbhost   = "test";      $db       = "MuOnline";       $user     = "sa";     $password = "12345";       @mssql_connect($dbhost,$user,$password) or die("Não foi possível a conexão com o servidor!");    @mssql_select_db("$db") or die("Não foi possível selecionar o banco de dados!");        $sql = mssql_query('SELECT * FROM Character WHERE Name = "test"');    $data = mssql_fetch_array ($sql);        $dteste = bin2hex($data['Inventory']); echo $dteste;