Member Avatar for rejisha

Hi all,

I have a problem with the special characters. I can insert the special characters like ©,®,“ etc... into a database table. And it is successfully getting inserted into the table. But when i tried to retrieve it from the table it is converted into a symbol like ' � ' .

what can i do for retrieving the special characters from the db in its real form?

Can u help me?

Thanx a lot...

  • 2 Contributors
  • 3 Replies
  • 77 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by rejisha
Member Avatar for praveen_dusari

hi,

try to replace the @ symbol with html & # 64 ; using str_replace

Member Avatar for rejisha

sorry i didn't get you. my code is like this

$main_head="select str_head from tbl_head where int_id=$Id";
  $result_head=$obj->get_data($main_head);
   $heading=$result_head[0][0];
  echo $heading;

The variable $heading contains the symbol '�' instead of '©'
But in database the symbol '©' is getting inserted properly.

Member Avatar for rejisha

Sorry i don't have any problem with the symbol '@' .The problem is with the symbol of copyright '©' .

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.