r_lachu
September 12th, 2000, 12:41 PM
Hi,
I have a stored procedure which accepts varchar(50). If i pass a string with non-visible characters, the string is malformed like 9A# followed by a character whose hex value is 20. In the stored procedure, I recieve 9A# (The last character whose value is not in the visible range is lost in the spc) . I dont seem to reconize the problem. I would appreciate any help or pointers where I went wrong
Thanx in advance,
Lakshmanan
I have a stored procedure which accepts varchar(50). If i pass a string with non-visible characters, the string is malformed like 9A# followed by a character whose hex value is 20. In the stored procedure, I recieve 9A# (The last character whose value is not in the visible range is lost in the spc) . I dont seem to reconize the problem. I would appreciate any help or pointers where I went wrong
Thanx in advance,
Lakshmanan