Dusan Kolesar wrote :
>Hello
>I have two tables:
>CREATE TABLE "ADMIN"."HWMSG"
>(
> "ID" Integer NOT NULL DEFAULT SERIAL (1),
> "TSTAMP" Timestamp,
> "MSGLEN" Integer,
> "MSG" Varchar (1024) BYTE,
> "MSGTYPE" Integer,
> PRIMARY KEY ("ID")
>)
>CREATE TABLE "ADMIN"."SWMSG"
>(
> "ID" Integer NOT NULL DEFAULT SERIAL (1),
> "HWMSGID" Integer,
> "VEHREASON" Integer,
> "VEHDATETIME" Timestamp,
> "VEHPFLAGS" Integer,
> "VEHLON" Integer,
> "VEHLAT" Integer,
> "SWMSG" Varchar (100) ASCII DEFAULT '''''',
> PRIMARY KEY ("ID")
>)
>In hwmsg.msg i have stered array of bytes from recived message.
>I want to make trigger (insert), which will decode this array of byte.
>For example 1st byte from hwmsg.msg i want to store as integer in
>vehreason,
>next 4 bytes is coded swmsg.vehdatetime as
>[HHHH HMMM], [MMMS SSSS] (sec. / 2)
>[YYYY YMMM], [MMMD DDDD] ( + 1980)
>...
>How should I do it ? How to convert varchar byte into atomic types ?
Sorry, but there's no such function available.
Regards,
Thomas
--
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]
