Re: Varchar BYTE concatenation problem

[Dusan Kolesar]

Thanks a lot,
It works.
 Dusan

On Thu, 15 Apr 2004 18:40:40 +0200, Zabach, Elke <[EMAIL PROTECTED]> 
wrote:

Dusan Kolesar wrote:

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

the answer looks a little bit -- strange --, but will help:

SET msg = x'91' || x'00' || substr(byteDistLo,1,1)  || 
substr(byteDistHi,1,1)  || x'ff';

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