Hi,

for my content management system I have to realize an indexed full text
search to search through articles. The sql-code must be generic, so that
my cms works indepently of the used sql-server.
Due to my lack of information on standard compliance of various
sql-severs, I would have to implement a workaround(which would'nt be
that fast).
I've already searched several times for documents on sql-standards on
the internet, but I didn't find anything.

Here's the mysql-syntax to perform a full text search:

creating table with FULLTEXT-indexes:
CREATE TABLE articles (
-> id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
-> title VARCHAR(200),
-> body TEXT,
-> FULLTEXT (title,body)
-> );

search-query (after some insert statemendt:
SELECT * FROM articles WHERE MATCH (title,body)
-> AGAINST ('test' IN BOOLEAN MODE);


Does anybody know if this (my)sql-statement is working with other
db-servers respectively is standard compliant?
If not - how does the standard compliant syntax look like?

thx
chris