Opening and then executing a script file encoded with UTF-8 BOM gives an error

[antonwierenga]

I am using OSX 10.12.6, DBeaver 4.2.2. Attached the script file.

test.zip

[nitram509]

Hi,

I've investigated a bit regarding this topic.
It seems to me, the root cause of this issue is kind of known ;-)
See https://www.eclipse.org/forums/index.php/t/157485/
And https://bugs.eclipse.org/bugs/show_bug.cgi?id=160614

My proposal is to follow advice and use the extension point org.eclipse.core.contenttype.contentTypes and make org.eclipse.core.runtime.text as base-type for 'sql' extensions. This should do the job.

[antonwierenga]

Thanks, that seems to work. Shouldn't this be the default extension point for sql files in DBeaver?

[serge-rider]

@nitram509 thanks for the link.
Sql extension was already bound to org.eclipse.core.runtime.text but SQL content type describer was badly formed. Now fixed - BOM files are opening just fine.
See fix in 4.2.3.