|
Archives of the TeradataForumMessage Posted: Wed, 14 Dec 2005 @ 19:16:26 GMT
Hi, has anyone converted a hex value into a varbyte ? We are trying to load data into a column which is defined as varbyte(64000). The following works: insert into table1 /*** table1 contains 1 column define as varbyte(64000) ***/ select 'abc'XBV; However if I have the value 'abc' stored in a character column, I haven't found a way to insert this value into a varbyte column using an insert/select. Also, we would like to convert a character column into an hex value and then to varbyte like: select char2hexint('test'); /** we would like to insert the result into a varbyte column **/ The result from char2hexint('test') is '0074006500730074' We are able to say: insert into table1 select '0074006500730074'XBV; However, we would like to do: insert into table1 select char2hexint('test'); /** with some sort of conversion ***/ Any idea ??? Thx, Arun
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||