mysqli_set_charset

(PHP 5 >= 5.1.0RC1)

mysqli_set_charset

(no version information, might be only in CVS)

mysqli->set_charset -- Sets the default client character set

Description

bool mysqli_set_charset ( mysqli link, string charset )

The mysqli_set_charset() function sets the default character set (specified by the charset parameter) to be used when sending data from and to the database server represented by the link parameter.

Opmerking: To use this function on a Windows platform you need MySQL client library version 4.1.11 or above (for MySQL 5.0 you need 5.0.6 or above)

Return Values

Geeft TRUE terug bij succes, FALSE indien er een fout is opgetreden.

Zie ook

mysqli_character_set_name() and mysqli_real_escape_string().

Voorbeelden

Voorbeeld 1. Object oriented style

<?php
$mysqli
= new mysqli("localhost", "my_user", "my_password", "test");

/* check connection */
if (mysqli_connect_errno()) {
    
printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}

/* change character set to utf8 */
if (!$mysqli->set_charset("utf8")) {
    
printf("Error loading character set utf8: %s\n", $mysqli->error);
} else {
    
printf("Current character set: %s\n", $mysqli->character_set_name());
}

$mysqli->close();
?>

Voorbeeld 2. Procedural style

<?php
$link
= mysqli_connect('localhost', 'my_user', 'my_password', 'test');

/* check connection */
if (mysqli_connect_errno()) {
    
printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}

/* change character set to utf8 */
if (!mysqli_set_charset($link, "utf8")) {
    
printf("Error loading character set utf8: %s\n", mysqli_error($link));
} else {
    
printf("Current character set: %s\n", mysqli_character_set_name($link));
}

mysqli_close($link);
?>

Het resultaat van dit script is als volgt:

Current character set: utf8