字段按照汉语拼音首字母A-Z排序

一、汉字首字母拼音A-Z排序
方法一：MySQL数据库下
https://blog.csdn.net/wjy_treasure/article/details/73119630

select * from t_student order by CONVERT(trim(user_name) USING gbk) asc;

方法二：
https://blog.csdn.net/angel708884645/article/details/51099115

	/**
	 * 根据汉字首字母拼音按A-Z依次排序
	 * @param charactersArr
	 * @return
	 */
	public static String[] getSortedCharacters(String[] charactersArr){
		//w d c l h y z
		//c d h l w y z
		charactersArr=new String[]{"王明","当敏","菜盛","李强","黄钜","俞二","俞四","李丽丽"};
		Comparator comparator=Collator.getInstance(Locale.SIMPLIFIED_CHINESE);
		Arrays.sort(charactersArr, comparator);
		for (int i = 0; i < charactersArr.length; i++) {
			System.out.println(i+"="+charactersArr[i]);
		}
		return charactersArr;
	}

二、UTF8与GBK对比
https://blog.csdn.net/zs15yy/article/details/73921100
UTF8:英文字符占用 1个字节，中文字符占用3个字节；
GBK: 文字编码使用双字节编码，即中英文字符均占用 2个字节；