Hello. > collation. PHP 4.4 doesn't provide API to work with > Connection Character Sets and Collations. PHP 5 adds
You can change the character_set_xxx variables using SQL queries. I usually put 'SET NAMES' at the beginning of my scripts. 立 周 wrote: > --- Gleb Paharenko <[EMAIL PROTECTED]>写道: > > >>Hello. >> >>From my experience PHP 4.4 works fine with MySQL >>4.1. >>What troubles are you getting while restoring utf8 >>database >>to the server? Please, could you explain more in >>detail all steps >>of the restoring process. Include information about >>database >>character set as well. >> >> > > > I think the problem is: the server is running mysqld > with latin chracter set and latin_swidish_ci collation > ( the default ). But my database is utf8 encoded ( > mainly Simplified Chinese ) with utf8_general_ci > collation. PHP 4.4 doesn't provide API to work with > Connection Character Sets and Collations. PHP 5 adds > this and you can also compile PHP 4.4 with mysqli ( > MySQL Improved ) extension to bring this API to PHP > 4.4. But on a shared hosting plan, i obviously have > no access to any of these solutions. > > Lionel > > > > > > > > ___________________________________________________________ > 雅虎1G免费邮箱百分百防垃圾信 > http://cn.mail.yahoo.com/ -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]