MySQL List,
I have recently switched over from Windows to Ubuntu Linux, in order to
emulate as much as possible the environment I have on my web hosting
service. The goal is to be able to develop and test my web sites more
completely at home before uploading them.
I have successfully installed Apache, PHP, and MySQL (Most of which
came by default when installing Ubuntu). I'm comfortable writing PHP and
MySQL code in a web page, but I am very much a beginner in MySQL set up
and maintenance.
I have all the PHP and HTML files downloaded, and now my next step is
to copy the databases from my web hosting service to my home machine.
A lot of my database data is bilingual, English and Japanese. I try at
every turn to store and retrieve all data in UTF-8 format.
Using phpMyAdmin on my virtual hosting service, I exported my database
information to a text file, which I then opened on my local machine,
again through the phpMyAdmin interface.
It mostly worked. All the tables and their contents were inserted into
the home version of the database.
However, when viewing the web pages where content is dynamically called
from the database, all the Japanese text appears on my home machine as a
series of question marks.
So far as I know, I selected to use utf-8 encoding at every available
opportunity. I'm wondering if the problems came when saving to a plain
text file.
Can anyone recommend the best way to preserve text encoding methods
when copying a database from one machine to another?
Any advice is much appreciated.
Thank you.
--
Dave M G
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
