>>How can i change the data type from character to integer, binary and hexadecimal ?
>
>integer: VAL("123456")
>binary: not possible
>hexadecimal string: TRANSFORM(VAL("123456"),"@0")

Hex string is the right word. I'm seeing terms like "hex numbers" for months, and still can't believe that there are people who think that such numbers exist. Hex is just a way of writing the binary representation of byte contents. Conversion between integer and hex is just like conversion between temperature and cyrillic.

Anyone can try
? 0x100=256

(Which may eventually be used to prove that 256 is a hex number :) )