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