We have configured PL/SQL Developer (11.0.3.1770) to always use UTF8. This doesn't seem to work as expected..
The following file has 3 special norwegian characters:
When I save this and check the bytes of the file, the 3 special characters are represented by the byte values E6, F8, E5.
These match the byte codes of our local ISO-8859-1 character set. However, since they are non ASCII characters they should have been encoded in an UTF8 file.
Now, if I add some exotic character, like a theta, θ and save, both it and the Norwegian characters are suddenly saved as UTF8:
C3 A6, C3 B8, C3 A5, CE 98
If I delete the theta and save again, the Norwegian characters are back to their single-byte values.
The following file has 3 special norwegian characters:
SQL:
create or replace package test
æøå
endWhen I save this and check the bytes of the file, the 3 special characters are represented by the byte values E6, F8, E5.
These match the byte codes of our local ISO-8859-1 character set. However, since they are non ASCII characters they should have been encoded in an UTF8 file.
Now, if I add some exotic character, like a theta, θ and save, both it and the Norwegian characters are suddenly saved as UTF8:
C3 A6, C3 B8, C3 A5, CE 98
If I delete the theta and save again, the Norwegian characters are back to their single-byte values.
