will unicode includes extra space in the sql load
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 315
- Joined: Tue Oct 31, 2006 3:38 pm
will unicode includes extra space in the sql load
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?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.)
(There is also a variant of Unicode that use four bytes of storage per character. This is not in common use.)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.