#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2013
    Posts
    1
    Rep Power
    0

    Question Function to remove accents in the query


    I'm getting a mass of data, and want to remove the stress of some columns. Is there a ready function in firebird, do this for me?
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2013
    Posts
    8
    Rep Power
    0
    I am really not expert in Firebird so i hope somebody will answer you.

    But why delete the accents?

    IN CASE YOU HAVE PROBLEM WITH NON-ASCII TEXT
    Recently the UTF8 encoding is read/written fine... If possible, it's always better to don't loose informations as the original data (that, in yur case, included accents). Maybe ensure that the problems with accents are not due to the program who read the info from DB, in that case try to correct the program, not the data.

    BTW. i image that you may have special needs, in that case just forget my answer.

IMN logo majestic logo threadwatch logo seochat tools logo