Print Thread
Page 1 of 2 1 2
Saving UTF-8 encoded files?
#30099 05/29/08 11:57 AM
Joined: Mar 2008
Posts: 29
Oslo, Norway
S
Stian Offline OP
Member
OP Offline
Member
S
Joined: Mar 2008
Posts: 29
Oslo, Norway
Hi,

Is is possible to save files at UTF-8 by default in PLSQL Developer? In my current project this is important. Now I have to convert all files I edit in PLSQL Developer to UTF-8 manually.

PLSQL Developer can read UTF-8 with BOM, when edited and saved they are converted to ANSI.

PLSQL Developer doesn't understand UTF-8 files without BOM and multibyte characters show as two characters. UTF-8 wo/BOM is getting more common as it is used as default UTF-8 encoding in Unix/Linux.

The possibility to reade UTF-8 without BOM and save as UTF-8 by default would be a nice feature to have.

Regards
Stian H. Larssen


Regards
Stian
Re: Saving UTF-8 encoded files?
#30100 05/29/08 02:10 PM
Joined: Aug 1999
Posts: 22,239
Member
Offline
Member
Joined: Aug 1999
Posts: 22,239
I have added this to the list of enhancement requests. At the moment PL/SQL Developer will only add a BOM if the file contains Unicode characters beyond the ansi character set.


Marco Kalter
Allround Automations
Re: Saving UTF-8 encoded files?
Marco Kalter #35822 10/01/09 11:15 AM
Joined: Mar 2008
Posts: 29
Oslo, Norway
S
Stian Offline OP
Member
OP Offline
Member
S
Joined: Mar 2008
Posts: 29
Oslo, Norway
Seems this did not make it in 8.0.

It would be very nice for PLSQL Developer to detect UTF-8 without BOM and a setting in properties to save files in whatever character set you want.

My work would be simpler if all files I saved are in UTF8 without BOM.

Stian


Regards
Stian
Re: Saving UTF-8 encoded files?
Marco Kalter #36188 10/21/09 03:00 PM
Joined: Oct 2009
Posts: 3
Santiago, Chile
P
Member
Offline
Member
P
Joined: Oct 2009
Posts: 3
Santiago, Chile
[quote=Marco Kalter]I have added this to the list of enhancement requests. At the moment PL/SQL Developer will only add a BOM if the file contains Unicode characters beyond the ansi character set. [/quote]

We are currently evaluating PL/SQL Developer since we need an official tool for this language, but we hit a mayor problem in this area. Currently our automated deploy works in Linux/Java and expects all of our code to be UTF-8 without BOM since there is a problem with this language reading files with BOM (http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=4508058). Is there any chance that in the near future there could be a feature where one could stablish the encoding of the source files generated by PL/SQL Developer? can it be done now? how?

Regards

Re: Saving UTF-8 encoded files?
Patricio T #36201 10/22/09 11:36 AM
Joined: Aug 1999
Posts: 22,239
Member
Offline
Member
Joined: Aug 1999
Posts: 22,239
At the moment there is no option to omit the BOM if there are Unicode characters. You would have to preprocess the files before passing them to your deployment tools. The preprocessor can be a very simple program.


Marco Kalter
Allround Automations
Re: Saving UTF-8 encoded files?
Marco Kalter #38605 08/20/10 07:56 AM
Joined: Mar 2008
Posts: 29
Oslo, Norway
S
Stian Offline OP
Member
OP Offline
Member
S
Joined: Mar 2008
Posts: 29
Oslo, Norway
Hi,

We tried to implement an auto-conversion in subversion but this was post-processing. But very quickly ran into problems with other files we could not convert.

In a large project with mixed platforms, environments and lots of developers it's a nightmare to enforce this after the files are created.

It should be a simple option to force all files to be stored in UTF-8 without BOM.


Regards
Stian
Re: Saving UTF-8 encoded files?
Stian #38608 08/20/10 09:12 AM
Joined: Aug 1999
Posts: 22,239
Member
Offline
Member
Joined: Aug 1999
Posts: 22,239
This is on the list of enhancement requests.


Marco Kalter
Allround Automations
Re: Saving UTF-8 encoded files?
Marco Kalter #38735 09/13/10 09:14 PM
Joined: Oct 2009
Posts: 3
Santiago, Chile
P
Member
Offline
Member
P
Joined: Oct 2009
Posts: 3
Santiago, Chile
How long can it take before a feature request hit's the official version?

Re: Saving UTF-8 encoded files?
Patricio T #38738 09/14/10 09:33 AM
Joined: Aug 1999
Posts: 22,239
Member
Offline
Member
Joined: Aug 1999
Posts: 22,239
It will be in the next version (9.0).


Marco Kalter
Allround Automations
Re: Saving UTF-8 encoded files?
Marco Kalter #38987 11/03/10 08:15 PM
Joined: Oct 2009
Posts: 3
Santiago, Chile
P
Member
Offline
Member
P
Joined: Oct 2009
Posts: 3
Santiago, Chile
Thanks for the info... i guess that 9.0 could be out next year? any chance of a specific date?

Page 1 of 2 1 2

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.035s Queries: 16 (0.010s) Memory: 2.5612 MB (Peak: 3.0416 MB) Data Comp: Off Server Time: 2024-06-26 06:10:21 UTC
Valid HTML 5 and Valid CSS