Re: [h2] Re: show hex value

[mche...@gmail.com]

thank you sir

On Sunday, 22 January 2023 at 10:01:17 UTC+8 Evgenij Ryazanov wrote:

> Hello!
>
> There is a RAWTOHEX  
> function, you can convert this integer number to a BINARY(4) data type 
> and pass the result to this function:
> SELECT RAWTOHEX(CAST(1234567890 AS BINARY(4)));
>

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/h2-database/20d83162-6bd7-4896-a773-0763888fd24dn%40googlegroups.com.

Re: [h2] Re: show hex value

[Evgenij Ryazanov]

Hello!

There is a RAWTOHEX  
function, you can convert this integer number to a BINARY(4) data type and 
pass the result to this function:
SELECT RAWTOHEX(CAST(1234567890 AS BINARY(4)));

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/h2-database/c06add93-e74c-4aba-8269-ff5bfcbcaa34n%40googlegroups.com.

Re: [h2] Re: show hex value

[Andreas Reichel]

Greetings.

On Sat, 2023-01-21 at 09:21 -0800, mche...@gmail.com wrote:
> hi , possible to show an integer in hex format?

As far as I understand you can define your own Functions in H2, using
Java language.
This should do the trick.

Cheers
Andreas

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/h2-database/a31de4029ae59bc816058a7a63793e5eab542902.camel%40manticore-projects.com.

[h2] Re: show hex value

[mche...@gmail.com]

hi , possible to show an integer in hex format?

On Wednesday, 4 January 2023 at 16:55:47 UTC+8 Evgenij Ryazanov wrote:

> Hi!
>
> H2 Console already displays values of binary strings in hexadecimal 
> format, if you need a similar feature in other tool you should ask its 
> developers instead.
>
> There is also a RAWTOHEX 
>  function, you can 
> use it to convert a binary string to a character string with hexadecimal 
> representation.
>

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/h2-database/112b703a-38cd-4235-b2b8-253b1f92f7a2n%40googlegroups.com.

[h2] Re: show hex value

[Evgenij Ryazanov]

Hi!

H2 Console already displays values of binary strings in hexadecimal format, 
if you need a similar feature in other tool you should ask its developers 
instead.

There is also a RAWTOHEX 
 function, you can use 
it to convert a binary string to a character string with hexadecimal 
representation.

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/h2-database/31e4a71e-b5e7-4f28-a405-f99c6ec23df2n%40googlegroups.com.