I am working with PHP and use MySQL database for user data store in the database. All work is done well but when I enter Hebrew character in input text field then text character does not insert into the MySQL field.
It inserted into the table field ??? type of data or insert data is display סרט this type. How can I insert Hebrew characters in MySQL table. Please help me.
HI, I must help you ot insert Hebrew characters in your MySQL table.
Fisrt opent you MySQL table and GO to Structure option and click change option which field position you enter the Hebrew characters. Now see the collection option and click drop down and choose utf8_general_ci and click ok or outside. After choose utf8_general_ci in collection it will show a popup you need to confirm this popup.
Popup give you a message that’s like: “This operation will attempt to convert your data to the new collation. In rare cases, especially where a character doesn’t exist in the new collation, this process could cause the data to appear incorrectly under the new collation; in this case we suggest you revert to the original collation and refer to the tips at Garbled Data.
Are you sure you wish to change the collation and convert the data?”
Confirm it and try again to insert data will be inserted.
need steps then follow it:
Open MySQL table -> GO to Structure -> click change -> collection drop down -> choose utf8_general_ci ->confirm
DEFAULT CHARACTER SET utf8
COLLATE utf8_general_ci;