Remove Accented Characters from a string

[Former Member]

Is there a simple way to remove accented characters from a string?

For example àéêöhello! needs to be converted to aeeohello!

In SQL server I would use Collate to accomplish this in one line. However, I am not able to find a solution that is working other than using multiple replace statements or something of the sort.

This is in a database where multiple languages are used and stored. I need to convert Portuguese to English when the data is being exported, but don't have the budget for a translator.

Your help is appreciated.

[VolkerBarth]

Just a very wild guess:

AFAIK collation tailoring is based on the ICU library used within SQL Anywhere (dbicu.dll).

As ICU does also allow to transform data (including decomposition of characters), you might be able to make use of the ICU library yourself. That may be more reliable than a home-brewn list of "special characters to convert".