Crossplatform Director sqlite and flash don’t work well together

In fact the problem lies with director 2004 not being able to handle utf8.
I had to create 2 sqlite databases. MacRoman encoded for mac and iso-8859-1 for windows.
Fortunately it had a PHP-backend for filling the database, so converting was a piece of cake.
But still…….