varchar(n)
é¿åº¦ä¸º n 个åèçå¯åé¿åº¦ä¸é Unicode çå符æ°æ®ãn å¿
é¡»æ¯ä¸ä¸ªä»äº 1 å 8,000 ä¹é´çæ°å¼ãåå¨å¤§å°ä¸ºè¾å
¥æ°æ®çåèçå®é
é¿åº¦ï¼èä¸æ¯ n 个åèã
nvarchar(n)
å
å« n 个å符çå¯åé¿åº¦ Unicode å符æ°æ®ãn çå¼å¿
é¡»ä»äº 1 ä¸ 4,000 ä¹é´ãåèçåå¨å¤§å°æ¯æè¾å
¥å符个æ°ç两åã
两å段åå«æå段å¼ï¼æåcoffee
é£ä¹varcharå段å 2Ã2+6=10个åèçåå¨ç©ºé´ï¼ènvarcharå段å 8Ã2=16个åèçåå¨ç©ºé´ã
å¦å段å¼åªæ¯è±æå¯éæ©varcharï¼èå段å¼åå¨è¾å¤çååèï¼ä¸æãé©æçï¼å符æ¶ç¨nvarchar
ä¸é¢æ¯ä¸ä¸ªæ»ç»ä»ç»ï¼éè¿ä¸é¢çä»ç»ï¼å¯ä»¥ç¥éã
varchar(4) å¯ä»¥è¾å
¥4个åæ¯ï¼ä¹å¯ä»¥è¾å
¥ä¸¤ä¸ªæ±å
nvarchar(4) å¯ä»¥è¾å个æ±åï¼ä¹å¯ä»¥è¾4个åæ¯ï¼ä½æå¤å个
charãvarcharãncharãnvarcharçåºå«
对äºç¨åºä¸çstringåå段ï¼SQLServerä¸æcharãvarcharãncharãnvarcharåç§ç±»åæ¥å¯¹åºï¼ææ¶ä¸èètextåntextï¼ï¼å¼å»ºç«æ°æ®åºä¸ï¼å¯¹è¿åç§ç±»åå¾å¾æ¯è¾æ¨¡ç³ï¼è¿éåä¸ä¸å¯¹æ¯ã
å®é¿æåé¿
æè°å®é¿å°±æ¯é¿åº¦åºå®çï¼å½è¾å
¥çæ°æ®é¿åº¦æ²¡æè¾¾å°æå®çé¿åº¦æ¶å°èªå¨ä»¥è±æç©ºæ ¼å¨å
¶åé¢å¡«å
ï¼ä½¿é¿åº¦è¾¾å°ç¸åºçé¿åº¦ï¼ævaråç¼çï¼è¡¨ç¤ºæ¯å®é
åå¨ç©ºé´æ¯åé¿çï¼æ¯å¦varchar,nvarcharåé¿å符æ°æ®åä¸ä¼ä»¥ç©ºæ ¼å¡«å
ï¼æ¯è¾ä¾å¤çæ¯ï¼textåå¨çä¹æ¯å¯åé¿ã
UnicodeæéUnicode
æ°æ®åºä¸ï¼è±æå符åªéè¦ä¸ä¸ªåèåå¨å°±è¶³å¤äºï¼ä½æ±ååå
¶ä»ä¼å¤éè±æå符ï¼åéè¦ä¸¤ä¸ªåèåå¨ãå¦æè±æä¸æ±ååæ¶åå¨ï¼ç±äºå ç¨ç©ºé´æ°ä¸åï¼å®¹æé ææ··ä¹±ï¼å¯¼è´è¯»ååºæ¥çå符串æ¯ä¹±ç ãUnicodeå符éå°±æ¯ä¸ºäºè§£å³å符éè¿ç§ä¸å
¼å®¹çé®é¢è产ççï¼å®ææçå符é½ç¨ä¸¤ä¸ªåè表示ï¼å³è±æå符ä¹æ¯ç¨ä¸¤ä¸ªåè表示ãèåç¼n就表示Unicodeå符ï¼æ¯å¦nchar,nvarcharï¼è¿ä¸¤ç§ç±»å使ç¨äºUnicodeå符éã
åºäºä»¥ä¸ä¸¤ç¹æ¥ççå段容é
charï¼varchar æå¤8000个è±æï¼4000个æ±å
ncharï¼nvarchar å¯åå¨4000个å符ï¼æ 论è±æè¿æ¯æ±å
使ç¨(个人å好)
å¦ææ°æ®éé常大ï¼åè½100%ç¡®å®é¿åº¦ä¸ä¿ååªæ¯ansiå符ï¼é£ä¹char
è½ç¡®å®é¿åº¦åä¸ä¸å®æ¯ansiå符æè
ï¼é£ä¹ç¨ncharï¼
对äºè¶
大æ°æ®ï¼å¦æç« å
容ï¼ä½¿ç¨nText
å
¶ä»çéç¨nvarchar
charãvarcharãncharãnvarcharç¹ç¹æ¯è¾
CHAR
CHARåå¨å®é¿æ°æ®å¾æ¹ä¾¿ï¼CHARå段ä¸çç´¢å¼æç级é«ï¼æ¯å¦å®ä¹char(10)ï¼é£ä¹ä¸è®ºä½ åå¨çæ°æ®æ¯å¦è¾¾å°äº10个åèï¼é½è¦å å»10个åèç空é´ã
VARCHAR
åå¨åé¿æ°æ®ï¼ä½åå¨æç没æCHARé«,å¦æä¸ä¸ªå段å¯è½çå¼æ¯ä¸åºå®é¿åº¦çï¼æ们åªç¥éå®ä¸å¯è½è¶
è¿10个å符ï¼æå®å®ä¹ä¸º VARCHAR(10)æ¯æåç®çãVARCHARç±»åçå®é
é¿åº¦æ¯å®çå¼çå®é
é¿åº¦+1ã为ä»ä¹"+1"å¢ï¼è¿ä¸ä¸ªåèç¨äºä¿åå®é
使ç¨äºå¤å¤§çé¿åº¦ã
ä»ç©ºé´ä¸èèï¼ç¨varcharåéï¼ä»æçä¸èèï¼ç¨charåéï¼å
³é®æ¯æ ¹æ®å®é
æ
åµæ¾å°æè¡¡ç¹ã
TEXT
textåå¨å¯åé¿åº¦çéUnicodeæ°æ®ï¼æ大é¿åº¦ä¸º2^31-1(2,147,483,647)个å符ã
NCHARãNVARCHARãNTEXT
è¿ä¸ç§ä»ååä¸çæ¯åé¢ä¸ç§å¤äºä¸ª"N"ãåcharãvarcharæ¯è¾èµ·æ¥ï¼ncharãnvarcharæå¤åå¨4000个å符ï¼ä¸è®ºæ¯è±æè¿æ¯æ±åï¼ècharãvarcharæå¤è½åå¨8000个è±æï¼4000个æ±åãå¯ä»¥çåºä½¿ç¨ncharãnvarcharæ°æ®ç±»åæ¶ä¸ç¨æ
å¿è¾å
¥çå符æ¯è±æè¿æ¯æ±åï¼è¾ä¸ºæ¹ä¾¿ï¼ä½å¨
温馨提示:答案为网友推荐,仅供参考