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]
