How do make your SQL requests ? Using SPIP abstact SQL layer or directly in PHP ?
I suppose this is from another database, independent from the regular installation.
I would recommend you, to use the SPIP loop system, that could simplify the job, and solve your charset problem (or not !).
Did you read this page, and the following ones ?
IRC #spip on freenode.net