I exported the results of a query I ran from the data grid. My system is rejecting the data saying that the data is coming in as UTF8 with BOM. I need the data to be UTF8 without BOM. I was not able to find a way to determine how the file was saved (with or without BOM) in SQL Navigator. Is there a way to save without BOM?
Use a third party application, such as Notepad++ or UltraEdit, to view the encoding of a file. You can also use such applications to convert the encoding of the file exported by SQL Navigator, from UCS2 to UTF8 without BOM.
Waiting for enhancment to be included in a future version of SQL Navigator.
Currently, in SQL Navigator, when the Unicode option is checked, the data will be saved to the file in UCS2 encoding with BOM. Clicking Unicode doesn't make the output UTF8, but UCS2. There is no way to save without BOM in SQL Navigator, unless Unicode option is unchecked.