September 5th, 2013, 03:54 PM
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?
September 9th, 2013, 04:31 AM
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.