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" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED] > >>Sent: Friday, March 12, 2004 12:19 PM > >>To: [EMAIL PROTECTED] > >>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/[EMAIL PROTECTED] > > > > > > > > -- > 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/[EMAIL PROTECTED] > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
