Oracle database Chinese phonetic sorting problem, nls_sort setting
Before Oracle9i, Chinese is sorted according to binary encoding. In oracle9i, according to pinyin, radical, stroke sorting function.
1, set the Nls_sort parameter value
Schinese_radical_m sorted by radical (first order), stroke (second order)
Schinese_stroke_m sorted by stroke (first order), radical (second order)
Schinese_pinyin_m sorted by Pinyin
Binary_ci ignores case-insensitive so
(Y)
I
Coming, Dining-room, many, country
O
[[]
O ' clock, policeman
U
[[]
Autumn
phonetic rules of the combination of consonant and consonant letters
Letter or letter Combination
The type of syllable or position in a word
Pronunciation
Example words
C
Before e, I, Y
[S]
Nice, pencil, bicycle.
In a, O, u and consonants l, r, T befo
MySQL creates a new table, by default with the UTF8 character set, Chinese cannot be directly sorted by pinyin.For example, the following statement:SELECT * from ' Tb_fixedassets ' Order by C_fanameThe results obtained areWorkaround: Change the character set of the field you want to sort to GBK, without changing the character set of the entire database. The results of the modified query are as follows:MySQL to achieve Chinese phonetic sorting
/**
Generation of Phonetic Code table:
Start the Input method Builder to load the window's phonetic input method on the Reverse Conversion tab and save it as a text
This document (Winpy.txt) is standby.
The following code loads the Phonetic Code table file (text) into the array $pymb: (Pinyin, (Chinese characters ...))
Code table conversion Time is longer, shoul
/**
Generation of Phonetic Code table:
Start the Input method Builder to load the window's phonetic input method on the Reverse Conversion tab and save it as a text
This document (Winpy.txt) is standby.
The following code loads the Phonetic Code table file (text) into the array $pymb: (Pinyin, (Chinese characters ...))
Code table conversion Time is longer, shoul
People in the process of using the computer will often encounter can not read the text, there is no way to display the phonetic text? In fact, you can display text pinyin in Word, here's how to use Word to display text pinyin, I hope you can learn how to use Word to display phonetic text to help you identify text that you can't read.
First, will not recognize the Chinese characters copied into the Word2007
In the examination paper typesetting, or textbook typesetting often encounter pinyin tone spelling input problem, the first encounter this problem often overwhelmed, here blue1000 to word2003 as an example of how to play in word pinyin tone.
① will need to add phonetic tones of Chinese characters to the Word document, and then add 1 to 2 spaces between each character, the font spacing open a little bit, and then adjust the font size to a "number" fon
Usually read articles or speeches often encounter some do not read the word, then we need to note the Pinyin, this tutorial for you to introduce how to play phonetic tone. Here I will introduce a few ways to help you.
Operation method
Using the Smart ABC Input method: Switch to Smart ABC, press v first while pressing 8, will pop all phonetic tones, and then choose the tone letter you need.
Environment: Win10 python3.6First of all, the idea of arithmetic:First, the local phonetic library (without tones) is established. Use the greedy algorithm to scan the string from left to right, match the string to the local phonetic library (provided here to everyone), and then continue scanning until the match is found to match or end. Repeat the process.Here's the Python code:defPinyin_or_word (String):"
How to add phonetic guides and settings to Word2007
1. Select the text you want to add pinyin to, switch to the Start tab, and click the Phonetic Guide button in the Font group.
2, the Phonetic Guide dialog box will pop up, the default options and preview effect as shown in the following figure.
3. Alignment refers to the position sta
Chinese Pinyin Whole spelling
The code is as follows
Copy Code
--Create a Chinese phonetic control temporary tableCREATE TABLE IF not EXISTS ' T_base_pinyin ' (' Pin_yin_ ' varchar (255) CHARACTER SET GBK not NULL,' Code_ ' int (one) is not NULL,PRIMARY KEY (' Code_ ')) Engine=innodb DEFAULT charset=latin1;--Inserting data INSERT into T_base_pinyin (pin_yin_,code_) VALUES ("a", 20319), ("AI", 20317), ("A", 20304), ("Ang",
In this article, I recorded how MySQL is implemented to sort names alphabetically, and here's how this sort is implemented in Java. The code is as follows:1 PackageCom.review.chapter6;2 3 ImportJava.text.Collator;4 Importjava.util.Collections;5 ImportJava.util.Comparator;6 Importjava.util.Enumeration;7 ImportJava.util.Locale;8 ImportJava.util.Vector;9 Ten Importorg.junit.Test; One A /** - * This example demonstrates sorting by phonetic order in the
Python Kanji Conversion Phonetic Code
#-*-coding:utf-8-*-# return pinyin of Chinese charactersdef return_pinyin (word):Global ReslistFor line in Reslist:if (word==line[0]+line[1]) or (word==line[2]+line
[3]):str = lineBreak# take the content between ① and ②s = str.find (U ' ① ') +4E = str.find (U ' ② ') +3return Str[s:e]def getpy (word):#首先装载资源文件I=0Allstr = ' 'While IIf Ord (Word[i]) >127:If Allstr:Allstr + + return_pinyin (word[i]+word[i+1])E
' Zao ', N ' ovens 'UNION ALL select ' Ze ', N ' 稄 'UNION ALL SELECT ' Zei ', N ' 鱡 'UNION ALL SELECT ' Zen ', N ' 囎 'UNION ALL select ' Zeng ', N ' giveaway 'UNION ALL SELECT ' Zha ', N ' winepress 'UNION ALL SELECT ' Zhai ', N ' partners 'UNION ALL SELECT ' Zhan ', N ' 驏 'UNION ALL select ' Zhang ', N ' 瞕 'UNION ALL select ' Zhao ', N ' 羄 'UNION ALL SELECT ' Zhe ', N ' 鷓 'UNION ALL select ' Zhen ', N ' gloom 'UNION ALL select ' Zheng ', N ' certificate 'UNION ALL select ' Zhi ', N ' 豒 'UNION
Topic Description
Using letters to make up some beautiful graphics, here's an example:
ABCDEFGBabcdefCbabcdeDcbabcdEdcbabc
This is a 5 row 7 column of graphics, please find out the pattern of this graph, and output a n row m column of
Here's how to categorize each contact with the same initials:In adapter implement SectionindexerIn this way adapter must implement the following 3 interfaces:@Overridepublic object[] GetSections () {//section's collection} @Overridepublic int
Ubuntu, File Sorting this thing has been the most do not understand, of course, the English is A-Z, but the Chinese language is a bit confused, how do not understand it is how a sort method, sometimes it is awkward to find something. The following
In fact, the idea of solving this problem is very simple. That is to find out the inner code range of Chinese characters whose initials are "a" to "Z" in the Chinese character table, you only need to check the inner code within the range of which is
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.