Forum Stats

  • 3,838,817 Users
  • 2,262,400 Discussions
  • 7,900,761 Comments

Discussions

Oracle NVARCHAR2 only allows 2000 max

GeorgeZhouzhiqing
GeorgeZhouzhiqing Member Posts: 83 Blue Ribbon
edited Sep 26, 2021 6:30PM in Java Programming

Best Answer

  • Solomon Yakobson
    Solomon Yakobson Member Posts: 19,605 Red Diamond
    edited Sep 26, 2021 6:25PM Answer ✓

    4000 is bytes. If you check parameter NLS_NCHAR_CHARACTERSET you will most likely see AL16UTF16 which means one character occupies 2 bytes. Therefore "the length specified was > 2000" chjaracters.

    SY.

Answers

  • Solomon Yakobson
    Solomon Yakobson Member Posts: 19,605 Red Diamond
    edited Sep 26, 2021 6:25PM Answer ✓

    4000 is bytes. If you check parameter NLS_NCHAR_CHARACTERSET you will most likely see AL16UTF16 which means one character occupies 2 bytes. Therefore "the length specified was > 2000" chjaracters.

    SY.