[TYPO3] direct db insert and typo3 db charset problem

[Amiran Chyb]

Hi guys


I'm migrating thousands of news articles from legacy site (ez publish).  
After some structural transformations, I inserted this data to tt_news.  
After that I noticed that new data looks ok in phpMyAdmin (non-european  
chars display correctly), but display wrong in FE.
Then I found that news records inserted by typo DON'T display correctly in  
DB (FE is in UTF, and DB's default charset is LATIN2).
So I shouldn't set it up with DB in mind, but rather thinking about DB->FE  
conversion.

Do you have any idea what should I do with dump file before inserting to  
typodb to simulate transformations that happen, when utf FE inserts data  
to latin2 charset? I've tried converting dump file to utf with iconv, but  
display in FE is still wrong.


thanks
Am