Author: Bertrand Mercier
Email: [EMAIL PROTECTED]
Message:
I'm trying to do accentuated search, in french, with proper charset used (ISO-8859-1).
My db is CRC-MULTI.
When I try "Journ�e Mondiale", the searchengine gives me 4 results;
When I try "Journee Mondiale", the searchengine gives me 0 result;
I don't know why : My MSSQL Server 7 has a case insensitive and accent insensitive
dictionnary.
And if I make an simple SQL statement, it works fine. eg:
SELECT * FROM url WHERE txt LIKE '%Journee Mondiale%'
or
SELECT * FROM url WHERE txt LIKE '%Journ�e Mondiale%'
I receive 4 results for each, so no problems.
Are you making a special query ? wich take accents in consideration forcing my SQL
server to be accent sensitive ? is there an option to disable it ?
Thanks in advance
Bertrand.
Reply: <http://www.mnogosearch.org/board/message.php?id=2843>
___________________________________________
If you want to unsubscribe send "unsubscribe general"
to [EMAIL PROTECTED]
