I have a validation everytime when tryong to modify an existing table :
One of the columns in a CHAR(1), with '0' (zero) as default
When I try to add a new column, whenever I want to validate the changes, I have the following error message (translated it in English, original is in French):
"Column: validation error
The '0' value cannot be encoded in the WE8ISO8859P15 charset"
Is there any workaround for this?
I'm using SQL Developer 184.108.40.206.80
What character set does the database use?
select * from nls_database_parameters where parameter in ('NLS_CHARACTER_SET','NLS_NCHAR_CHARACTERSET')
Does the same problem arise if you use sql*plus (on the same machine where sql dev is located)?
If so you may want to repost the question in the Globalization Support forum.
Since you can modify encoding within the SQL Developer Preferences, your 3.x version of SQl Dev may actually work. In SQL Dev 4, try going to Tools -> Preferences. In the environment section, take a look at Encoding. Try to find one that matches what you database is configured for. There is a UTF16 that might work.
Let me know.
My SQL Dev encoding was set to UTF-8. Setting it to UTF-16 didn't change the problem.
Aboput the DLL, if I right click on the table -> Edit... , I'm habing the error whenever I try to change anything on the table, or just when I'm trying to get the DDL for the table (in the same Edit window)