The following is the MySQL installation diagram, with the executable file installed, detailed description of a bit!
Open the download MySQL installation file mysql-5.0.27-win32.zip, double-click Decompression, run "Setup.exe", the following
MySQL will appear in Chinese garbled reasons are the following:1.server itself set the problem, for example still stay in Latin12.table language setting problem (including character and collation)3. Client program (for example, PHP) of the
In a Debian environment, completely solve the problem that MySQL cannot insert and display Chinese
Linux under MySQL insert Chinese display garbled solution
Mysql-uroot-p return Enter password
Enter the MySQL view status as follows:
The
Method/Step
Download the Appserv Windows Installer package and download the appserv-win32-2.5.9 installation
Click Appserv installation program, according to the prompts step-by-step operation can be.
Select the Appserv
2. Especially handy is, if you want to enter "", direct input "D", will be more convenient than the input "de". If you want to enter "Yes", enter "s" directly, and similarly if you want to enter "on", enter "sh" directly.
3. The words above, though
The printed font is static, and the page font is sleek and malleable. Designers must anticipate the end result of Cross-browser and end-user, not just learn how to achieve a particular visual appearance. In addition to mastering the simple rules,
If it is a Windows system, then the default local character set of the system is gb2312, and in order for the datasheet to use the gb2312 character set, we write the SQL statement that creates the datasheet:
Copy Code code as follows:
CREATE TABLE
One, data table
To ensure data integrity and consistency, you specify field names, field types, and field properties when you create a table, using constraints (constraint), indexes (index), primary keys (primary key), and foreign keys (Foregin key)
installed MySQL's default character set is Latin1, in order to change its character set to the user needs (such as UTF8), you must change its relevant configuration file; Because Linux under the MySQL default installation directory is distributed
MySQL under Linux database, table name, column name, alias rules:
1. Database name and table name are strictly case-sensitive;
2. The alias of the table is strictly case-sensitive;
3. Variable names are strictly case sensitive;
4. Column names
Do you have a headache for getting MySQL to change the character set? Don't worry, the following article will give you the correct solution, the following article is mainly introduced to get the MySQL change character set scheme, the following is
Usage: TR [options] ... SET1 [SET2]
Replaces, shrinks, and/or deletes characters from standard input and writes the results to standard output.
-C,-C,--complement first to complement SET1
-D,--delete deletes the contents of the matching SET1 and
From the famous three fingers of Mickey Mouse (when the character was moved to the screen in the 1920s, it was designed to save time so that only three fingers were drawn), to the simple "Simpsons", character design did not leave the main line to
Use simple spell
When we enter pinyin, we usually enter the complete pinyin of the words, that is, full spelling. You can also enter words by typing in the initials or initials, which is called simple spelling. Reasonable use of simple spelling
Can only say that I food, found on the internet did not find who explained their four differences, it can only own. The following is a MySQL client to see the help information, directly posted to explain it.
User:returns the current MySQL username
Regardless of which version of the MySQL client the client connects to the server, it is found that as long as the server side is set
After character-set-server = UTF8,
Character_set_client, Character_set_connection, Character_set_results
will
The statement is simple
The code is as follows
$connection =mysql_connect ("localhost", "root", "password"); Connect and select a database servermysql_select_db ("Test", $connection);$query = "SELECT * from users where
To do a website containing Vietnamese, users said that in the preservation of articles containing Vietnamese, msyql garbled, look at the following solutionI test myself, many characters become '? '。 The database connection is already using the
Q: How to solve the MySQL 5.0.16 garbled problem?
A: MySQL 5.0.16 garbled problem can be solved in the following way:
1. Set phpMyAdmin
Language:chinese Simplified (zh-utf-8)
MySQL Character Set: UTF-8 Unicode (UTF8)
MySQL Connection Proofing
I. Method 1
In MySQL, the sorting and searching of Chinese characters are wrong when they are sorted and searched. This situation exists in many versions of MySQL. If this problem is not resolved, then MySQL will not be able to actually handle
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.