export and import users and database collation issue

Question

Hi , I have mambo 4.6.5 on my source site and joomla 1.5 on destination site. I'm going to move users from first one to second. so I install userport component on joomla 1.5 and then went to mambo database and select my users with this Query :

SELECT name, username, email, password FROM mos_users

and export them to a CSV file which is all "userport" needs. some of user's name are Persian and UTF-8 . as you see in below some of texts are disassemble due to UTF-8 unicode while they have shown correctly in Backend and frontend section of mambo. (mambo database)

The problems is here : when i import my users in joomla 1.5 via userport, the texts that seems disassemble in database (But shows correctly in mambo simultaneity !) ; are as when shows in mambo database and remain ill in joomla administrator : (joomla Administrator)

What's the solution?

Thanks

Answer 1

http://www.j2trip.com/html/y2009/10/import-users-into-joomla.html