Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2009
    Posts
    5

    Unanswered: Searching for international characters

    Does anyone know if there is a way to consider international characters as english characters when searching. For example, my database will contain European names containing charaters such as ů and . I would like to be able to search for "u" and for the results to find all three of these characters.

    Is there an option or setting that can enable this or maybe a way of doing it with stored procedures etc or will I need to achieve this through php in my app.

    Any help/advice with this issue would be greatly appreciated.

    Many thanks,

    Tony

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    not too sure how you would express that in SQL short of an "IN" sub clause or multiple OR sub clause

    another alternative may be to go down thge route of something like a SOUNDEX algolrhythm or possibley double phenome (least aways I think its double phenome.. its double something, somehtign that Izzy Rider on the Access forums uses with success for French/German/Swiss names
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by topcatxx View Post
    Any help/advice with this issue would be greatly appreciated.
    why not run a few tests?
    Code:
    CREATE TABLE t57
    ( foo VARCHAR(99)
    );
    INSERT INTO t57 VALUES
     ( 'voila' ), ( 'vwalah' ), ( 'voilà' )
    ;
    SELECT 'test1', foo FROM t57 WHERE foo LIKE '%a%'
    UNION ALL
    SELECT 'test2', foo FROM t57 WHERE foo LIKE BINARY '%a%'
    ;
    lemme know what you gots from that

    for more information, see http://dev.mysql.com/doc/refman/5.0/...nsitivity.html

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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