roddy Posted October 9, 2004 at 06:18 AM Report Share Posted October 9, 2004 at 06:18 AM . . . and other stuff I don't understand. I'm currently transferring a set of php scripts and a database from my laptop, where everything works perfectly, to webhosting. Uploaded the scripts no problem, did a local database dump in phpMyAdmin, copied and pasted it into the SQL query box in phpMyAdmin on the server, and it looks fine when I browse the tables. However, the output from the scripts is mangled - most of the letters with tones on are coming out as question marks. I'm assuming this is an encoding issue. Everything local is utf-8, including phpMyAdmin. On the server, the scripts are still outputting in utf-8 as they should, while phpMyAdmin is showing iso-8859-1 (I can't change this. The pinyin displays fine in phpMyAdmin). When I add stuff directly to the database, it all works fine. Using the scripts to add stuff is also fine. It seems to be only the database dump (simple text copy and paste, with the pinyin displaying fine) that's the problem. It's not a major issue, as it's a small database and reentering the data or something isn't too much hassle. I just have this vague idea that it'd be nice to understand what's happening . . . Roddy Quote Link to comment Share on other sites More sharing options...
roddy Posted October 9, 2004 at 07:06 AM Author Report Share Posted October 9, 2004 at 07:06 AM Ah, as is so often the case I solved the problem without truly understanding it. I set the phpMyAdmin encoding to UTF-8 under the View menu on my browser, did the database dump again and now it's fine. I wasn't expecting this to work, as I didn't think the encoding change would 'stick' for the form submission, but it did, and it's fine now. Roddy Quote Link to comment Share on other sites More sharing options...
geek_frappa Posted October 10, 2004 at 05:44 AM Report Share Posted October 10, 2004 at 05:44 AM hehe ... i'm glad you and roddy were able to figure things out. i've always said: two roddys (roddies) are better than one. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and select your username and password later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.