Special Characters

rohitbansal

Team,

I am trying to use datatables to represent certain text. I am getting the correct response from DB as "Software Engineer - £20000 to £25000 per annum - Manchester" as input to datatables, but special characters are not getting displayed up as expected :

"Software Engineer - �20000 to �25000 per annum - Manchester"

How could I fix this up ?

JaroStei

Hi,

i had also the same problem. Me, i solved the problem with change of the page encoding. The problem is, what encoding you are using within the page, through you inserting data to db and which encoding is setup in the page which only display records from the db, also depends on the encoding which u r using in the database.

My problem was, that i was using windows-1250 encoding on the page, database is using iso-8859-2 and inserting data were done using ajax. Ajax uses defaultly utf-8, so any nonstandard characters were converted to some strange characters like yours. I only changed the encoding within the script where i get data from db to utf-8 and it displays all characters correctly.

So try to check what encoding u r using where and try to change it so, that everywhere u will use the same encoding or you can solve it using converting the data to the right encoding. Depends on your decision.