hex 00 through chr(00) does not show up in the string viewed in Hex Edit
I am building a string assigned to a text_item. when i run the form it displays the string. In this string are a bunch of chr(01), chr(02), chr(00) concatenated. when I cop and paste this string in an editor that allows hex edit, I see all the hex representations of the above except chr(00) w/c would give a hex 00. My question is how would you have hex 00 display in hex edit after building your string. hex 00 = dec 00 = ^@ = null in char.
I have tried chr(0), chr(null), chr(''), rawtohex(0). in sqlplus they give me a null value. In hex edit mode, they don't even show up. I want an actual 00 in hex edit mode.
Any help will be appreciated.
thanks