Storing Special Characters in Table
Posted: Mon Feb 09, 2009 7:26 am
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..
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..