Eclipse Community Forums: DTP » Open SQL-File ignores BOM

Help

Home

Home » Eclipse Projects » DTP » Open SQL-File ignores BOM

Show: Today's Messages :: Show Polls :: Message Navigator

Open SQL-File ignores BOM [message #631185]

Wed, 06 October 2010 14:03

Tomka Kuje

Messages: 1
Registered: October 2010

Junior Member

Hello,

I have several SQL-Files that are encoded with UTF-16 (LE). The BOM is set correctly.
If I doubleclick one of this files in the Navigator, the SQL-Editor opens and displayes the file corrupted. If I rightclick on the file and select "properties", the encoding is set to "Default (inherited from container: Cp1252)". If I change the encoding manually to UTF-16 the file is displayed fine in SQL-Editor.

If I rename the same files (with the UTF-16-(LE)-BOM) to "x.txt", Eclipse interprets them as textfiles and reads the BOM correctly. The Properties-Dialog displays now "Byte Order Mark is UTF-16 Little-Endian (BOM)".

The files are distributed over several folders of my projects, so setting the file type to UTF-16 manually is no solution.

Is this a Bug in the DTP or the SQL-Editor and I should report a bug or is there any other solution?

Report message to a moderator

Re: Open SQL-File ignores BOM [message #631218 is a reply to message #631185]

Wed, 06 October 2010 15:12

Brian Fitzpatrick

Messages: 500
Registered: July 2009

Senior Member

Hi there...

Please go ahead and report this as a bug against SQL tools for now with
repro steps and a sample SQL file with the troublesome encoding. We'll
see what we can do.

--Fitz

Tomka Kuje wrote:
> Hello,
>
> I have several SQL-Files that are encoded with UTF-16 (LE). The BOM is
> set correctly.
> If I doubleclick one of this files in the Navigator, the SQL-Editor
> opens and displayes the file corrupted. If I rightclick on the file and
> select "properties", the encoding is set to "Default (inherited from
> container: Cp1252)". If I change the encoding manually to UTF-16 the
> file is displayed fine in SQL-Editor.
>
> If I rename the same files (with the UTF-16-(LE)-BOM) to "x.txt",
> Eclipse interprets them as textfiles and reads the BOM correctly. The
> Properties-Dialog displays now "Byte Order Mark is UTF-16 Little-Endian
> (BOM)".
>
> The files are distributed over several folders of my projects, so
> setting the file type to UTF-16 manually is no solution.
>
> Is this a Bug in the DTP or the SQL-Editor and I should report a bug or
> is there any other solution?

Report message to a moderator

Previous Topic:	How change default value in DSE?
Next Topic:	'Can not issue data manipulation statements with executeQuery()' on Execution Plan window

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Sep 23 23:53:22 GMT 2018

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter