help me with windows-1256 from joomla

You may need to convert your database's character set before importing it into Drupal. I had a custom CMS site with a Latin1 Binary character set, and converted it to utf8 before importing, and it fixed the issue for me (it was a English site, however many users had posted special characters and foreign language into various comments, and those turned out the same as your example before I converted to utf8).

First dump a copy of your MySQL database... I used this command though I don't know if the extra parts had any necessary effect (they were just part of the various tips I read while researching the issue):
mysqldump -uusername -p --default-character-set=latin1 --skip-set-charset mydatabase > mydatabase.sql

Via shell/SSH, run iconv in order to translate the previous character set to utf8...
This command is for Latin (ISO-8859-1)... you may need to adjust for your Windows character set:

iconv -f ISO-8859-1 -t UTF-8 mydatabase.sql > mydatabase_utf8.sql

What you do after this depends on your situation... I'm supposing you might want to re-import this new UTF8 database into a new copy of your Joomla install (make sure your new database you import into is utf8_general_ci), which will now be ready for porting over to Drupal, by whatever means/tools you had in mind.

When you create your Drupal database, ensure that the character set is: utf8_general_ci

-- David
absolutecross.com

I recently converted someone's arabic PHPNuke site to Drupal and ran into the same problem. The problem was the original Nuke site (or Joomla) assumed the dataset was Latin1, and maped to the wrong character set when converting to UTF8. There are several ways to fix it depending whether you still have access to original database or just the SQL dump.

If you're using a script to do the conversion, just post it here and I could probably modify to make it work properly.

If you only have the dump, it may or may not have been dumped properly. If it was dumped as UTF8 the damage is already done, since mysql went ahead and converted to the wrong character set. If this is the case you have to convert it back to latin1 (using something like notepad++) before you can do anything further. You should preferably dump your database as 'binary'.