Searching problem using string contains umlaut(german)

[nineeshk]

I have a search query from my MSSQL database. My problem is when i search the database using the text string which contains any umlaut character.

FOr eg. When i search for Cömlek. It gives the following error..

Warning: sybase_query(): Sybase: Server message: Line 1: Incorrect syntax near ','. (severity 15, procedure N/A) in /home/search.php on line 28

Warning: sybase_query(): Sybase: Server message: Unclosed quotation mark before the character string '%C, FAX from test where comp_name'. (severity 15, procedure N/A) in /home/search.php on line 28

the actual query is :
............... ............... ............... ............... ...
$search = "Cömlek";

$query = "SELECT COMPANY_NAME, POSTAL_CODE, CITY, EMAIL, TEL1, FAX from test where LNAME LIKE '%$search%' ".
............... ............... ............... ............... ........
pls help me.

regards,
nk