éè¦å®ä¹æå符åï¼ä¸è¬å¯ç¨charãvarcharãncharãnvarcharçï¼å
·ä½éè¦çå®é
éæ±ã
è¿å ç§ç±»åçæ¯è¾ï¼
CHAR
CHARåå¨
å®é¿æ°æ®å¾æ¹ä¾¿ï¼CHARå段ä¸çç´¢å¼æç级é«ï¼æ¯å¦å®ä¹char(10)ï¼é£ä¹ä¸è®ºä½ åå¨çæ°æ®æ¯å¦è¾¾å°äº10个åèï¼é½è¦å å»10个åèç空é´ã
VARCHAR
åå¨åé¿æ°æ®ï¼ä½åå¨æç没æCHARé«,å¦æä¸ä¸ªå段å¯è½çå¼æ¯ä¸åºå®é¿åº¦çï¼æ们åªç¥éå®ä¸å¯è½è¶
è¿10个å符ï¼æå®å®ä¹ä¸º VARCHAR(10)æ¯æåç®çãVARCHARç±»åçå®é
é¿åº¦æ¯å®çå¼çå®é
é¿åº¦+1ã为ä»ä¹"+1"å¢ï¼è¿ä¸ä¸ªåèç¨äºä¿åå®é
使ç¨äºå¤å¤§çé¿åº¦ã
ä»ç©ºé´ä¸èèï¼ç¨varcharåéï¼ä»æçä¸èèï¼ç¨charåéï¼å
³é®æ¯æ ¹æ®å®é
æ
åµæ¾å°æè¡¡ç¹ã
NCHARãNVARCHAR
è¿ä¸¤ç§ä»ååä¸çæ¯åé¢ä¸ç§å¤äºä¸ª"N"ãåcharãvarcharæ¯è¾èµ·æ¥ï¼ncharãnvarcharæå¤åå¨4000个å符ï¼ä¸è®ºæ¯è±æè¿æ¯æ±åï¼ècharãvarcharæå¤è½åå¨8000个è±æï¼4000个æ±åãå¯ä»¥çåºä½¿ç¨ncharãnvarchar
æ°æ®ç±»åæ¶ä¸ç¨æ
å¿è¾å
¥çå符æ¯è±æè¿æ¯æ±åï¼è¾ä¸ºæ¹ä¾¿ï¼ä½å¨åå¨è±ææ¶æ°éä¸æäºæ失ã
æ以ä¸è¬æ¥è¯´ï¼å¦æå«æä¸æå符ï¼ç¨nchar/nvarcharï¼å¦æ纯è±æåæ°åï¼ç¨char/varchar