• 首页
  • vue
  • TypeScript
  • JavaScript
  • scss
  • css3
  • html5
  • php
  • MySQL
  • redis
  • jQuery
  • mysqli::character_set_name()

    (PHP 5, PHP 7)

    返回当前数据库连接的默认字符编码

    说明

    面向对象风格
    mysqli::character_set_name(void): string
    过程化风格
    mysqli_character_set_name(mysqli$link): string

    返回当前数据库连接的默认字符编码。

    参数

    $link

    仅以过程化样式:由mysqli_connect()或mysqli_init()返回的链接标识。

    返回值

    The default character set for the current connection

    范例

    Example #1 mysqli::character_set_name() example

    面向对象风格

    <?php
    /* Open a connection */
    $mysqli = new mysqli("localhost", "my_user", "my_password", "world");
    /* check connection */
    if (mysqli_connect_errno()) {
        printf("Connect failed: %s\n", mysqli_connect_error());
        exit();
    }
    /* Print current character set */
    $charset = $mysqli->character_set_name();
    printf ("Current character set is %s\n", $charset);
    $mysqli->close();
    ?>
    

    过程化风格

    <?php
    /* Open a connection */
    $link = mysqli_connect("localhost", "my_user", "my_password", "world");
    /* check connection */
    if (!$link) {
        printf("Connect failed: %s\n", mysqli_connect_error());
        exit();
    }
    /* Print current character set */
    $charset = mysqli_character_set_name($link);
    printf ("Current character set is %s\n",$charset);
    /* close connection */
    mysqli_close($link);
    ?>
    

    以上例程会输出:

    Current character set is latin1_swedish_ci
    

    参见

    • mysqli_set_charset() 设置默认字符编码
    • mysqli_client_encoding()mysqli_character_set_name 的别名
    • mysqli_real_escape_string() 根据当前连接的字符集,对于 SQL 语句中的特殊字符进行转义