Question
Wordpress not linking properly to unicode image filenames
- Posted on November 4, 2013
Asked by vagios1988
Hi, I just migrated my Wordpress site to DO. I used an Ubuntu with preconfigured wordpress and transfered my files and my DB to the VPS. So far so good. I have this strange behavior: Filenames with unicode names (greek) do not link properly on website and eventually images do not show on site. Here are the facts:
- ssh into vps and ls shows filenames as ???.jpg
- performing ls | more shows filenames correclty! (So i assume that the original naming was not lost when transferring them)
- checking images from wordpress admin shows them as broken links.(they do not show)
- logging into to phpmyadmin and checking the corresponding tables (postmeta) shows the names in unicode.
- also, uploading one new image with unicode (greek) filename works OK… Any ideas?
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Want to learn more? Join the DigitalOcean Community!
Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.
Check out <a href=“https://www.digitalocean.com/community/articles/how-to-install-and-secure-phpmyadmin-on-ubuntu-12-04”>How To Install and Secure phpMyAdmin on Ubuntu 12.04</a>.
Well,I think problem might be the database… <br>Files do reside in the directories with the correct unicode filenames. <br>By using the url as it shows inside the WP admin i get <br>/wp-content/uploads/2013/10/Όλα-για-τη-μητÎÏα-μου.jpg was not found on this server <br>If I try to type the exact filename the image is shown correctly… <br>Any ideas? <br> <br>@Kamal Nasser: I changed the collation to utf8 but with no luck. How can I change the table locale that u are referring to?
Make sure the tables’ locales are set to utf8. Also set putty to use utf8.