From: Robson Paniago de Miranda (rpdmirandahotmail.com)
Date: Fri Mar 12 2004 - 07:28:34 CST

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

Hi.

I had the same problem some time ago, and I solved it adding a column
containing a hash of the LONG column, and using this hash as a key for
equality comparisions. The hash collisions where handled by my application,
in this case.

Hope this idea helps

---
Robson

----- Original Message -----
From: "Bruno Arliguy" <barliguylaposte.net>
To: <maxdblists.mysql.com>
Sent: Friday, March 12, 2004 9:25 AM
Subject: Re: [QUESTION] LONG field in WHERE clause

> 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 ;-)
>
>
> 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=rpdmirandahotmail.com
>
>

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

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