From: ilMes mes (il_meshotmail.com)
Date: Wed Jan 14 2004 - 12:35:28 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]