Dave, what is the result of
prompt> set | grep LANG ? I suspect your problem is not within MySQL. Did you look at your testfile using a editor? Thomas Spahni On Wed, 4 Jan 2006, 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]