Topics

03 Troubleshooting
Client, Server
Full-text search: logical operations with DBCS

Beginning in R5.0.6, the search string 'AandB' searches exactly the string of 'AandB' whereas 'A and B' searches a document which contains both A and B. If you enter 'AandB' and one of the documents contains 'AandB', that document will be found. In R5.0.5 or earlier versions, this does not work when A or/and B are in DBCS.

If you use the '&' operator instead of 'and', you don't have to put spaces between the operator and the strings to search. In other words, you can use 'A&B' to find a document which contains both A and B. This is because '&' can be distinguished from the search string without adding spaces. If you want to search 'A&B' explicitly, you can quote the string with quotation marks, like '"A&B"'.