Tag:character set

  • Learning MySQL


    Basic concepts of database 1. English word of database: database, abbreviation: dB 2. What database? *A warehouse for storing and managing data. 3. Characteristics of database 1. Persistent storage of data. In fact, a database is a file system 2. Convenient storage and management of data 3. Using a unified way to operate the database […]

  • MySQL usage in Python


    MySQL usage in Python 1、 Precautions To view the system version: Arch command to check whether the system is 64 bit or 32-bit Check kernel version with cat / etc / system release Pay attention to the version of MySQL Enterprise Edition: pay Community Edition: Free MariaDB Pay attention to avoid updating the version of […]

  • Hand in hand teaching you to write regular expressions


    1. What is regular expression Regular expressions are used to retrieve text that conforms to certain patterns from text. Regular expressions match a string from left to right. englishRegular ExpressionWe usually use its abbreviation “regex” or “regexp”. Regular expressions can be used to replace text in a string, validate a form, extract a string from […]

  • Zhihu Interviewer: why not use UTF-8 in MySQL?


    Welcome WeChat search official account [java version web project] to obtain resources: java learning video / design mode notes / algorithm manual /java project I remember last year when I was saving Emoji expression to MySQL, I kept making mistakes and couldn’t import it. Later, I found a way to change utf8mb4 to utf8mb4. I […]

  • Create database table


    A series of articles: MySQL – getting to know MySQL Operation database Modify delete table Create database table Data management and DML statement of MySQL DQL (date query language) database query statement affair Indexes JDBC Database operation Database connection pool affair MySQL advanced optimization start Objective: to create a school databaseCreate student table (column, field)Student […]

  • Django — Django connecting to MySQL


    1Django connecting to MySQL If the project uses SQLite, it can be operated directly without additional configuration 2 Django links to MySQL by default. The driver is the mysqldb module. After Python 3. X, this module can’t be used any more. We all use pymysql and need to make a replacement 3 showmigrations: check which […]

  • Since then, I am confident that I can read and write regular expressions


    Why do we have to master it As a regular expression, it has the following advantages: concise Powerful Text processing saber Similarly, the disadvantages are obvious Difficult to read difficult to write Difficult to maintain Only for a small range Why do you want it You can’t get around it. You will encounter it in […]

  • Encoding of URL


    writeURLWhen theASCIICharacter set, it is a single byte character encoding scheme, a total of 128 characters, with a byte can be stored, such as charactersaIn binary, it can be expressed as01100001。 128 is not much, so ifURLContains nonASCIICharacters in a character set must be encoded. In addition, we also need toURLThe reserved and unsafe characters […]

  • Elder martial brother interview big factory met this mysql, almost came back with tears, younger martial brother helped to sort out the answer


    1、 Problem description [email protected] 22:12: [xucl]> show create table t1\G *************************** 1. row *************************** Table: t1 Create Table: CREATE TABLE `t1` ( `id` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 1 row in set (0.00 sec) [email protected] 22:19: [xucl]> select * from t1; | id | | 204027026112927605 | | 204027026112927603 | | 2040270261129276 | […]

  • Linux login prompt character set problem solution


    Character set error always exists locale: Cannot set LC_CTYPE to default locale: No such file or directory locale: Cannot set LC_MESSAGES to default locale: No such file or directory locale: Cannot set LC_ALL to default locale: No such file or directory background The company has a Jenkins server, which has been using CentOS 6.5 for […]

  • Technology sharing | MySQL 8.0: character set conversion from utf8 to utf8mb4


    Author: Hu Chengqing When collating MySQL 8.0 documents, a change was found: the default character set changed from Latin1 to utf8mb4. I remember that I have sorted out character set conversion documents before. After upgrading to MySQL 8.0, there is a great probability that there will be a need for character set conversion. I just […]

  • Two methods of HTML specifying page character set


    1. Two ways to specify page character set in HTML Method 1: <meta charset=”utf-8″> Method 2: <meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″> The above are two ways to set the character set of the page to UTF-8 (setting the page character set). The purpose is to tell the browser the character set of the HTML file. 2. […]