MySQL Forums
Forum List  »  Full-Text Search

Re: Oracle 8i to mySQL full text search issues.
Posted by: Nick Roper
Date: July 23, 2004 02:58PM

'... and add that document to its library....'

Do you mean that it will retrieve the text of the document and store it in a column in the database?

You can create fulltext indexes on single or multiple columns in a MySQL table. The columns would need to be a text type - i.e. text, mediumtext or longtext. Blob wouldn't work 'cos it's a binary type.There could be a way of getting the text from a URL into the column with PHP for example - or maybe with some other middle-tier language.

--
Nick Roper

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Oracle 8i to mySQL full text search issues.
3927
July 23, 2004 02:58PM
4159
September 08, 2004 05:46AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.