Microsoft SQL Server inotsigira zvinomwe zvakasiyana-siyana zve data. Pakati idzi, tsvimbo dzebhanari dzinobvumira dodhe yakadhindwa inomiririrwa sezvinhu zvinowanikwa.
Dhiyabhorosi mavara mumabhanari-tsvimbo chikamu anosanganisira:
- bit variables store imwe chete ine nhamba ye 0, 1 kana NULL .
- bhanari (n) zvinyorwa zvigadzirwa n bytes ye data-fixed binary data. Iyi minda inogona kuchengetedza huwandu hwe8,000 byte.
- varbinary (n) mhando dzakasiyana-siyana shanduko-bhari data yakadzama yenhara n bytes. Vanogona kuchengetedza huwandu hwe8,000 bytes.
- varbinary (max) variable store variable-length binary data yeavo n bytes. Vanogona kuchengetedza zvakakwana 2 GB uye chaizvoizvo vanochengetedza urefu hwe data pamwe nekuwedzera mamwe maviri.
- mifananidzo inoshandiswa inochengetedza kusvika 2 GB ye data uye inowanzoshandiswa kuchengetedza chero rudzi rwe data data (kwete mifananidzo chete).
Chimiro chemufananidzo chagadzirirwa kushandiswa mune kusunungurwa kweSQL Server munguva yemberi. Vanjiniya veMicrosoft vanokurudzira kushandisa varbinary (max) panzvimbo yezvifananidzo zvekuvandudzwa kwemuzouya .
Zvakakodzera Kushandisa
Shandisa zvinyorwa zvishoma apo iwe unoda kuchengeta hongu-kana-kwete mhando dze data dzinomiririrwa ne zero uye izvo. Shandisa zvinyorwa zvebhanana kana uwandu hwemashongwe hwakafanana. Shandisa varbinary columns apo huwandu hwemukamuri huri kutarisirwa kudarika 8K kana hungave huri pasi pekukosha kukuru kwehuwandu nehutori.
Kutendeuka
T-SQL-iyo yakasiyana-siyana yeSQL inoshandiswa muDynamic SQL Server -right-pads data paunotendeuka kubva pane chero tambo yakagadzirwa kune bhanary kana varbinary type. Chero hupi hupi hutende hutendeuka kune imwe bhenari inobereka kuruboshwe-pad. Iyi padding inoshandiswa kuburikidza nekushandiswa kwe zeroes hexadecimal.
Nokuda kweizvi kutendeuka uye ngozi ye truncation, kana mushure mokushandura munda hauna kukwana, zvinogona kuti mashandu akachinjwa anogona kukanganisa zvikanganiso zvemasvomhu pasina kukanda mhosho.