Handle special characters

[eluser]manash007[/eluser]
i have submitted my form using ajax post method and it contains some special characters like ä,ö,ü,ß. But when it enter in databse it is not entering in right format not also in ä format. It enetrs as for ä the entry in database is ä . How can i solve this problem???
HELP............

[eluser]GSV Sleeper Service[/eluser]
change the Collation type in your database.

[eluser]manash007[/eluser]
The special characters are for German language. In which type i change my collation type. once i changed it into german2. but the result is same.

[eluser]hykoh[/eluser]
i dont use the CI db library,

but get the DB class on every __construct the following query

Code:

SET NAMES utf8

.. should help to get the data in the right format