Re: Case sensitivity
Z F <[email protected]>
| Newsgroups | gmane.text.refdb.general |
|---|---|
| Message-ID | <[email protected]> |
Hello Markus, > RefDB relies entirely on the database engine for queries. If the > engine does regexp comparisons in a case-sensitive fashion, then > RefDB > does the same. If you badly need one particular behaviour, you > may get closer by switching to a different engine. Some more > background can be found here: > > http://sourceforge.net/mailarchive/message.php?msg_id=9292940 This is what I thought. MySQL does the right thing when using = and ~ on the text fields. As far as I understood, author name and title are text fields. Am I wrong? If yes, the comparison should work correctly. However, comparisons on the author field work in case-insensitive way, while comparisons on the title field are case sensitive. So this suggests that author field is text, while title field is somethign else. Is there logic behind this? According to documentation both fields are alphanumeric. Thanks for your help Lazar __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642