PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity.html
Consequently, the case sensitivity of the underlying operating system plays a part in the case sensitivity of database, table, and trigger names. This means such names are not case-sensitive in Windows, but are case-sensitive in most varieties of ...
https://dev.mysql.com/doc/refman/5.7/en/case-sensitivity.html
For binary strings (BINARY, VARBINARY, BLOB), comparisons use the numeric values of the bytes in the operands; this means that for alphabetic characters, comparisons are case-sensitive. The default character set and collation are latin1 and ... For ...
https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html
Boolean variables can be set at startup to the values ON, TRUE, OFF, and FALSE (not case-sensitive), as well as 1 and 0. For example, to prevent new MyISAM or FEDERATED tables from being created, start the server with these lines in the server ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-names.html
Collation suffixes indicate whether a collation is case-sensitive, accent-sensitive, or kana-sensitive (or some combination thereof), or binary. Table 10.1 Collation Suffix Meanings Suffix Meaning _ai Accent-insensitive _as Accent-sensitive _ci ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-information-schema.html
String columns in INFORMATION_SCHEMA tables have a collation of utf8_general_ci, which is case-insensitive. However, for values that correspond to objects that are represented in the file system, such as databases and tables, searches in ...This ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filter-definitions.html
For information about using JSON data in MySQL, see Section 11.5, “The JSON Data Type”. Filter definitions have this form, where actions indicates how filtering takes place: { "filter": actions } The following discussion describes permitted ...
https://dev.mysql.com/doc/refman/5.7/en/string-comparison-functions.html
Normally, if any expression in a string comparison is case-sensitive, the comparison is performed in case-sensitive fashion. Table 12.13 String Comparison Functions and Operators Name Description LIKE Simple pattern matching NOT LIKE Negation of ...
https://dev.mysql.com/doc/refman/5.7/en/extensions-to-ansi.html
This has a few implications: Database and table names are case-sensitive in MySQL Server on operating systems that have case-sensitive file names (such as most Unix systems). String comparisons are case-insensitive by default, with sort ordering ...
https://dev.mysql.com/doc/refman/5.7/en/json.html
Strings produced by converting JSON values have a character set of utf8mb4 and a collation of utf8mb4_bin: mysql> SELECT CHARSET(@j), COLLATION(@j); +-------------+---------------+ | CHARSET(@j) | COLLATION(@j) | +-------------+---------------+ | ...
https://dev.mysql.com/doc/refman/5.7/en/string-functions.html
mysql> SELECT INSTR('foobarbar', 'bar'); -> 4 mysql> SELECT INSTR('xbar', 'foobar'); -> 0 This function is multibyte safe, and is case-sensitive only if at least one argument is a binary string. mysql> SELECT LOCATE('bar', 'foobarbar'); -> 4 mysql> ...For functions that operate on string positions, the first position is numbered ...