How can add and retrieve special characters like “ in mysql

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
vcodeinfotec
Forum Newbie
Posts: 10
Joined: Sat Jul 12, 2008 2:08 am

How can add and retrieve special characters like “ in mysql

Post by vcodeinfotec »

Hi all,

I am trying to to insert special characters like ’ ‚ „ “ – into MySQL database. But after editing this record it shows ? on the place of these characters. How can I manage these issues..

Please help me..
User avatar
jaoudestudios
DevNet Resident
Posts: 1483
Joined: Wed Jun 18, 2008 8:32 am
Location: Surrey

Re: How can add and retrieve special characters like “ in mysql

Post by jaoudestudios »

All characters should be encode before they go into the database.

Copy and post them into here and it will show you the encoded version that you need to insert into the database.
http://www.forum.jaoudestudios.com/view ... ?f=13&t=24

The php function that you need is htmlentities.
User avatar
jaoudestudios
DevNet Resident
Posts: 1483
Joined: Wed Jun 18, 2008 8:32 am
Location: Surrey

Re: How can add and retrieve special characters like “ in mysql

Post by jaoudestudios »

Post Reply