I am very confused. I have a mysql table with band names in it. The band’s field is created like this:
band VARCHAR (150) character set utf8 collate utf8_bin.
It has always worked fine until this week, but I messed something up this weekend. Letters with accents show up as question marks in diamonds and Japanese characters are just plain question marks.
If I use utf8_encode() on the data then letters with accents display fine but Japanese characters still don’t.
The puzzling part is that if I take the data from the table, write it to an XML file and then display it on a page, everything looks perfect. Is that a good enough clue for anybody to tell me what I have done wrong? I would rather not use XML as a middleman all the time.
Edit: Fixed. The problem seems to be that I closed the connection to the database, and then I reopened it later in the code. Somehow that broke something. I don’t know how, but it’s fixed anyway.