Conversion from Char to Varchar

pandujoy · Post by **pandujoy** » Thu Nov 05, 2009 12:19 pm

Hi,

I have a char field coming from input and i am doing a lookup from DB which have a datatype of char. When i am deploying this as a serivce i am getting output as "&#0" which are special characters.

is there a way to eliminate these ? If we use varchar we wont get it but we cant do a lookup against char to varchar.....please help me out

ray.wurlod · Post by **ray.wurlod** » Thu Nov 05, 2009 1:59 pm

Check the setting of APT_STRING_PADCHAR environment variable.

pandujoy · Post by **pandujoy** » Thu Nov 05, 2009 3:19 pm

it is set to 0x0 ...not sure what it must be..plz help me out

pandujoy · Post by **pandujoy** » Thu Nov 05, 2009 3:22 pm

its a Char (4) data type

pandujoy · Post by **pandujoy** » Thu Nov 05, 2009 3:48 pm

Thanks a lot for your help...I could solve it out...I made APT_STRING_PADCHAR....as 0x20 and used the trim function - Trim(<Col name>,Char(0),'A')