Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-java-8.html
Connector/J 8.0 and beyond is created specifically to run on the Java 8 platform. While Java 8 is known to be strongly compatible with earlier Java versions, incompatibilities do exist, and code designed to work on Java 7 might need to be adjusted ...
https://dev.mysql.com/doc/connector-j/en/connector-j-query-attributes.html
Connector/J supports Query Attributes when it has been enabled on the server by installing the query_attributes component (see Prerequisites for Using Query Attributes for details). Attributes are set for a query by using the setAttribute() method ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-spring-config-jdbctemplate.html
Spring makes extensive use of the Template method design pattern (see Template Method Pattern). Our immediate focus will be on the JdbcTemplate and related classes, specifically NamedParameterJdbcTemplate. The template classes handle obtaining and ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-setting.html
Examples include all DDL (data definition language) statements such as CREATE TABLE, ALTER TABLE, or DROP TABLE. You can select the binary logging format explicitly by starting the MySQL server with --binlog-format=type. The supported values for ...
https://dev.mysql.com/doc/refman/8.4/en/binary-varbinary.html
The BINARY and VARBINARY types are similar to CHAR and VARCHAR, except that they store binary strings rather than nonbinary strings. This means they have the binary character set and collation, and comparison and sorting are based on the numeric ...
https://dev.mysql.com/doc/refman/8.4/en/case-sensitivity.html
For nonbinary strings (CHAR, VARCHAR, TEXT), string searches use the collation of the comparison operands. For binary strings (BINARY, VARBINARY, BLOB), comparisons use the numeric values of the bytes in the operands; this means that for alphabetic ...
https://dev.mysql.com/doc/refman/8.4/en/case.html
(The indentation used here in the ELSE clause is for purposes of clarity only, and is not otherwise significant.) DELIMITER | CREATE PROCEDURE p() BEGIN DECLARE v INT DEFAULT 1; CASE v WHEN 2 THEN SELECT v; WHEN 3 THEN SELECT 0; ELSE BEGIN END; END ... CASE case_value WHEN when_value THEN statement_list [WHEN when_value THEN statement_list] ...
https://dev.mysql.com/doc/refman/8.4/en/charset-binary-collations.html
This section describes how the binary collation for binary strings compares to _bin collations for nonbinary strings. Binary strings (as stored using the BINARY, VARBINARY, and BLOB data types) have a character set and collation named binary.
https://dev.mysql.com/doc/refman/8.4/en/charset-collation-names.html
For Unicode character sets, the xxx_general_mysql500_ci collations preserve the pre-5.1.24 ordering of the original xxx_general_ci collations and permit upgrades for tables created before MySQL 5.1.24 (Bug #27877). MySQL collation names follow ...
https://dev.mysql.com/doc/refman/8.4/en/charset-conversion.html
If you specified attributes when creating a column initially, you should also specify them when altering the table with ALTER TABLE. To convert a binary or nonbinary string column to use a particular character set, use ALTER TABLE. For successful ...