0

I have a problem with umlauts and ampersands.

Basically in the database I have a varchar field with content

Umlauts äøää

Is it possible to select this field, but in the same query convert it to something more readable? It should be somehing like 

SELECT  myfield as address 
from `table`

And it should show 

  Address
  Umlauts ü ä

I was wondering if it's possible? Thank you very much hope this makes sense

  • Are you storing your data in a UTF8 column? Are you using the UTF8 charset for your web pages? – Wayne Whitty Nov 07 '14 at 10:11
  • It's currently stored as latin1_swedish_ci , would storing as utf8_general_ci help? I'm not too sure about charset for the webpage because it's basically an API which calls my database directly –  Nov 07 '14 at 10:15
  • Try: utf8_unicode_ci. Also make sure that you are using a UTF8 header on the page that you are outputting your data. – Wayne Whitty Nov 07 '14 at 10:16
  • I've tried what you have suggested however it didn't help.Thanks anyway –  Nov 07 '14 at 10:33
  • http://stackoverflow.com/questions/3678980/is-there-a-mysql-function-to-decode-html-entities – al_kash Nov 07 '14 at 13:25

0 Answers0