MySQL Forums
Forum List  »  PHP

Storing Special Characters in Table
Posted by: Muhammad Ummar Iqbal Bhutta
Date: February 09, 2009 03:45AM

Hi all!
I am having provlem storing special characters in to Database table.. I have a table named messages having following structure

MESSAGE_ID bigint(20)
Catagory_ID int(11)
Message text

The table Collation is "utf8_unicode_ci" and also the Message field's collation is "utf8_unicode_ci", but when I store a Message e.g.

but when I store any special character in Message field like “ and ` they are stored like %20xx etc etc.. and being displayed on HTML as %20xx etc.. whcih doesn't seem good.. Please help me out. how to solve this problem.. My Table storage engine is "InnoDB".. Please I need quick help..

Options: ReplyQuote

Written By
Storing Special Characters in Table
February 09, 2009 03:45AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.