MySQL Forums :: PHP :: Storing Special Characters in Table

Advanced Search

Storing Special Characters in Table
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

Subject Written By Posted
Storing Special Characters in Table Muhammad Ummar Iqbal Bhutta 02/09/2009 03:45AM
Re: Storing Special Characters in Table Rick James 02/14/2009 12:10AM

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.