Is there a reason that strrep won't replace a ü character (chr252)

APP_REMARKS_TEXT is an oracle CLOB field with the value:
Worked with this student on a tour. Strange situation, she was aüstudent in 1980's but no records show. Wants to return and work on aüdifferent degree. Advised her to check with the registrar to getüreinstalled in our system and with testing to see if tests she took inü1997 are still valid. Explained registration process and FAFSA%

running the following (in a define)

-* this line changes type from CLOB to AN
C1/A1000 = APP_REMARKS_TEXT;
-* this line should replace 'goofy' characters with a space
COMMENTS/A1000 = STRREP(1000, C1, 1, 'ü', 1, ' ', 1000, COMMENTS);

does absolutely nothing

This message has been edited. Last edited by: Kerry,

Common problem with special chars. Try using HEXBYT(252, 'A1') instead -

STRREP(1000, C1, 1, HEXBYT(252, 'A1'), 1, ' ', 1000, COMMENTS)

DEFINE FILE CAR
TEXT/A1000 WITH COUNTRY = 'Worked with this student on a tour. Strange situation, she was aüstudent'
                       || ' in 1980''s but no records show. Wants to return and work on aüdifferent'
		     || ' degree. Advised her to check with the registrar to getüreinstalled in our'
                       || ' system and with testing to see if tests she took inü1997 are still valid.'
                       || ' Explained registration process and FAFSA%';
NEWTEXT/A1000 WITH COUNTRY = STRREP(1000, TEXT, 1, HEXBYT(252, 'A1'), 1, ' ', 1000, 'A1000');
END
TABLE FILE CAR
PRINT NEWTEXT
   BY COUNTRY NOPRINT
IF RECORDLIMIT EQ 1
END

T

This message has been edited. Last edited by: Tony A,