hexadecimal number format

[leven...@gmail.com]

Is there any way in phpliteadmin to view integer numbers in hexadecimal format?

Thanks,
Levente

[Christopher Kramer]

Hi,
I guess it should work like this:
Add the php-function dechex() to the $custom_functions Array in your configuration like this:

$custom_functions = array(
    'md5', 'sha1', 'time', 'strtotime', 'dechex',
    // add the names of your custom functions to this array
    /* 'leet_text', */
);

Then you should be able to use it in SELECTs like this:

 SELECT dechex(intcolumn) AS hex FROM tableName

Greetings,
Christopher