Skip to Content
0
Former Member
Jun 11, 2018 at 10:32 AM

replace germand Umlaute fails

72 Views Last edit Jun 11, 2018 at 10:00 AM 5 rev

Hello,

I have to replace the german Umlaute ä,ö,ü and ß with & auml (without the space after &),...

The following statement also replaces a, o, u and s.

select replace(replace(replace(replace('TestaTestä','ß','& szlig'),'ü','& uml'),'ö','& ouml'),'ä','& auml'),'TestaTestä' (without the spaces afther the &)

The result is:

Te& szligt& aumlTe& szligt& auml;TestaTestä (without the spaces after the &)

DBinfo:

CHAR-Collation sequence: 1252LATIN1(CaseSensitivity=Ignore)
CHAR-Zeichensatzkodierung: windows-1252
NCHAR-Collation sequence: UCA(CaseSensivity=Ignore;ACCentSensitivity=Ignore;PunctuationSensitivity=Primary
NCHAR-Zeichenkodierung: UTF-8

It also makes no difference between O,o and Ö,ö.

So If I replace an Ö with & Ouml, all ö are also replaced with & Ouml (without spaces afer the &).

Is there any option I can set temporary for my query?

Best regards

Markus