Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:19618
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
To: internals@lists.php.net
Reply-To: scuzzy@reverseorder.net
Date: Fri, 14 Oct 2005 13:47:59 +0100
Message-ID: <20051014123957.M42347@reverseorder.net>
MIME-Version: 1.0
Content-Type: multipart/mixed;
	boundary="----=OPENWEBMAIL_ATT_0.704166704629646"
Subject: patch to make mysql select correct encoding on client libraries.
From: scuzzy@reverseorder.net ("scuzzy")

------=OPENWEBMAIL_ATT_0.704166704629646
Content-Type: text/plain;
	charset=utf-8

Hi,
I've attached a patch, that will allow people to be able to change the client
default encoding type, as this was not possible before. I looked through the
php mysql client source, and found no traces of something that could actually
set the default client encoding type.
basically mysql_options(&myHadle, MYSQL_SET_CHARSET_NAME, "utf8"); or whatever
charset you choose.
It reads the option from the php.ini file, which I've also patched to include
the line required, but is commented by default. 
When it's commented, it falls back to the mysql client library default of latin1.
I've read a few forums, and this is apparently a common problem, and I just
thought I'd lend a hand to help you guys out. I'm sure you get inundated with
stuff like this all the time.
Anyway. Take a look at the patch, it's really simple, but it helped us out as
a company quite a lot. (www.complinet.com)
I hope it helps.
Thanks
Daine Mamacos.


--
random signature

------=OPENWEBMAIL_ATT_0.704166704629646--