I am trying to replace German and Dutch umlauts such as `ä`, `ü`, or `ß`. They should be written like `ae` instead of `ä`. So I can't simply translate one char with another. 

Is there a more elegant way to do that? Actually it looks like that (not completed yet):

```
SELECT addr, REPLACE (REPLACE(addr, 'Ã¼','ue'),'ß','ss') FROM search;

```

On my way trying different commands I got another problem:

When I searched for `Ü` I got this:

> 
> ERROR: invalid byte sequence for encoding "UTF8": 0xdc27
> 
> 
> 

Tried it with `U&'\0220'`, it didn't replace anything. Only by using `Ã¼` (for lowercase `ü`) it was replaced correctly. Has to do something with unicode, but how to solve this issue?

Kind regards from Germany. :)