refers to the character set supported by this collation.Such as:Chinese_prc_cs_ai_wsFirst half: Refers to the Unicode character set, chinese_prc_ the pointer to the mainland simplified Unicode collation. The second half of the collation is the suffix meaning:_bin binary Ordering_ci (CS) is case sensitive, CI is not differentiated, CS is case sensitive: Select this option if you want comparisons to treat uppercase and lowercase letters as unequal._ai (AS) is accent-sensitive, AI is not different
refers to the character set supported by this collation. such as: chinese_prc_cs_ai_ws First half: Refers to the Unicode character set, chinese_prc_ the pointer to the mainland simplified Unicode collation. The second half of the collation is the suffix meaning: _bin binary sort _ci (CS) is case sensitive, CI is not differentiated, CS is case sensitive: Select this option if you want comparisons to treat uppercase and lowercase letters as unequal. _ai (AS) accen
Tags: des blog http Using strong widthWhat is a collation (collation) About the SQL Server collation, it is estimated that everyone is not unfamiliar, when creating a database we often have to choose a collation (conllation), generally we will notice that each language collation has many kinds, such as the standard Continental Simplified Chinese chinese_ There are dozens of kinds of collations in PRC What is the role of these collations? Let's take a look at MS's official explanation first:
two more than 127 words connect prompt together, it represents a Chinese character, the preceding byte (which he calls a high byte) is used from 0xa1 to 0xf7, followed by a byte (low byte) from 0xa1 to 0xFE, This allows us to assemble about 7,000 + Simplified Chinese characters. In these codes, we also put mathematical symbols, Roman Greek alphabet, Japanese kana have been compiled into, even in ASCII, the number, punctuation, letters are all re-comp
) |+ --------------------- +| 9 |+ --------------------- +1 row in set (0.00 sec) Select year (CURRENT_DATE );+ -------------------- +| YEAR (CURRENT_DATE) |+ -------------------- +| 1, 2009 |+ -------------------- +1 row in set (0.00 sec)
4. display stringsMysql> SELECT "welecome to my blog! ";+ ---------------------- +| Welecome to my blog! |+ ---------------------- +| Welecome to my blog! |+ ---------------------- +1 row in set (0.00 sec)
5. when using a calculatorSelect (4*4)/10) + 25;+ ----
IME is the abbreviation for Input Method Editor. It is a specialized application used to enter different characters that represent the written language of the East Asian region.
Using this input method, you can enter the various languages of East Asian countries (such as Chinese, Japanese, Korean, Russian, and so on) without special keyboards (for keyboards of all kinds).
Japanese IME, is can input phonography (kana) and Xixi Huai wo naan nao (kanji)
| +---------------+ | Monica Sehgal | | Hal Simlai | | Joseph Irvine | +---------------+ 3 rows in set (0.00 sec)
Note: The CONCAT () function is used to concatenate strings. In addition, we also use the previously learned AS to give the result column 'concat (f_name, "", l_name) 'A Kana.
5.1 create a data table
Command: create table
For example, to create a table named MyClass,
Field name
Numeric type
Data width
Empty
system. 4. Broken air type (with one heart) select? s owhere {s P O} Break method: The use of the good, the heart, and the general decision and other forms similar, but the broken things have subtle differences, specifically for the absence of a real subject or an anonymous subject, The return result may be just a random name in the field. Formula: Nameless is also famous, Kana is also true name, equivalent to using a placeholder to represent the cor
, this encoding problem occurs because the occasional colleague sets GB2312 encoding. When some special characters are involved, the system will return an error and change it to "? .
Mysql error: Warning: #1366 Incorrect string value: solution:
It is easy to change the original encoding gb2312 to gbk encoding or utf8 encoding.
Attached: GB2312 and GBK encoding differences.
GB2312 is a Chinese character encoding set in simplified Chinese. GBK is an extension of GB2312. In addition to compatibilit
[_ WidthSensitive]| _ BIN ParametersCollationDesignatorSpecifies the basic sorting rules used by Windows sorting rules. Basic sorting rules include:Specifies the alphabet or language in which the sorting rules are applied when sorting by dictionary is specified.The code page used to store non-Unicode character data.For example, Latin1_General or French, both use the code page 1252 or Turkish, and use the code page 1254.Casesensiti.pdfThe CI parameter is case insensitive and the CS parameter is
symbols are directly canceled off. Rule: A character less than 127 is the same as the original, but two more than 127 words connect prompt together, it represents a Chinese character, the preceding byte (which he calls a high byte) is used from 0xa1 to 0xf7, followed by a byte (low byte) from 0xa1 to 0xFE, This allows us to assemble about 7,000 + Simplified Chinese characters. In these codes, we also put mathematical symbols, Roman Greek alphabet, Japanese
Recognize common encodings GB2312 is a Chinese set of Chinese character coding, can also be said to be Simplified Chinese character set encoding GBK is an extension of GB2312, in addition to compatibility with GB2312, it can also display traditional Chinese, as well as Japanese kana cp936: Chinese Local system is the CMD in Windows, the default codepage is cp936,cp936 refers to the system in the No. 936 code format, that is, GB2312 encoding.(Of cou
sorting rule. For more information, see SQL sorting rule name.
2. what is a sorting rule?
"In Microsoft SQL Server 2000,The physical storage of strings is controlled by the sorting rules. The sorting rules specify the bit mode of each character and the storageRules used for saving and comparing characters"SQLSERVER
Select * from: fn_helpcollations ()
The name of a sorting rule consists of two parts. the first half is the character set supported by this sorting rule.For example:Chinese_PRC_CS_AI
();
In phpinfo, Environment can be searched for PROJECT_NAME.
Putenv ("PROJECT_NAME = Me"); phpinfo ();
In phpinfo, Environment cannot find PROJECT_NAME.
Ask your friends. why? How can I set Chinese values without barriers?
I also tried it and found that as long as it is called in the cgi environmentPutenv ('Project _ NAME = drop ')And so on (four bytes, the same for Japanese kana ).falseIn the cli environment:
Region ~ $ Php-r "var_dump (putenv (
in CSS, use List-style-type to specify the preceding symbol for the list (lists), as follows:li {list-style-type: symbol name}the values available for symbol names are:Disc:css1 Solid CircleCircle:css1 Hollow CircleSQUARE:CSS1 Solid BlockDecimal:css1 Arabic numeralsLower-roman:css1 lowercase roman numeralsUpper-roman:css1 Capital Roman numeralsLower-alpha:css1 lowercase English alphabetUpper-alpha:css1 Capital English alphabetNone:css1 do not use bulletsArmenian:css2 Traditional Armenian numeral
tell you its version 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)A command can be entered into multiple lines until the semicolon ";" appears:Bordercolorlight = "BLA
Title DescriptionYou summon the alien creature with joy, thinking that you can become a Superman has the power to conquer all monsters, but facing the tall alien creature in front of you, you have a blank face, because, you know M78 Nebula language? But don't worry, because 0 Kawasaki is very witty, he gave a key hint: "Reason, Japanese is the universal language, so why not try to speak Japanese with aliens?" ”But now extraterrestrial creatures are saying "[Email protected]#$%^%#%i!......" Such
of the deceased's own age 5 years 4 12.9% 6 years old children 4 12.9% Adults 9 29.03% age unknown 3 9, Yichang website design. 68% Total 31 100% Multi-medium luxury sedan including Mercedes-Benz Cadillac Reporters take note that the vehicle involved is simply the disposition of relatively high-grade sedan, including Ben Zhang, BMW, Audi, Cadillac, Subaru and other flood-ho car. These vehicles are equipped with reversing radar. Vehicle brand or model of the accident Kaidi, Subaru, run, BMW, Aud
greater than 127th after the cancellation of the symbol, the stipulation: less than 127 character meaning is unchanged, that is, or the expression of English , but two more than 127 words connect prompt together, it represents a Chinese character, in other words, a Chinese character occupies two bytes , It can represent about 7,000 or more Simplified Chinese characters, and in these codes, mathematical symbols, Roman Greek letters, and Japanese kana
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.