Time flies. I graduated from the 13-year project for one year and two months, and I have been working in the same company for six months. I haven't written a blog for a long time. I was a game enthusiast before graduation, when I graduated from college, I spent three consecutive days and three nights in an Internet cafe in Guangzhou. Lol broke the two-day and two-night records in high school. Now I am afraid of many cases of sudden death in Internet cafes, fortunately, we are still alive. Fortun
info as ion C. uname = I. unamecollate custom table customerdrop table info/* create an initial data table customerid uname -------------- 1 jim2 simith3 uonun create an initial data table infouname phone -------- ----------- Jim 13800000000 simith 13911111111 uonun 13812345678 is case insensitive, id C. uname I. uname phone ----------- ---------- ----------- 1 Jim 138000000002 simith 139111111113 uonun 13812345678 case sensitive, not all-round id c. uname I. uname phone ----------- ----------
1. gb2312
Two bytes are used to indicate that the first byte of each byte is 1, so that the values in the high byte and low byte are greater than 127. Rule: A character smaller than 127 has the same meaning as the original ansic code, but when two characters larger than 127 are connected together, it indicates a Chinese character, the previous byte (high byte) uses 0xf7 from 0xa1, And the next byte (low byte) ranges from 0xa1 to 0xfe, so that we can combine more than 7000 simplified Chinese cha
# T2 BOn a. Name = B. Name collate chinese_prc_ci_ai_ws
Ii. Sorting rule introduction:
What is a sorting rule? "In Microsoft SQL Server 2000,The physical storage of strings is controlled by sorting rules. Sorting rules specify the bit mode and storage of each characterRules Used for saving and comparing characters. "Run the following statement in the query analyzer to obtain all the sorting rules supported by SQL Server.
Select * From: fn_helpcollations ()
The name of a sorting rule consists of
Ordinary strings in the py2.7 are ASCII-encoded, for example, str= "ABC", if it contains Chinese will be GBK or gb2312 code (GB2312 is the Chinese provisions of Chinese character coding, also can be said to be Simplified Chinese character set encoding; GBK is an extension of GB2312, besides compatible GB2312, it can also display traditional Chinese, as well as kana in Japanese.But by adding u to the string, such as Str=u "ABC", you can define the stri
Recently changed a system, now with Mac system.When Emacs is turned on, Chinese support is not very good. Some places can be displayed. In the gaze of the. El file, this box is shown as a mouth-to-mouth, mouth-mouth port. For example, as seen in theLooking for a long day. is due to a problem with Chinese fonts. Just set the Chinese font to the right.Once in Linux under the Chinese support is very good, without the formulation of the text body can be displayed.The formulation code such as the fol
]; } } } //......... } handles and accepts the message from the client, discovers that the client replies to its name, and then looks in the list of currently connected clients based on the previously assumed name, turning the kana into the real name JS function SendMessage () { var othername=$ ("#othername"). Val (); var msg= "msg\t" +username+ "_" +othername+ "_" +$ ("#message"). Val (); Send (msg); } customer initiates a c
display Chinese, they do not need to download IE Chinese Language support package.★GBK is the standard of GB2312 compatible GB2312 on the basis of national standard. GBK's text encoding is expressed in two-byte notation, that is, both Chinese and English characters are expressed in double-byte notation, and the highest bits are set to 1 in order to differentiate Chinese. GBK contains all the Chinese characters, is the country code, the universality is worse than the UTF8, but UTF8 occupies the
, accent-sensitive, and width-sensitive. The last one is not mentioned further in the SQL Server online Help, but the problem that this article encounters is caused by this reason. Width sensitive: Specifies that SQL Server distinguishes between single-byte representations (half-width) and Double-byte representations (full-width) for the same characters. If there is no selection, SQL Server will consider the same character as a single-byte representation and a double-byte notation.
By default,
recommended for use.
Someone familiar with my history of digging a hole can certainly turn to something I used to give to my Tex-plus front end, the implementation is very simple, with the off-the-shelf markdown library to do IO-level translate, this kind of thing is actually very simple. But this will cause some of the lack of style processing, so temporarily stranded. Processing on Io is necessary, such as the comments I recently added to the code:
Reference:
* https://www.microsoft
Intelligent ABC Input Method, also known as Standard IME, is the Chinese Windows3.2 and windows95/98 of a Chinese character input methods, by the Peking University, Mr. Zhu Shoutao invented. It is easy to learn, fast and flexible, by the user's favor.
Antarctic Star-Japanese input method is not a Japanese environment to enter Japanese tool. The new version of the Antarctic star has integrated the Japanese input method into the global system. But for many friends who need to enter Japanese in
number and current date. Try the above command in a different case to see what the results are. The results show that the case of the MySQL command is consistent.
Practice the following actions:
Mysql>select (20+5) *4;
Mysql>select (20+5) *4,sin (Pi ()/3);
Mysql>select (20+5) *4 as Result,sin (Pi ()/3); (as: Specify Kana as result)
Mysql> Select
-> USER ()
->,
-> Now ()
->;
+--------------------+---------------------+
| USER () | Now () |
This article defines collations and describes how to transform the collation of a database in Microsoft SQL Server. The same concepts and discussions about SQL Server 2000 apply to SQL Server 2005.
What are collation rules?
The collation specifies the bit pattern that represents each character. It also specifies the rules for sorting and comparing characters. Collations have the following characteristics:
Language
Case sensitive
Accent Sensitive
Distinguish
Internet, but only through a Web page on the MySQL host.Grant Select,insert,update,delete on mydb.* to [e-mail protected] identified by "ABC";If you do not want to test2 have a password, you can call another command to erase the password.Grant Select,insert,update,delete on mydb.* to [e-mail protected] identified by "";4, the first commandMysql> Select Version (), current_date ();+----------------+-----------------+| Version () | Current_date () |+----------------+-----------------+| 3.23.25a-d
1.viewing collationsSelect SERVERPROPERTY (' collation ');2.Specifying the collation of a columnALTER TABLE T2Add Y nvarchar (+) collate chinese_prc_ci_as;Go---------------------------------------------------Chinese---The meaning of "body word" "Chinese".Chinese "PRC refers to People's Republic of China---The People's Republic of China.CHINESE_PRC---Simplified ChineseCI (CS): Is case-sensitive, CI is not differentiated, CS is differentiated.Ai (AS): whether accent-sensitive, AI is not differenti
() | +----------------+-----------------+ | 3.23.25a-debug | 2001-05-17 | +----------------+-----------------+ 1 row in Set (0.01 sec) mysql>This command requires the MySQL server to tell you its version number and the current date. Try the above command with a different case, and see what the result is. The result shows that the case of the MySQL command is consistent. Practice the following: Mysql>select (20+5); Mysql>select (20+5) *4,sin (Pi ()/3); Mysql>select (20+5) as Result,sin (Pi ()/3)
Tags: logs sort rom png ios binary arc font nameSelect * FROM [dbdata]. [dbo]. [T_student] where name= ' lilei ' query results are as follows:Conclusion: SQL Server default is case insensitive by query results. Select * FROM [dbdata]. [dbo]. [T_student] where Name like '% (% ' COLLATE CHINESE_PRC_CS_AI_WS query results are as follows: The Collation name consists of two parts, and the first half refers to the character set supported by this collation. such as: chinese_prc_cs_ai_ws First ha
SQL Pinyin and stroke sorting in ChineseCities sorted by Pinyin:
SELECT chinesename from [table name] ORDER by Chinesename collate chinese_prc_cs_as_ks_ws ASC
Cities sorted by Stroke:
SELECT chinesename from [table name] ORDER by Chinesename collate chinese_prc_stroke_cs_as_ks_ws ASC /c5>
The above code in GD on debugging through.Two more sentences, the collation name consists of two parts, the first half refers to the character set supported by this collation.Suc
Label:Initial selection ResultsSELECT * FROM WorddictionaryThe following is the alphabetical order by Chinese charactersSELECT * from Worddictionary ORDER by word collate chinese_prc_cs_as_ks_wswhich_ci (CS) is case sensitive, CI is not differentiated, CS is distinguished_ai (AS) are accent-sensitive, AI not differentiated, as differentiated_ki (KS) Whether the kana type is differentiated, KI does not differentiate, KS differentiates_WI (WS) Whether t
precedes the text, when a nation has not its own words, when exposed to foreign civilization, it is easy to use the "character system" of foreign civilization to build their own words, for these peoples, the simplest is to use advanced civilization of the letter system to directly express their own language pronunciation. As a result, the secondary civilizations of Europe, from which Philip was based, naturally used letters to record their language. For example, although Japan introduced the "C
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.