Results 1 to 1 of 1
  1. #1
    Join Date
    Jul 2004
    Posts
    1

    Question Unanswered: Mysql Fulltext Search & Ascii-Characters

    Hi there,

    In the mysql-database, all special characters like the german "Umlaute" (Ä,Ö,Ü,ä,ö,ü) are saved as ascii-characters. e.g. the word "realität" is saved as "realit@#228;t".

    Now, when I'm searching for the word "realität", the search is showing too many results. The search seems to do wrong with every word containing such an ascii-character. It even finds matches for a word like "kfdädfkdfgh" which doesn't exist in the database at all.


    I'm using the mysql-fulltext search for a query and mysql-statements like the following:

    SELECT match(cell.content) against ('realit@#228t')
    FROM cell_2 as cell
    WHERE (match(cell.content) against ('realit@#228t');

    Can somebody help me please?

    Greets,
    Timo
    Last edited by HomerSimpson79; 07-09-04 at 10:00. Reason: I replaced the & with an @ because this forum converts the ascii-characters inte the normal letters. Just imagine, that every @ is an &.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •