0

I had all db connection with "old" mysql connection.. Now I changed to mysqli. Before all changes £ symbol was displayed from db properly now after I changed to mysqli connection it shows only a question mark. I changed collation for that column where £ symbol is - no changes. Any advices?

AlwaysConfused
  • 729
  • 2
  • 12
  • 37
  • Have you tried setting the character set to UTF-8 with mysqli_set_charset()? – Mattt Mar 26 '14 at 15:51
  • possible duplicate of [UTF-8 all the way through](http://stackoverflow.com/questions/279170/utf-8-all-the-way-through) and http://stackoverflow.com/questions/20237474/strange-character-encoding-of-stored-data-old-script-is-showing-them-fine-new – deceze Mar 26 '14 at 15:54
  • I set utf-8 in phpmyadmin I might try your suggestion – AlwaysConfused Mar 26 '14 at 15:54
  • @MattThompson nope,doesnt work – AlwaysConfused Mar 26 '14 at 15:57
  • There are multiple places where you have to set utf-8. And then there are multiple was of having your content in the wrong charset altogether. If your characters come out wrong, You HAVE wrong encoding in one of the many parts of your pipeline. Sad, but true. – ToBe Mar 26 '14 at 16:20
  • BTW, are you even sure your data is actually utf-8? Maybe it's something bad like Latin-1 or swedish. – ToBe Mar 26 '14 at 16:21
  • Well I did set to utf-8 with meta tags, I am not an expert for these things, I know that you can set a different charset in phpadmin.. How you can test ot out are you using utf-8 in your entire website? – AlwaysConfused Mar 27 '14 at 13:00

0 Answers0