will unicode includes extra space in the sql load

kirankota79 · Post by **kirankota79** » 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?

ray.wurlod · Post by **ray.wurlod** » Tue Jul 22, 2008 3:11 pm

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.)