5 Replies Latest reply: Dec 29, 2013 8:29 PM by SandraZhou-Oracle RSS

    4.0.0.13.80 - varchar column default value error

    svi0105
      CREATE TABLE ZZ_TEST(TXT VARCHAR2(2 BYTE) DEFAULT '0' );

      Then, edit table properties (columns group) and get error:

      Value '0' cannot be encoded in character set CL8MSWIN1251

       

      If delete quotes in "Default" column, error is disappear, but after saving we see wrong DDL:

      CREATE TABLE "ZZ_TEST" ( "TXT" VARCHAR2(2 BYTE) DEFAULT 0 )

       

      sqldeveloper 3.2 works fine with exactly sаme NLS settings:

       

      nls_languageAMERICAN
      nls_territoryAMERICA
      nls_sort
      nls_date_language
      nls_date_formatDD.MM.YYYY hh24:mi:ss
      nls_currency
      nls_numeric_characters
      nls_iso_currency
      nls_calendar
      nls_time_format
      nls_timestamp_formatDD.MM.YYYY HH24:MI:SSXFF
      nls_time_tz_format
      nls_timestamp_tz_formatDD.MM.YYYY HH24:MI:SSXFF TZR
      nls_dual_currency
      nls_compBINARY
      nls_length_semanticsBYTE
      nls_nchar_conv_excpFALSE