charç±»åï¼ å¯¹è±æ(ASCII)å符å ç¨1个åèï¼å¯¹ä¸ä¸ªæ±åå ç¨2个åèï¼CHARåå¨å®é¿æ°æ®å¾æ¹ä¾¿ï¼CHARå段ä¸çç´¢å¼æç级é«ï¼æ¯å¦å®ä¹ char(10)ï¼é£ä¹ä¸è®ºä½ åå¨çæ°æ®æ¯å¦è¾¾å°äº10个åèï¼é½è¦å å»10个åèç空é´ãå 为æ¯åºå®é¿åº¦ï¼æ以é度æçé«ã Varcharç±»åï¼Varchar çç±»åä¸ä»¥ç©ºæ ¼å¡«æ»¡ï¼æ¯å¦varchar(100)ï¼ä½å®çå¼åªæ¯"qian",åå®çå¼å°±æ¯"qian"
èchar ä¸ä¸æ ·ï¼æ¯å¦char(100),å®çå¼æ¯"qian"ï¼èå®é
ä¸å®å¨æ°æ®åºä¸æ¯"qian "(qianåå
±æ96ä¸ªç©ºæ ¼ï¼å°±æ¯æå®å¡«æ»¡ä¸º100个åè)ã
ç±äºcharæ¯ä»¥åºå®é¿åº¦çï¼æ以å®çé度ä¼æ¯varcharå¿«å¾å¤!ä½ç¨åºå¤çèµ·æ¥è¦éº»ç¦ä¸ç¹ï¼è¦ç¨trimä¹ç±»çå½æ°æ两边çç©ºæ ¼å»æ! VARCHARåå¨åé¿æ°æ®ï¼ä½åå¨æç没æCHARé«ãå¦ æä¸ä¸ªå段å¯è½çå¼æ¯ä¸åºå®é¿åº¦çï¼æ们åªç¥éå®ä¸å¯è½è¶
è¿10个å符ï¼æå®å®ä¹ä¸º VARCHAR(10)æ¯æåç®çãVARCHARç±»åçå®é
é¿åº¦æ¯å®çå¼çå®é
é¿åº¦+1ã为ä»ä¹â+1âå¢ï¼è¿ä¸ä¸ªåèç¨äºä¿åå®é
使ç¨äºå¤å¤§çé¿åº¦ã Ncharç±»ååNvarcharç±»åæ¯æä¹ä¸åäºå¢ï¼ä¸ºäºä¸å
¶ä»å¤ç§å符ç转æ¢ï¼å¦ä¸æï¼é³æ çï¼å¯¹æ¯ä¸ªè±æ(ASCII)å符é½å ç¨2个åèï¼å¯¹ä¸ä¸ª æ±åä¹å ç¨ä¸¤ä¸ªåèï¼ææçå符é½å ç¨2个åèã
温馨提示:答案为网友推荐,仅供参考