Eike, I am with you - this feature request makes no sense. What are you going to do, create a INDEX on your LONG?
I would encourage anyone making this request needs to consider a general purposes index service - like Microsoft Index Server or Altavista code. It is my experience that these index servers are THOUSANDS of times faster than any of the SQL Database engines I have worked with (including SAPDB). http://www.microsoft.com/ntserver/techresources/webserv/IndxServ.asp Microsoft's tool even supports a SQL syntax for doing searches. It also supports very complicated searches, where the LIKE interface for SQL is often limited in the pattern matching it can do. It is free as part of the base operating system. There is also a OpenFTS (Open Full Text Search) project that uses PostgreSQL as backend for the custom indexing. Stephen -----Original Message----- From: Zabach, Elke [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 22, 2002 1:59 AM To: '[EMAIL PROTECTED]'; 'Markus Gieppner'; Koetter, Thomas Theodor; 'Srdjan Josipovic'; [EMAIL PROTECTED] Subject: RE: Problem with Selecting value of LONG data type column on WebP age ADO/ASP on IIS/WIN2k Hi, after some discussions internally now the question to the whole list: LONG-columns cannot be used in WHERE-condition (except for IS NULL-qualification). Some people ask for LIKE in LONGs or ask for '=' for LONGs. Do you really want LONG columns to be checked for LIKE (longcol LIKE 'abc*def', the star standing for 1.4325GB or so?) or do you need some longer character values, may be up to 64 KB? We here cannot imagine unformatted text with a length of more than (let's say) 64KB. Let us think of WORD-docs, but they are not unformatted and therefore comparing will usually not return the wanted result. It is easy to ask for this feature. It is not that easy to implement it. And therefore we would like to know what you need. What you need, not what is easy to write down without thinking about the usage, performance, ... Thank you Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
