will unicode includes extra space in the sql load
Posted: Tue Jul 22, 2008 8:26 am
I am doing an oracle load with sql loader. For a column i am using unicode? will it introduce an extra space in the table? please let me know?
Compared to what? Strict Unicode uses two bytes of storage per character. Other encodings, such as UTF-8, use one, two, three or four bytes of storage per character. Single-byte character sets, as the name suggests, use one byte of storage per character.
(There is also a variant of Unicode that use four bytes of storage per character. This is not in common use.)