MySQL中的全文索引用于中文本字段？
是否有可能在 oracle 中的中文本字段上添加工作全文索引？我已经能够建立索引，但查询时没有得到任何结果。可能是我的sql有缺陷：（ps。我绝对确定“someText”部分在数据库中）。
SELECT *
FROM Products
WHERE CONTAINS (ProductDescription, 'someText' );
我也尝试过：
SELECT *
FROM Products
WHERE CONTAINS (ProductDescription, 'someText' )>0;
但没有结果。
奇怪的是，查询没有返回错误，它只是不返回结果。可能是我的索引创建不正确，但在“phpMyAdmin”中它被列为我的表的索引之一。有什么想法吗？
Is it at all possible to add a working fulltext index on a mediumtext field in oracle? I have been able to make an index, but I do not get any results when I query it. It might be that my sql is flawed: (ps. I am absolutely sure that the 'someText' part is in the DB).
SELECT *
FROM Products
WHERE CONTAINS (ProductDescription, 'someText' );
I also tried with:
SELECT *
FROM Products
WHERE CONTAINS (ProductDescription, 'someText' )>0;
But no results.
The strange thing is that the query returns no error, it simply does not return results. It might be that my index is inproperly created, but in "phpMyAdmin" it is listed as one of the indexes for my table. Any ideas?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
您是如何建立索引的？
具体来说，您是否将索引更改同步到表更改 提交时
How have you built your index ?
Specifically, are you syncing the index changes to the table changes ON COMMIT