unicode to database changes after form submit

[r4shyd]

hi im tryng to add data using html form to sql db

 

when i enter "ޖހދޖހސދ" dhivehi letters and submit the form that value is changed in the database to "Þ‡Þ¦Þ‡Þ¨Þަތު" this..

 

 

 

so what is wrong,

 

thanx

 

[gizmola]

Speaking in general terms, you want the character set to match across the board, from the browser to the client database connection to the database/column.

 

Your best bet is to use UTF8 for everything.

[r4shyd]

sorry,, what do you mean everything

 

html page

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

 

database

# Column Type Collation Attributes                       Null         Default

2 lname varchar(100) utf8_unicode_ci No         None   Change   Drop

 

 

 

 

thnks for the reply

[gizmola]

MySQL also has a client charset that in cases like this, often does not default to UTF-8.  For this reason many people build a call into their database class to set the client charset explicitly.  Many people do this by issuing this query just after they connect to the database:

 

SET NAMES UTF8

[r4shyd]

thank you very much for the help.