Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

In MySQL, what does this mean? /*!40100 DEFAULT CHARACTER SET latin1 */

Tags:

mysql

 /*!40100 DEFAULT CHARACTER SET latin1 */

  1. Why is it between comment marks?

  2. What is the 40100 all about?

  3. What is the ! for?

  4. What does it do?

  5. Where is the documentation for this?

like image 708
Tom Haws Avatar asked Feb 15 '12 17:02

Tom Haws

People also ask

What is default character set in MySQL?

The default MySQL server character set and collation are latin1 and latin1_swedish_ci , but you can specify character sets at the server, database, table, column, and string literal levels.

What is charset latin1 in MySQL?

The MySQL latin1 character set is such a one-byte character set for Western Europe, and it is the default character set of MySQL up to and including 5.7. In spite of the name, the character set is actually Windows-1252 compliant, which is a superset of ISO-8859-1, also known as Latin-1.

How do I change the default character set in MySQL?

The MySQL server has a compiled-in default character set and collation. To change these defaults, use the --character-set-server and --collation-server options when you start the server.

How do I change MySQL encoding to UTF 8?

To change the character set encoding to UTF-8 for the database itself, type the following command at the mysql> prompt. Replace dbname with the database name: Copy ALTER DATABASE dbname CHARACTER SET utf8 COLLATE utf8_general_ci; To exit the mysql program, type \q at the mysql> prompt.

1 Answers

  1. It's a conditional comment that can be interpreted by MySQL

  2. The code 40100 means only these versions of MySQL>=4.1.0 (4.01.00) will interpret the conditional comment.

  3. The ! is here to force MySQL to parse the code between the /* ... */

  4. It sets the value of the parameter DEFAULT CHARACTER = 'latin1' so that the data in an SQL dump can be intepreted correctly during import. It doesn't affect the database structure, but merely helps the export/import process to work right.

  5. http://dev.mysql.com/doc/refman/4.1/en/comments.html

like image 50
adrien54 Avatar answered Oct 01 '22 18:10

adrien54
Sign in to Comment

Related questions

What is difference between autoReconnect & autoReconnectForPools in MySql connector/J?
Counting rows from a subquery
SQLYog-Like MySQL GUI For Linux? [closed]
Connecting directly to Redis with (client side) javascript?
Understanding MySQL key_len in Explain Statement
Ruby on Rails MySQL #08S01Bad handshake - downgrade MySQL?
com.mysql.jdbc.PacketTooBigException
How to get phpmyadmin username and password
Should I add this new column to customers table or to a separate new table?
WAMP server. Very large data directory in MySQL?
How to set memory limit in my.cnf file [closed]
Do I need to add an Index on ORDER BY field?
Mysql Duplicate Rows ( Duplicate detected using 2 columns )
How to configure Tomcat to connect with MySQL
pcntl_fork and the MySQL connection is gone
Where is Percona's my.cnf file? [closed]
How to output text from database with line breaks in a django template?
How to increment a counter and return the value in MySQL
Allow user to create and alter table?
MySQL equivalent of Oracle's SEQUENCE.NEXTVAL

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!