Full Text Search

zhaozj2021-02-16  56

SQL> SELECT file_path from url_search where contacts (file_path, ')> 0; my application and database have the following characteristics 1. My Doc document is added through Delphi's olecontainer, so it is not a simple DOC document. 2. I added a head of a character set of the database is 16GBK OLE problem is solved by looking ctxsys.ctx_parameters found the default_filter_file and default_filter_binary are inso_filter, so to modify execute ctxsys.ctx_adm ( 'default_filter_file', ' null_filter '); execute ctxsys.ctx_adm (' default_filter_binary ',' null_filter '); select the language parser execute ctxsys.ctx_ddl.create_preference (' mylexer ',' chinese_vgram_lexer '); create index create index myindex on testtable (column2) indextype is Ctxsys.context parameters ('lexer mylexer filter ctxsys.inso_filter');

- Note Select the appropriate Lexer and INSO_FILTER. that's it

==================

Full text search problem

转载请注明原文地址:https://www.9cbs.com/read-18624.html

New Post(0)