ããmysqlCOLLATEæ¯æ ¡å¯¹éçææï¼å¯ä»¥ç解为ï¼æåºè§åçãä¸ä¸ªå符éå¯è½æå¤ç§æ ¡å¯¹éåï¼
ããä¾åå¦ä¸ï¼
ããCREATE DATABASE db_name
ãã[[DEFAULT] CHARACTER SET charset_name]
ãã[[DEFAULT] COLLATE collation_name]
ããä¾å¦ï¼
ããCREATE DATABASE db_name
DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ããMySQLè¿æ ·éæ©æ°æ®åºå符éåæ°æ®åºæ ¡å¯¹è§åï¼
ãã· å¦ææå®äºCHARACTER SET XåCOLLATE Yï¼é£ä¹éç¨å符éXåæ ¡å¯¹è§åYã
ãã· å¦ææå®äºCHARACTER SET Xè没ææå®COLLATE Yï¼é£ä¹éç¨CHARACTER SET XåCHARACTER SET Xçé»è®¤æ ¡å¯¹è§åã
ãã· å¦åï¼éç¨æå¡å¨å符éåæå¡å¨æ ¡å¯¹è§åã
ãã
谢谢您的回复,那请问,空格和非空格字符串,怎么排序呢?谢谢。
本回答被网友采纳