Print Thread
BOM
#56166 03/20/17 02:19 PM
Joined: Sep 2003
Posts: 387
London, UK
Member
OP Offline
Member
Joined: Sep 2003
Posts: 387
London, UK
Whenever I edit a particular file, a BOM (hex sequence EF BB BF) appears at the start of the first line. This is invisible and ignored by PL/SQL Developer, but it breaks the script in SQL*Plus which we use for automated deployment. I have to remove it using a separate text editor prior to checkin.

It turns out that the file contains some multibyte characters in a comment (they appear to be MS Word smartquotes). Removing these stops the BOM appearing.

Are there any settings I am missing to control this behaviour? Unchecking "Unicode enabled" in Preferences > Options had no effect.

PL/SQL Developer version 11.0.2.1766

Re: BOM
William Robertson #56172 03/21/17 10:18 AM
Joined: Aug 1999
Posts: 22,232
Member
Offline
Member
Joined: Aug 1999
Posts: 22,232
You can go to Tools > Preferences > File / Format and disable the "Save with BOM" option.

Normally the BOM is added to a source file if it contains characters that are not covered by the Windows system character set and therefore require Unicode encoding.


Marco Kalter
Allround Automations
Re: BOM
Marco Kalter #56184 03/22/17 06:27 PM
Joined: Sep 2003
Posts: 387
London, UK
Member
OP Offline
Member
Joined: Sep 2003
Posts: 387
London, UK
Great, thanks.


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.052s Queries: 14 (0.031s) Memory: 2.5024 MB (Peak: 3.0394 MB) Data Comp: Off Server Time: 2024-06-17 08:46:45 UTC
Valid HTML 5 and Valid CSS