tag length value to hexadecimal

User_WWD0C

Tag = 01

length = 12

value = Bobs Records

hex = 010c426f6273205265636f726473

when i run

SELECT RAWTOHEX('Bobs Records') FROM dual

i get my desire result which is '426f6273205265636f726473'

and when i run

SELECT LENGTHB('Bobs Records') FROM dual;

i get the bytes which is 12

my question is how can i convert tlv to hex

010c426f6273205265636f726473

cormaco

Here is one way:

with tv(tag,val) as (select '01','Bobs Records' from dual)
select tag||to_char(lengthb(val),'fm0x')||rawtohex(val) as tlv from tv;

TLV                          
-----------------------------
010c426F6273205265636F726473

Note that the format model fm0x only works for lengths up to 256, you have use more 'x' for longer values.

cormaco

Here is one way:

with tv(tag,val) as (select '01','Bobs Records' from dual)
select tag||to_char(lengthb(val),'fm0x')||rawtohex(val) as tlv from tv;

TLV                          
-----------------------------
010c426F6273205265636F726473

Note that the format model fm0x only works for lengths up to 256, you have use more 'x' for longer values.

User_WWD0C

noted, worked , thank you so much , highly appreciated

User_H3J7U

RAWTOHEX('Bobs Records')

Hextoraw returns an internal presentation of value and dependends on the database characterset. Lengthb too.