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]
