I-Microsoft SQL Server isekela iintlobo ezisixhenxe zeedatha. Kule miqolo, ibhondi yebhanari ivumela idatha edibeneyo emele njengezinto ezibini.
Iintlobo zeenkcukacha kwi-binary-strings category ziquka:
- iitshintshi ezincinci zigcina enye enye ngexabiso le-0, 1 okanye i- NULL .
- bhinari (n) iindatshana zokugcina i-bytes zedata ebhaliweyo yedatha yodatha. Ezi nkalo zinokugcina ubuninzi beeti eziyi-8,000.
- i-varbinary (n) iindatshana zokugcina i-data binary length-length data malunga ne-bytes. Baya kugcina i-bytes ezili-8,000.
- i-varbinary (max) eziguquguqukayo zesitoreji sedatha ebhaliweyo yedatha yee-bytes. Basenokugcina ubuninzi be-2 GB kwaye ngokuqinisekileyo bagcine ubude beedatha kunye neetshi ezimbini ezongezelelweyo.
- imifanekiso eguqukileyo igcina kwi-2 GB yedatha kwaye isetyenziswa ngokutsha ukugcina nayiphi na ifayile yefayile (kungekhona imifanekiso).
Uhlobo lomfanekiso luhlelelwe ukunyanzelwa ekukhutshweni kweSQL Server ngokuzayo. Iinjineli zeMicrosoft zincoma ukusebenzisa i- varbinary (max) endaweni yesimo semifanekiso yokuphuhliswa kwexesha elizayo.
Usetyenziso olufanelekileyo
Sebenzisa amakholomu amancinci xa ufuna ukugcina i-ewe-okanye-akukho-ntlobo yeenkcukacha ezimelelwe yi-zero kunye nazo. Sebenzisa iikholomu zobuncinane xa ubukhulu beentsika zifana. Sebenzisa iikholomu ze- varbinary xa ubukhulu bekholomu kulindeleke ukuba budlulele kwi-8K okanye bube nokuxhomekeka okubonakalayo kwisayizi nganye irekodi.
Ukuguqulwa
I-T-SQL-ukuhluka kweSQL esetyenziswe kwi- Microsoft SQL Server- right-pads data xa uguqula kuyo nayiphi na uhlobo lomtya kwi- binary or varbinary type. Naluphina uhlobo oluthile lokuguqulwa kwihlobo lomnxeba luvelisa i-pad-pad. Olu phawu lwenziwa ngokusetyenziswa kweeeroxadecimal zeroes.
Ngenxa yolu tshintsho kunye nomngcipheko we-truncation, ukuba insimu yokuguqulwa kwesithuba ayinkulu ngokwaneleyo, kungenzeka ukuba amasimu aguqulelwe angabangela iziphene ze-arithmetic ngaphandle kokuphosa umyalezo wephutha.