Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2008
    Posts
    49

    Unanswered: Convert accented characters into non-accented

    Regarding on Stored Procedure of MS SQL.

    How can I convert accented characters to non-accented character?

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Replace command perhaps?
    Code:
    SELECT Replace('naïveté', 'é', 'e')
    SELECT Replace(Replace('naïveté', 'é', 'e'), 'ï', 'i')
    Word choice courtesy of Rudy
    George
    Home | Blog

  3. #3
    Join Date
    Jun 2008
    Posts
    49
    What if their are lots of them...?

Posting Permissions

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