Help with Writing Unicode into MySQL via PHP

[Ira.Kovac]

Hello All,

I am trying to fix PHP code developed by somebody else and my
knowledge of PHP is very limited so I'd appreciate any help.

I have a MySQL database configured to accept UTF-8 in all fields.

When I update the database with Unicode via phpMyAdmin web interface I
am able to write and save unicode values in all fields.

However when i try to update the database via web I am not
successful.

For example, if I enter "�ćđšž" into the field I amupdating this will
be saved: "�ćđšž"

The code used to write into the db is as follows:
<?php
include('config.php');
include('adodb/adodb.inc.php');

if ($_REQUEST['v'] == $_REQUEST['verification']) {
$record = array(
'c_word_id' =$_REQUEST['word_id'],
'c_author_name' =$_REQUEST['name'],
'c_author_email' =$_REQUEST['email'],
'c_datetime' =strftime('%Y-%m-%d %H:%M:%S', strtotime('now')),
'c_text' =$_REQUEST['comment_text']
);

$db = NewADOConnection('mysql');
$db->Connect(DB_SERVER, DB_USER, DB_PASSWORD, DB_NAME);
$insertSQL = $db->AutoExecute('gim_comments', $record, 'INSERT');
You can see how the site behaves here: http://gimnazije.com/gimnazija_jagodina

Thanks!

Ira

[Michael Fesser]

..oO(Ir*******@gmail.com)

>I am trying to fix PHP code developed by somebody else and my
knowledge of PHP is very limited so I'd appreciate any help.

I have a MySQL database configured to accept UTF-8 in all fields.

When I update the database with Unicode via phpMyAdmin web interface I
am able to write and save unicode values in all fields.

However when i try to update the database via web I am not
successful.

For example, if I enter "???šž" into the field I am updating this will
be saved: "Ä?ćđšž"

The code used to write into the db is as follows:

Your very first query after establishing the connection to the DB should
be

SET NAMES 'utf8'

to set the transfer encoding. Without that your UTF-8 characters won't
make it into the DB properly.

Micha

[Ira.Kovac]

Micha - thanks, as you suggested mysql_query("set names 'utf8'"); did
the trick. I kept typing utf-8 for a while which was a mistake, it
seems that only utf8 works. Thanks again! Ira

[Peter H. Coffin]

On Wed, 4 Jun 2008 00:11:27 -0700 (PDT), Ir*******@gmail.com wrote:

Micha - thanks, as you suggested mysql_query("set names 'utf8'"); did
the trick. I kept typing utf-8 for a while which was a mistake, it
seems that only utf8 works. Thanks again! Ira

Yup, only "utf8" works (at least for now). You'll also want to
incorporate it into pretty much every call that may establish a new
connection. If you've a library of functions that you require_once for
every page that hooks up the databse, put it right after you're sure
you've got a connection that's properly signed in. if you've got
mysql_connect() calls scattered around, put a "SET NAMES utf8"
submission after every one.

--
78. I will not tell my Legions of Terror "And he must be taken alive!" The
command will be "And try to take him alive if it is reasonably practical."
--Peter Anspach's list of things to do as an Evil Overlord