开发项目过程中,有用到PLSQL发邮件功能,邮件内容是一个字符串,包含换行符CHR(10) ,比如 'ABC' || CHR(10) || 'XYZ' 用OUTLOOK接收邮件的时候,应该显示换行,但却没换行,而且提示 "Extra line breaks in this message were removed"
一. 修改代码:则可在字符串拼接的时候,在CHR(10)之前加一个点"." ,这样换行也可以起作用, 例如:'ABC' || '.' || CHR(10) || 'XYZ'
二. 可通过更改设置使其换行:
Cause: By default, theAuto Remove Line Breaks feature in Outlook is enabled. This causes the line breaks to be removed. Any two or more successive line breaks are not removed.
Method 1. Disable the feature that removes extra line breaks
This method disables the feature for all plain text items. To do this, follow these steps:
For Outlook 2010:
1. Open Outlook.
2. On theFile tab, click Options.
3. In theOptions dialog, click Mail.
4. In theMessage format section, clear the Remove extra line breaks in plain text messagescheck box.
5. Click OK.
For Outlook 2007 or earlier versions:
1. Open Outlook.
2. On theTools menu, click Options.
3. On thePreferences tab, click the E-mail Options button.
4. Click to clear theRemove extra line breaks in plain text messages check box.
5. Click OK two times
可参考http://support.microsoft.com/kb/287816 或者http://support.microsoft.com/kb/287816/zh-cn