Varchar BYTE concatenation problem

[Dusan Kolesar]

Hello,

I have a problem with Varchar BYTE concatenation.

CREATE TABLE "ADMIN"."TEST"
(
  "VC" Varchar (50) BYTE
)
//
CREATE DBPROC TESTVC AS
  VAR
    msg        Varchar(100) BYTE;
    byteDistLo Varchar(1) BYTE;
    byteDistHi Varchar(1) BYTE;
BEGIN
  SET byteDistLo  = x'00';
  SET byteDistHi  = x'00';
  SET msg = x'91' || x'00' || byteDistLo  || byteDistHi  || x'ff';
  INSERT ADMIN.TEST (VC) VALUES (:msg);
END;
//
CALL TESTVC
I expect '91000000ff' in the TEST table, but I get '9100ff'
Is it bug, or am I doing something wrong ??
Regards, Dusan

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]