Getting EUC encoded data into/out of Joomla/mySQL
Posted: Sun May 27, 2007 8:13 am
I run a Joomla site. The backend database is all the default latin...swedish... encoding. However, the data is stored as Japanese EUC and everything displays correctly in Joomla. However, I have 2 problems:
1) I need to get the data out of mySQL. When I try to export the "content" table, everything turns to junk and it certainly doesn't maintain the encodings. I am trying to do this through phpMyAdmin.
2) I need to import a file into a database table. The file is an EUC encoded CVS file. In phpMyAdmin, I specify the import file as "CSV" encoding "Japanese EUC" and everything goes well. However, all the Japanese is turned into question marks.
What I really don't understand is why I can submit Japanese from an HTML page and have it store perfectly in mySQL, I can view the data perfectly via a web page, but I just can't seem to get anything out or in via phpMyAdmin.
Can someone clear this up and explain to me how to get data into/out of mySQL?
Thank you!
1) I need to get the data out of mySQL. When I try to export the "content" table, everything turns to junk and it certainly doesn't maintain the encodings. I am trying to do this through phpMyAdmin.
2) I need to import a file into a database table. The file is an EUC encoded CVS file. In phpMyAdmin, I specify the import file as "CSV" encoding "Japanese EUC" and everything goes well. However, all the Japanese is turned into question marks.
What I really don't understand is why I can submit Japanese from an HTML page and have it store perfectly in mySQL, I can view the data perfectly via a web page, but I just can't seem to get anything out or in via phpMyAdmin.
Can someone clear this up and explain to me how to get data into/out of mySQL?
Thank you!