Forum Stats

  • 3,768,266 Users
  • 2,252,770 Discussions
  • 7,874,511 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,908 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,908 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.