downloads | documentation | faq | getting help | mailing lists | reporting bugs | php.net sites | links | my php.net 
search for in the  

<mysqli_server_initmysqli_set_opt>
Last updated: Sat, 29 Oct 2005

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.

Note: 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

Returns TRUE on success or FALSE on failure.

Examples

Example 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();
?>

Example 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);
?>

The above example will output:

Current character set: utf8


add a noteadd a note User Contributed Notes
mysqli_set_charset
There are no user contributed notes for this page.




<mysqli_server_initmysqli_set_opt>
Last updated: Sat, 29 Oct 2005
show source | credits | sitemap | contact | advertising | mirror sites
Copyright © 2001-2005 The PHP Group
All rights reserved.
This unofficial mirror is operated at: http://phpbuilder.com/
Last updated: Tue Nov 1 20:20:59 2005 EST
Columns / Articles | Tips / Quickies | News | News Linking and RSS Feeds | Shared Code Library
Mail Archives | Support / Discussion Forums | Get Started! Links | Contribute! | Docs