[core] Shrink char field max length

This fixes Oracle issues with the default charset: AL16UTF16.
Max byte length of NVARCHAR2 type is 4000. 2047 characters
would consume 4094 bytes of space. We should support
up to 4 byte charsets. So bringing the length of these fields
down to 1000 => 4000 maximum bytes consumed.