The ATTRBUFSIZE parameter does not account for native Unicode support; reduces allotted characters for creation of a table by half

Description

By default, initialization parameter ATTRBUFSIZE is allotted 50,000 bytes for creation of a table definition. If using ASCII characters, one byte is equivalent to one character. However, Unicode characters use 2 to 4 bytes per character, which affects how many characters 50,000 bytes will store. If the geodatabase is using Unicode character storage, the default ATTRBUFSIZE value may not be sufficient.

Cause

ArcSDE has not always supported Unicode characters by default. Since this support was instituted, the check against character columns has not been changed to take into account that this parameter's value needs to be doubled in the server_config table to accommodate the allotted number of bytes for table definition creation.

Solution or Workaround

sdeconfig -o alter -v ATTRBUFSIZE=100000 -i 5151 -s dev_server1 -D Rhino -u sde -p sdepassword