SWFObject and German text issue

[pixilliontom]

Hey,

I'm having a weird problem with swfobject and german text. I'm dynamically creating the swfobject code which includes vars from a database which are german text. I then echo the swfobject code to the screen.

I have it working in dutch but in German in there is an umlaut or other special character then swfobject no longer loads the flash. The really weird thing is that the data for these vars is stored in a UTF-8 encoded DB and looks perfect in the database. If I go into the DB and edit an entry and do NOTHING but click save, it makes everything magically work. It's clearly an encoding issue but I can't for the like of me work out where. Data in the DB looks fine, data in the swf object code (when printed to screen) looks fine, and when the flash works it looks fine...it just doesn't work until I resave the entry in the database...

Anyone got any bright ideas as to what might be causing this?

Cheers,

Tom

[jsebrech]

Probably loading and saving the entry causes the encoding to change (from ansi to utf-8 or the other way around). You should double-check you're dealing with utf-8 all the way through.