From: Bruno Arliguy (barliguylaposte.net)
Date: Fri Mar 12 2004 - 06:25:44 CST

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

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

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