saving files in UTF8

[agathis]

is it possible to force plsqldev to save files in UTF8 instead of local ANSI encoding?

it causes a lot of problems for us and I didn't find any settings responsible for that.

I even found an old topic where it was promised:https://forums.allroundautomations.com/ubb/ubbthreads.php?ubb=showflat&Number=36201

I use 9.0.4.1644 version.

Thanks!

 

[Marco Kalter]

Yes, you can go to Tools > Preferences > Files / Format and set the "Encoding" option to "Always UTF8".

 

[jammerhammer]

I have been using UTF8 encoding successfully with PL/SQL Developer. Nevertheless, when i want to run a UTF8-encoded script in SQL*Plus, it complains because of the byte-order-mark (BOM) at the beginning of the file. The same happens with Oracle's SQL Developer. These tools do understand UTF8 WITHOUT BOM...

Would it be possible to add a checkbox "Without BOM" at the Encoding Preference? That would be really helpful.

 

[taka]

I want checkbox "Without BOM" at the Save Dialog not only Encoding Preference.

It's vary useful in Japanese too.

 

[Stian]

This has been requested or discussed previously as well.

This is still an issue in 10 beta 9. Several times I have committed code which fails when deployed to a Linux environment because of this. I have to manually convert all files.

This should really be a simple issue if not an development language limitation.

Marco, can you implement a "no BOM" save file feature for UTF8?

BOM:http://en.wikipedia.org/wiki/Byte_order_mark

Regards
Stian

 

[Marco Kalter]

I think we can still extend the file format preference for 10.0.0.

 

[Stian]

This would be awesome!

 

[Aleksandr Zaboti]

Hi!
Now I have 10.0.3.1701 version. But I can't found "no BOM" save file feature. I realy need for this. Help me please.

 

[Marco Kalter]

You can go to Tools > Preferences > Files / Format and set the "Encoding" option to "Always ANSI".

 

[Aleksandr Zaboti]

Marco, in this way file was not been UTF8. How I can save file in UTF8 without BOM?

 

[Marco Kalter]

That is not possible. UTF8 requires a BOM.

 

[Aleksandr Zaboti]

I am surprised. UTF8 permit the BOM. But do not required them.http://www.unicode.org/faq/utf_bom.html#bom5

File in UTF8 with BOM raise error in our system

 

[Marco Kalter]

I have added an option for this to the list of enhancement requests.