Forum Stats

  • 3,759,518 Users
  • 2,251,557 Discussions
  • 7,870,690 Comments

Discussions

Oracle NVARCHAR2 only allows 2000 max

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

Best Answer

  • Solomon Yakobson
    Solomon Yakobson Member Posts: 18,747 Red Diamond
    edited Sep 26, 2021 6:25PM Accepted 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: 18,747 Red Diamond
    edited Sep 26, 2021 6:25PM Accepted 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.