Storing Special Characters in Table
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..
Subject
Written By
Posted
Storing Special Characters in Table
February 09, 2009 03:45AM
February 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.