I have never used the Long Byte type but my I suspect the problem is a
string is not the same as a Byte.
"ilMes mes" <[EMAIL PROTECTED]>
01/14/2004 10:35 AM
To: [EMAIL PROTECTED]
cc: (bcc: Josh Ralph/IS/Expeditors)
Subject: RE: Insert in a LONG BYTE field, problems
Hello Alexander,
Ok, sorry,
MaxDB 7.5.00.08
on Linux RedHat 8.0
Client: SQL Studio 7.5
I do:
CREATE TABLE DATI_BINARI (
ID VARCHAR(48) NOT NULL,
DATO LONG BYTE,
PRIMARY KEY(ID)
)
--
and:
insert into DATI_BINARI (ID,DATO) VALUES ('one', X'656A3C')
I have the error:
---- Error -------------------------------
Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
Error in assignment;-8004 POS(53) Constant must be compatible with
column type and length.
insert into DATI_BINARI (ID,DATO) VALUES ('one', X'656A3C')
Why?
Tnks,
Regards
Mes
>Hello Mes,
>
>it would help a little bit if you could write
> - the error message you got when trying the statement
> - the version of SAP DB/MaxDB you are using
>so that one can analyze what went wrong, and whether that issue
>is already known, or where to look for the problem.
>
>Regards
>
>Alexander Schr�der
>SAP DB, SAP Labs Berlin
>
> >
> > if i use LONG ASCII, it work fine with:
> > insert into tableName (long_field) VALUES (x'10203d')
> >
> > If i create a table width a column LONG BYTE,
> > i do not understand the way to insert a record.
> > I try:
> > insert into tableName (long_field) VALUES (x'10203d')
> > but no not work.
> >
> > Mes
_________________________________________________________________
MSN Extra Storage: piena libert� di esprimersi e comunicare
http://join.msn.com/?pgmarket=it-it&page=hotmail/es2&xAPID=1983&DI=2049&ST=1
--
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]
