I want to convert Integer (byte) value into Varchar BYTE variable. So, I created procedure to perform this task.
CREATE DBPROC NUM2VARCHARBYTE (IN NUMBER INTEGER, OUT CHARBYTE VARCHAR (2) BYTE) AS
BEGIN
CASE NUMBER
WHEN 0 THEN CHARBYTE = X'00';
WHEN 1 THEN CHARBYTE = X'01';
WHEN 2 THEN CHARBYTE = X'02';
...
WHEN 255 THEN CHARBYTE = X'ff';
END;
END;
When I call this procerure CALL NUM2VARCHARBYTE (65, :x); everythink is ok x=65 => 'A' but when I call CALL NUM2VARCHARBYTE (0, :x); I get x=emptystring => length (x) = 0
Or if you know some better way how to convert to varchar, please tell me how.
Thank you for your help.
Regards, Dusan
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
