Re: [PHP-DB] What effects MySQL connection's character set

2007-02-03 Thread Gunawan Wibisono
what i read.. i conclusion. whenever the data is.. is always latin1 right?? if the data seem give strange type (example like japanese font).. it will stay on latin1 or change into apropriate data On 2/1/07, Niel Archer <[EMAIL PROTECTED]> wrote: Hi all Finally identified the problem. Was pret

Re: [PHP-DB] What effects MySQL connection's character set

2007-01-31 Thread Niel Archer
Hi all Finally identified the problem. Was pretty obvious in retrospect. The mysqli class (Improved MySQL extension OO style) defaults to latin1 as a character set, regardless of what PHP is using. Simple solution is to use the set_charset method (mysqli_set_charset for non OO) on the object

Re: [PHP-DB] What effects MySQL connection's character set

2007-01-30 Thread Niel Archer
Hi > Thanks for this. That page didn't actually help, but one of the follow > ups did. Apparently, despite being setup as UTF-8 throughout the Db, > tables, and columns. The returned data still can default to Latin1. > I've forced my test server to return UTF-8 (I hope) and am trying it > ou

Re: [PHP-DB] What effects MySQL connection's character set

2007-01-30 Thread Niel Archer
Hi Chris. Thanks for this. That page didn't actually help, but one of the follow ups did. Apparently, despite being setup as UTF-8 throughout the Db, tables, and columns. The returned data still can default to Latin1. I've forced my test server to return UTF-8 (I hope) and am trying it out t

Re: [PHP-DB] What effects MySQL connection's character set

2007-01-29 Thread Chris
Niel Archer wrote: Hi all How is the character set of returned data effected? I have a DB using UTF-8 encoding., PHP is set to use UTF-8 internally. However the MySQL connection returns Latin1 data. How can I get it to return UTF-8 data instead. http://dev.mysql.com/doc/refman/4.1/en/charset

Re: [PHP-DB] What effects MySQL connection's character set

2007-01-26 Thread bedul
try to configure on the html.. i think on header.. - Original Message - From: "Niel Archer" <[EMAIL PROTECTED]> To: Sent: Saturday, January 27, 2007 3:12 AM Subject: [PHP-DB] What effects MySQL connection's character set > Hi all > > How is the character set of returned data effect