This content has been marked as final. Show 9 replies
Whats the collation of your database?
Try to put some static text on your page to be sure that you page is in Unicode.
You can also try to activate BOM support for your template.
And also do not trust most of the MySQL clients. There would be problem while connecting database and you may think that data in database is not correct. I use personally Navicat to connect my MySQL DB.
Okay, I pasted Téstïñg on my page and got question marks where Unicode characters should have appeared, so apparently my page isn't in Unicode. I can see the display properly on this page in my browser so what do I have to do to make this available on my output page?
I'm still unsure why this works but I've found a solution. I switched all my pages over to character set ISO-8859-1 with the exception of my database table and it works. I get all the normal range character along with the extended Unicode characters to write to the database and output correctly. Unicode characters actually write to the table as their HTML coded character.
If someone feels the need to enlighten me as to why this works please feel free, I'm always willing to learn.
I've got exactly the same problem but with CF8 and MS Access. Set up the site and everything to UTF-8. And the page won't display the characters I need (which is Vietnamese). But they are saved correctly in the database.... Does anybody has a real solution for this - I mean setting the charset on all pages to ISO-8859-1 or whatever doesn't make any sense to me. I want to use UTF-8.
> I've got exactly the same problem but with CF8 and MS Access. Set up the site
and are you using the "access for unicode" driver?
Your are the best. I didn't think of that and made a test with vietnamese and arab characters and everything works just perfect!!!!!!!