Which encoding must be used?

[Bag Kroud]

Hello,

I'm using nwnx4 with a MySql database.
In order to limit the number of access to the database, I've created stored procedure and functions.

I ve created a system where npc can reply sentences stored in database.

And here is my problem : I can't figure out which encoding I must use to store those sentences.
Sentences are stored in french so there's some é è ê...

Explanation :

The function I call take some parameters and one is : what the pc said.
If I watch the log xp_nwnx.txt, it seems that the input sentece is stored in utf8.
--> I've encode my fields in utf8_unicode_ci.

But! When I watch the output sentence, It seems to be encoded in latin1

Is there a way to specifie which encoding must be used in input and ouput ?

(I've tried to use methods like COLLATE, CHARSET in my function but it seems the problem reside in the parsing after the return of the function.)