From: Zabach, Elke (elke.zabachsap.com)
Date: Fri Mar 12 2004 - 08:42:58 CST

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

Bruno Arliguy wrote:
>
>
> Thanks Alexander for your quick reply.
>
> And there is no way to allow VARCHAR size to be bigger than 4000
> positions (in UNICODE), for example a parameter when the database is
> created? By recompiling maxdb?
>
> We not need 2GB, only 10 or 20 KB ;-)
>

Sorry, no chance as recordsize is limited to a little bit less than 8KB
and no column is allowed to exceed recordsize.

Elke
SAP Labs Berlin

>
> Schroeder, Alexander wrote:
> > Hello Bruno,
> >
> > unfortunately, there is no way to use content of a LONG
> column in any
> > expression for searching and sorting.
> >
> > Sorry for any inconvenience caused
> >
> > Alexander Schröder
> > SAP DB, SAP Labs Berlin
> >
> >
> >>-----Original Message-----
> >>From: Bruno Arliguy [mailto:barliguylaposte.net]
> >>Sent: Friday, March 12, 2004 12:19 PM
> >>To: maxdblists.mysql.com
> >>Subject: [QUESTION] LONG field in WHERE clause
> >>
> >>
> >>Hi list. It's my fisrt message, happy to use MaxDB :)
> >>
> >>Could you tell me if there is a way to use a LONG field in a
> >>WHERE clause?
> >>
> >>For exemple, a table like this :
> >>CREATE TABLE SYS_CODE
> >>(
> >> CREATED TIMESTAMP,
> >> UPDATED TIMESTAMP,
> >> PKREF INTEGER NOT NULL,
> >> CODE_CONTENT LONG UNICODE
> >>)
> >>
> >>I would like to use the CODE_CONTENT field in a WHERE clause
> >>(mainly to
> >>find a text). If I try this, I get an error message "General
> >>error;-7032
> >>POS(32) SQL statement not allowed for column of data type LONG."
> >>
> >>Or do you know an other way to store text field (up to
> 10000 char) and
> >>search on it?
> >>
> >>Thanks.
> >>
> >>--
> >>Bruno
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>--
> >>Ce message Envoi est certifie sans virus connu.
> >>Analyse effectuee par Anti-virus AVG (http://www.grisoft.com).
> >>Version: 7.0.225 / Base de donnees virus: 262.2.0 - Date: 04/03/2004
> >>
> >>
> >>
> >>
> >>
> >>--
> >>Ce message Envoi est certifie sans virus connu.
> >>Analyse effectuee par Anti-virus AVG (http://www.grisoft.com).
> >>Version: 7.0.225 / Base de donnees virus: 262.4.3 - Date: 11/03/2004
> >>
> >>
> >>--
> >>MaxDB Discussion Mailing List
> >>For list archives: http://lists.mysql.com/maxdb
> >>To unsubscribe:
> >
> > http://lists.mysql.com/maxdb?unsub=alexander.schroedersap.com
> >
>
>
>
>
>
> --
> Ce message Envoi est certifié sans virus connu.
> Analyse effectuée par Anti-virus AVG (http://www.grisoft.com).
> Version: 7.0.225 / Base de données virus: 262.4.3 - Date: 11/03/2004
>
>
> --
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe:
> http://lists.mysql.com/maxdb?unsub=elke.zabachsap.com
>

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb

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