Correctly display encoded carriage return and newline in procedure editor
When editing a stored procedure, function, or trigger, statements that contain an escaped carriage return (\r) or newline (\n) are not displayed correctly in the editor. That is, they are incorrectly displayed as an actual carriage return or newline. To replicate, create a stored procedure with the line: IF LOCATE('\r', field) > 0 THEN ...
Save the the procedure and then open it again in the editor.
3
votes
Eric Rasmussen
shared this idea
