I-Microsoft SQL Server isekela izigaba eziyisikhombisa zemininingwane ehlukile. Kulezi, izintambo ezidayayo zivumela idatha ekhonjiwe ekhonjiswe njengezinto ezinambambili.
Izinhlobo zedatha kusigaba sokwabelana kanambambili zihlanganisa:
- Izinguquko ezincane zigcina ibanga elilodwa ngenani le-0, 1 noma i- NULL .
- okubhaliwe (n) okuguqulwa kwesitolo n bytes kwedatha kanambambili yesayizi kanambambili. Lezi zinsimu zingagcina ama-bytes angama-8,000.
- i-varbinary (n) okuguquguqukayo kwedatha yokuguquguquka kwedatha kanambambili ye-binary. Bangakwazi ukugcina ama-bytes angaphezu kuka-8,000.
- i-varbinary (max) iziguquli zesitoreji sedatha yedijithali yokuhluka kwedatha okungaba yi-bytes. Bangakwazi ukugcina ubuningi be-2 GB futhi empeleni bagcine ubude bwedatha kanye nama-bytes amabili engeziwe.
- izithombe eziguquguqukayo zigcina kufika ku-2 GB yedatha futhi zivame ukusetshenziswa ukugcina noma yiluphi uhlobo lwefayela lemininingwane (hhayi nje izithombe).
Uhlobo lwesithombe luhlelelwe ukuchithwa ekukhululweni kweSQL Server esikhathini esizayo. Abanjiniyela baseMicrosoft batusa ukusebenzisa i- varbinary (max) esikhundleni sezinhlobo zezithombe zokuthuthukiswa kwesikhathi esizayo.
Ukusetshenziswa Okufanele
Sebenzisa amakholomu amancane uma udinga ukugcina izinombolo ze-e-ye-no-no ezimelelwe yi-zero kanye nazo. Sebenzisa amakholomu abunambambili uma ubukhulu bamakholomu bufana ngokufanayo. Sebenzisa amakholomu we- varbinary uma usayizi wekholomu kulindeleke ukuthi udlule u-8K noma ungase ube ngaphansi kokuhluka okuphawulekayo ngesayizi ngerekhodi ngalinye.
Ukuguqulwa
I-T-SQL-okuhlukile kwe-SQL esetshenzisiwe ku- Microsoft SQL Server -right-pads idatha uma uguqula kusuka kunoma yiluphi uhlobo lwezintambo ohlotsheni olunambambili noma oluthile. Noma yiluphi olunye uhlobo lokuguqulwa kohlobo olubanjwe kanambambili luveza isivinini sesokunxele. Lokhu kukhishwa kwenziwa ngokusetshenziswa kwama-zero hexadecimal.
Ngenxa yalokhu kuguqulwa kanye nobungozi be-truncation, uma insimu yokuguqulwa kokuthutha ayinkulu ngokwanele, kungenzeka ukuthi amasimu aguquliwe angabangela amaphutha we-arithmetic ngaphandle kokulahla umlayezo wephutha.