I have some longtext fields that contain some "special" characters (like bullets) and when I retreve the field with php and render it, it is fine. But if I export the DB and reimport it to another mysql DB, the bullets are ending up strange characters. What can I do to get the data exported and imported properly? I used mysqldump to export the data.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
export import character issue
- Thread starter btaber
- Start date
TonyGroves
Programmer
It looks like a character-set issue. Could it be that the target database is an older version than the source, and not able to handle wide characters?
- Status
Similar threads
- Locked
- Question