Summary of initial consonant function definition and usage

sqlServer Get the pinyin initial consonants of Chinese character strings. Friends in need can refer to it. ​ The code is as follows: CREATE function fGetPy(@str varchar(500)='') returns varchar(500) as begin declare @strlen int,@return varchar(500),@ii int declare @c nchar(1),@chn nchar (1) select @strlen=len(@str),@return='',@ii=0 set @ii=0 while @ii='吖' select @c = char(count(*)+63) from ( select top 27 * from ( select chn = '吖' union all select '八' union all select '嚓' union

1. sqlServer Gets the pinyin initial consonants of Chinese character strings

Introduction: Get the pinyin initials of Chinese character strings in sqlServer. Friends who need it can refer to it.

##2. According to Chinese characters. According to the initial consonants of Chinese characters, you want to find relevant records in the table, how to implement it_MySQL

Introduction: According to the initial consonants of Chinese characters, you want to find relevant records in the table, how to implement it

3. PHP Convert Chinese characters, Pinyin, unicode, initial consonants, and final consonants to each other

Introduction: PHP Convert Chinese characters, Pinyin, unicode, initial consonants, Convert vowels to each other

4. js Get Chinese Pinyin, Select code to automatically match letters to get values_Form special effects

Introduction: Convert Chinese characters to Pinyin, the first letter of Pinyin, select to filter by initial consonants

[Related Q&A recommendations]:

The above is the detailed content of Summary of initial consonant function definition and usage. For more information, please follow other related articles on the PHP Chinese website!