m m initials

Tags: result requires package COM HTTP BSP collation ACL OracleOracle Kanji Pinyin (get full spell/pinyin initials/Pinyin intercept, etc.)The effect is as follows: Oracle character Set GBK no problem, UTF-8 needs to be modifiedSQL code--oracle Kanji to Pinyin package--1. Get full spellSELECT gethzpy. Gethzfullpy (' kanji ') from DUAL;Results: Hanzi--2. Pinyin First LetterSELECT gethzpy. Gethzpycap (' kanji ') from DUAL;Result: HZ--3. Pinyin intercepti

Tags: http io ar OS SP on data 2014 issuesHaven't written a blog for a long time, but also accumulated a lot of problems, next time find a way together, and then record down, for a rainy day. Our list of contacts often has a need to sort by initials. This is very convenient, very clear, if not say how performance, like to let the database to do it? In fact, MySQL is supported. We set up a function: DELIMITER $ $CREATE FUNCTION ' fristpinyin ' (p_name

Some time ago on the internet to see an interview question, requirements are as follows: The employee file records the work number and the name Copy Code code as follows: Cat Employee.txt: Jason Smith John Doe Sanjay Gupta Ashok Sharma Record work numbers and wages in bonus documents Copy Code code as follows: Cat Bonus.txt: 100 $5,000 200 $ 300 $3,000 400 $1,250 Two files are required to be merged and exported as follows:

The program code is: Thzspell.pyofhz (Edit1.text)//Get Pinyin of Chinese characters Uppercase (Thzspell.pyheadofhz (Edit1.text))//Get pinyin Initials ----------------------------------code file--------------------------------------------------------------------- Unit Hzspell;{version 4.1}InterfaceUsesWindows, Messages, Sysutils, Classes;TypeThzspell = Class (Tcomponent)Protectedfhztext:string;fspell:string;fspellh:string;Procedure Sethztext (const

By default, the Word2007 document user name is the user name of the currently logged on Windows system. The user can change the Word2007 document user name to the appropriate name according to the actual work, as described in the following steps: Step 1th, open the Word2007 document window, and click the Office Button → Word options button, as shown in Figure 20112032601. Figure 2012032601 Click the Word Options button Step 2nd, open the Word Options dialog box, set the appropriate user nam

Java code Select e.fullname,e.expert_id from Expert e where f_trans_pinyin_capital (substr (E.fullname,1,1)) = ' Z ' Finally, we show an example of combining the two: Java code Select E.expert_id,e.eperson_id,e.fullname, SUM (b2i.browse_num) Browsecount, Count (o.object_id), Wmsys.wm_concat (distinct d.name) From expert E Left join Expert2disciplinetype e2d on e2d.expert_id = e.expert_id Left join Disciplinetype D on d.discipline_type_id = e2d.discipline_ty

(@str,@intLen,1)>= 'Acridine' Then 'A' Else RTrim(LTrim(substring(@str,@intLen,1))) End --for kanji special characters, no phonetic codes are generated if(ASCII(@temp)>127)Set @temp = "' --for English parentheses, no phonetic codes are generated if @temp = '(' or @temp = ')' Set @temp = "' Select @strRet = @temp + @strRet Set @intLen = @intLen - 1 End return Lower(@strRet) End EXECUTE statementSELECT as Column Aliases from Ta

Sorts and retrieves the first letter of Chinese pinyin according to the first letter of Chinese pinyin. This section describes the function of ranking by Chinese characters including the first letter, strokes, and radicals. [nlssort ]: 1) First

A module in a recent project needs to implement the pinyin initial character query function. I checked the information online and modified the information to meet the project requirements. The implementation process is as follows: 1. Create a

A long time not to update the blog, or feel that the work needs more summary of good. Let's update a question that I think is more accomplished today. Recently in the storage value settlement, the need to settle the home page needs to be sorted by

The php code pulled from someone else's program to extract the first letter of a Chinese character is not original. Dzender for code learning The code is as follows: Function pykey ($ py_key){$ Pinyin = 65536 + pys ($ py_key );If (45217 {$ Zimu =

Project requirements: Read the first letter of the user and display it by category! Of course, all the names are in English or pinyin! There is really no way, it's an ugly way... SortName.aspx name sorting  

Create Table 'tbl _ py '('Py' char (1) Character Set utf8 not null,'Hz 'Char (1) not null default '',Primary Key ('py ')) Engine = InnoDB default charset = GBK;Insert into tbl_py values('A', 'hangzhou '),('B', 'book '),('C', 'error '),('D', 'region '

Copy codeThe Code is as follows: Function pykey ($ py_key) { $ Pinyin = 65536 + pys ($ py_key ); If (45217 { $ Zimu = ""; Return $ zimu; } If (45253 { $ Zimu = "B "; Return $ zimu; } If (45761 { $ Zimu = "C "; Return $ zimu; } If (46318 { $ Zimu =

--Using a program block -->title: Generating test data -->author:wufeng4552 -->date:2009-09-21 13:40:59 DECLARE @s varchar (8000) Set @s=lower (@ @version) Select @s /* Microsoft SQL Server 2005-9.00.4035.00 (Intel x86) Nov 24 2008

The method I provide has the following characteristics:1. Code simplification, simple to use, as long as the basic SQL statement will be the line2. No need to build MySQL functions and other complex things3. The most complete Chinese character

We often see a number of sites by city name or alphabetical ranking, I would like to introduce how this thing to achieve it, we share a section of the use of PHP to obtain the Chinese characters in the first character of the letter. The

USE [JewelryRetailClientDB]GO/***** Object: UserDefinedFunction [dbo]. [Func_GetPY] Script Date: 10/19/2011 14:21:59 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- ===================================================== ======-- Author: xoyozo-

Create a custom pinyin function in SQL:Create function f_GetPy (@ Str nvarchar (400 ))Returns nvarchar (4000)AsBeginDeclare @ strlen int, @ re nvarchar (4000)Declare @ t table (chr nchar (1) collate Chinese_PRC_CI_AS, letter nchar (1 ))Insert @ t

For example: $str = ' Chinese People '; return to ZHRM; Here is a function of my Baidu, but some things will go wrong, for example: Chongqing Back to the ZQ. function Getfirstchar ($s 0) {$firstchar _ord = Ord (Strtoupper ($s 0{0})); if (