Rechercher dans le manuel MySQL
Search Results
https://dev.mysql.com/char.html
The CHAR and VARCHAR types are similar, but differ in the way they are stored and retrieved. The CHAR and VARCHAR types are declared with a length that indicates the maximum number of characters you want to store. The length of a CHAR column is ...
https://dev.mysql.com/column-count-limit.html
Storage requirements for some data types depend on factors such as storage engine, storage format, and character set. mysql> CREATE TABLE t (a VARCHAR(10000), b VARCHAR(10000), c VARCHAR(10000), d VARCHAR(10000), e VARCHAR(10000), f VARCHAR(10000), ... MySQL has hard limit of 4096 columns per table, but the effective maximum may be less for a given ...
https://dev.mysql.com/string-functions.html
ASCII(str) Returns the numeric value of the leftmost character of the string str. [USING charset_name]) CHAR() interprets each argument N as an integer and returns a string consisting of the characters given by the code values of those integers. For ...
https://dev.mysql.com/plugin-data-structures.html
The st_mysql_show_var structure has this definition: struct st_mysql_show_var { const char *name; char *value; enum enum_mysql_show_type type; }; The following table shows the permissible status variable type values and what the corresponding ... A ...
https://dev.mysql.com/writing-authentication-plugins.html
The structure definition, found in plugin_auth.h, looks like this: typedef struct st_mysql_server_auth_info { char *user_name; unsigned int user_name_length; const char *auth_string; unsigned long auth_string_length; char ... MySQL supports ...
https://dev.mysql.com/mysql-options.html
MYSQL_DEFAULT_AUTH (argument type: char *) The name of the authentication plugin to use. MYSQL_INIT_COMMAND (argument type: char *) SQL statement to execute when connecting to the MySQL server. MYSQL_OPT_BIND (argument: char *) The network interface ... int mysql_options(MYSQL *mysql, enum mysql_option option, const void *arg) Can be used to set extra connect options and affect behavior for a ...
https://dev.mysql.com/cast-functions.html
CONVERT() with a USING clause provides a way to convert data between different character sets: CONVERT(expr USING transcoding_name) In MySQL, transcoding names are the same as the corresponding character set names. If you omit CHARACTER SET ...
https://dev.mysql.com/faqs-cjk.html
What problems should I be aware of when working with the Big5 Chinese character set? A.11.4. Of what issues should I be aware when working with Korean character sets in MySQL? A.11.8. Why does my GUI front end or browser display CJK characters ...
https://dev.mysql.com/mysql-cluster-programs-ndb-restore.html
--fields-optionally-enclosed-by Property Value Command-Line Format --fields-optionally-enclosed-by Type String Default Value The string passed to this option is used to enclose column values containing character data (such as CHAR, VARCHAR, BINARY, ... The NDB Cluster restoration program is implemented as a separate command-line utility ndb_restore, which can normally be found in the MySQL bin ...
https://dev.mysql.com/c-api-prepared-statement-type-codes.html
For input string data, use MYSQL_TYPE_STRING or MYSQL_TYPE_BLOB depending on whether the value is a character (nonbinary) or binary string: MYSQL_TYPE_STRING indicates character input string data. The value is assumed to be in the character set ...
Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-fct-char-p-1.html
The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.
References
These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.
