This article introduces how to sort Chinese characters and Chinese characters by pinyin in mysql. For more information, see.
The order by keyword is used to sort the data in the record set.
If we use a normal sorting method
The Code is as follows:
Copy code
' union ALL SELECT ' E ', n ' 樲 ' union ALL Select ' F ', n ' leiognathi ' union ALL Select ' G ', n ' hiker ' union ALL Select ' H ', n ' inceѕt ' union ALL Select ' J ', n ' 攈 ' UNION ALL Select ' K ', n ' 穒 ' union ALL Select ' L ', n ' 鱳 ' union ALL Select ' M ', n ' temperature ' union ALL SELECT ' n ', n ' 桛 ' union ALL Select ' O ', n ' retting ' UN ION all Select ' P ', n ' exposure ' UNION ALL SELECT ' Q ', n ' 囕 ' union ALL Selects ' R ', n ' 鶸 ' union ALL Select ' S ', n ' 蜶 ' union
ASP Chinese characters converted into Hanyu Pinyin code, the following code saved as an ASP file to run the results can be seenSet d = CreateObject ("Scripting.Dictionary")D.add "A",-20319D.add "AI",-20317D.add "An",-20304D.add "Ang",-20295D.add "AO",-20292D.add "Ba",-20283D.add "Bai",-20265D.add "Ban",-20257D.add "Bang",-20242D.add "Bao",-20230D.add "Bei",-20051
Chinese | Chinese characters | pinyin | conversion program Source: Csdn.net
The code is as follows
Py.asp Demo Address: http://www.cnaspol.com/py.asp
Set d = CreateObject ("Scripting.Dictionary")
D.add "A",-20319
D.add "AI",-20317
D.add "An",-20304
D.add "Ang",-20295
D.add "AO",-20292
D.add "Ba",-20283
D.add "Bai",-202
Chinese | Chinese Characters | essence | pinyin | conversion program Source: Csdn.net
The code is as follows
Py.asp Demo Address: http://www.cnaspol.com/py.asp
Set d = CreateObject ("Scripting.Dictionary")
D.add "A",-20319
D.add "AI",-20317
D.add "An",-20304
D.add "Ang",-20295
D.add "AO",-20292
D.add "Ba",-20283
D.add
Recently use Sogou Input method, found in the Chinese state, can only play to pinyin, can not play Chinese characters. Start thinking is the input method problem, later in the Sogou Input method prompt bar Right-click, found that there is an "E-English input" This option is on, clicked to make it invalid after found no
The recent use of Sogou input method, found in the Chinese state, can only play to pinyin, can not play Chinese characters. Start thinking is the input method of the problem, and then in the Sogou input prompt bar Right, found that there is an "E-English input" this option when the light, click to make it invalid found
Converts any input Chinese characters to PinYin
(1) only one pronunciation is used for the multiphonograph.
(2) Use unknown instead of pinyin for uncommon words.
Package com. amgotech;
Public class chinesespelling{Private Static int [] pyvalue = new int [] {-20319,-20317,-20304,-20295,-20292,-20283,-20265,-20257, -202
1) convert Chinese characters into full spelling
# Region attribute data definition // machine internal code array of Chinese characters private static int [] pyValue = new int [] {-20319,-20317,-20304,-20295,-20292, -20283,-20265,-20257,-20242,-20230,-20051,-20036,-20032,-20026,-20002,-19990,-19986,-19982, -19976,-19
Today, I saw a "C # Calculate Chinese pinyin code" on the Blog of yyf9989. I thought it was complicated to read the code. It mainly retrieves the position of the input Chinese characters in the array and returns the first letter. So I remembered that I could use the Chinese
This Code uses C # To convert Chinese characters into Pinyin and develop web pages. The specific implementation is as follows:Public partial class WebForm1: System. Web. UI. Page{Private Static int [] pyvalue = new int [] {-20319,-20317,-20304,-20295,-20292,-20283,-20265,-20257, -20230,-20051,-20036,-20032,-20026,-20002,-19990,-19986,-19982,-19976,-19805,-19784,-
SELECT ' UNION ALL SELECT ' 嘸 ' union ALL SELECT ' Hallasan ' UNION ALL SELECT ' Oh ' UNION ALL SELECT ' 妑 ' UNION ALL select ' Seven ' union ALL Select ' 呥 ' UNION ALL SELECT ' Three ' union ALL select ' He ' union ALL select ' 屲 '/*no ' u ' */UNION ALL SELECT ' 屲 '/*no ' V ' */UNION ALL SE Lect ' 屲 ' union ALL SELECT ' XI ' union ALL Select ' Ya ' union ALL SELECT ' as ' union ALL select @chn] as a order by CHN COLLATE C Hinese_prc_ci_as) as BElseSet @[email protected]Set @[email Protected][e
Chinese character | Pinyin many problems are caused by Chinese problems
If the filename is best not in Chinese
Now the solution is usually to generate an ID, the ID to do the file name
If the URL has Chinese characters on the page
Chinese characters into pinyin (PHP version) Many servers for Chinese file name support is not very good, there is no good way to solve it??? Now the solution is usually to generate an ID, the ID to do the file name; If the URL has a Chinese character on the page, it often g
Chinese character | Pinyin many problems are caused by Chinese problems
If the filename is best not in Chinese
Now the solution is usually to generate an ID, the ID to do the file name
If the URL has Chinese characters on the page
During development, sometimes we need to sort the attributes of objects in a set in pinyin order to help us quickly find Chinese characters. I use the Comparator interface, define sorting rules in this interface, get the Chinese character encoding of the comparison object, convert it into a String, and use the String c
Need to download pinyin4j: http://pinyin4j.sourceforge.net/
Code
Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->Package utils;
Import net. SourceForge. pinyin4j .*;Import net. SourceForge. pinyin4j. format .*;Import net. SourceForge. pinyin4j. format. Exception .*;
Public class pinyin {/*** Convert Chinese characters
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.