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]
