Can't select database field that contains germen character like " ä "

[eluser]fivefinger-bd[/eluser]
Hello everybody,

I have a database field "AttributAusprägungsbeschreibung"

My sql is

Code:

$q = "select * from **** where AttributAusprägungsbeschreibung = 'Internet/Webdesign'";

But it returns this error


select * from **** where AttributAusprägungsbeschreibung = 'Internet/Webdesign'
A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* from **** where AttributAusprägungsbeschreibung = 'Inter' at line 2

SELECT * FROM (`select` * from **** where AttributAusprägungsbeschreibung = 'Internet/Webdesign')

Filename: C:\wamp\www\websitesvn\trunk\system\database\DB_driver.php

Line Number: 330




I have tested changing database collation and charset but can't solve this issue.

Any idea?
Please tell.

[eluser]fivefinger-bd[/eluser]
Hello everyone this is solved.

I put:

Code:

header('Content-type: text/html; charset=UTF-8');

Actually credit goes to @Doosje http://ellislab.com/forums/viewthread/77128/