From: Schroeder, Alexander (alexander.schroedersap.com)
Date: Fri Mar 12 2004 - 05:51:33 CST

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

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

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

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