mysql 里实现查询汉字的拼音首字母
哪位大侠 给我个 mysql 里实现查询汉字的拼音首字母 能用的
------解决方案--------------------
http://topic.csdn.net/u/20090611/17/7579bb9a-0a7c-4460-a302-10bae7f4a9c5.html
------解决方案--------------------
function getfirstchar($s0){
if($s0[0]=='i' || $s[0]=='i'){
return i;
}elseif($s0[0]=='u' || $s[0]=='u'){
return 'u';
}elseif($s0[0]=='v' || $s[0]=='v'){
return 'v';
}else{
$fchar = ord($s0{0});
if($fchar >= ord(a) and $fchar $s1 = iconv(utf-8,gb2312, $s0);
$s2 = iconv(gb2312,utf-8, $s1);
if($s2 == $s0){$s = $s1;}else{$s = $s0;}
$asc = ord($s{0}) * 256 + ord($s{1}) - 65536;
if($asc >= -20319 and $asc if($asc >= -20283 and $asc if($asc >= -19775 and $asc if($asc >= -19218 and $asc if($asc >= -18710 and $asc if($asc >= -18526 and $asc if($asc >= -18239 and $asc if($asc >= -17922 and $asc if($asc >= -17417 and $asc if($asc >= -16474 and $asc if($asc >= -16212 and $asc if($asc >= -15640 and $asc if($asc >= -15165 and $asc if($asc >= -14922 and $asc if($asc >= -14914 and $asc if($asc >= -14630 and $asc if($asc >= -14149 and $asc if($asc >= -14090 and $asc if($asc >= -13318 and $asc if($asc >= -12838 and $asc if($asc >= -12556 and $asc if($asc >= -11847 and $asc if($asc >= -11055 and $asc return null;
}
}
这是我之前的做的，希望可以帮到您！
------解决方案--------------------
那不就结了