Re: Unable to duplicate a database at home, possible encoding problem

2006-02-15 Thread mel list_php
o: mel list_php <[EMAIL PROTECTED]> CC: mysql@lists.mysql.com Subject: Re: Unable to duplicate a database at home, possible encoding problem Date: Wed, 15 Feb 2006 11:44:41 +0900 The precise instructions are here: http://dev.mysql.com/doc/refman/5.0/en/charset-syntax.html ...but if it is yo

Re: Unable to duplicate a database at home, possible encoding problem

2006-02-14 Thread Dave M G
The precise instructions are here: http://dev.mysql.com/doc/refman/5.0/en/charset-syntax.html ...but if it is your local home installation you could also recompile mysql specifying utf8 when you run configure. Thank you for the very helpful advice. I understand what it is you're saying I can

Re: Unable to duplicate a database at home, possible encoding problem

2006-02-14 Thread 古雷
ry 15, 2006 1:54 AM Subject: Re: Unable to duplicate a database at home, possible encoding problem > >> detailed info here: >> http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html > > > Thank you for that link. I think this is the heart of the issue. > &g

Re: Unable to duplicate a database at home, possible encoding problem

2006-02-14 Thread mel list_php
TED]> To: mysql@lists.mysql.com Subject: Re: Unable to duplicate a database at home, possible encoding problem Date: Wed, 15 Feb 2006 02:54:00 +0900 detailed info here: http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html Thank you for that link. I think this is the heart o

Re: Unable to duplicate a database at home, possible encoding problem

2006-02-14 Thread Dave M G
detailed info here: http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html Thank you for that link. I think this is the heart of the issue. Following the advice on the web page, I ran these commands: SET NAMES utf8; SET CHARACTER_SET utf8; But I can check my MySQL system variables i

Re: Unable to duplicate a database at home, possible encoding problem

2006-02-13 Thread mel list_php
your queries. detailed info here: http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html I think the second user comment may also be helpful. hth, melanie From: Dave M G <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Subject: Re: Unable to duplicate a database at home, possible enco

Re: Unable to duplicate a database at home, possible encoding problem

2006-02-13 Thread Dave M G
MySQL List, With the off list help of a member of this community, I have solved the issue of accessing my database data from within PHP. It was an issue related to PHP's register_globals setting. However, the encoding issue remains. I've taken the text that pertains only to that, and r

Unable to duplicate a database at home, possible encoding problem

2006-02-12 Thread Dave M G
MySQL list, I'm afraid this explanation is a bit long, but hopefully it's clear and concise. A while back I reported having troubles copying a database from my hosting service to my home machine. One of the problems I encountered was that I had some table columns named "group", wh