Hello.
>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. You should localize the problem. Check with the text editor that files, which you have got from phpMyAdmin really contain data in UTF8 encoding. Do not use phpAdmin until you completely understand what's going on. Use mysql command line client to import your databases. After you have done the import, check with some client that the data in MySQL is still correct and in UTF8 (use GUIs like MySQL Query Browser in case your terminal doesn't support unicode, and you can't use mysql command line client). Check the settings of you server with: show variables like '%char%'; statement. Read: http://dev.mysql.com/doc/refman/5.0/en/charset.html Dave M G wrote: > 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 > > -- 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]
