a LIKE problem ecc.

Hi! I use a query : SELECT * FROM Table1 WHERE name LIKE "K%" (K = Greek char = ASCII 137) but it selects also "k" (small K Greek) and "L" (Greek , ASCII 138) Why so and what I have to do? Something is in Apache setup? Also is there a way to print a counter at first row intead of ID (autoincrem

RE: a LIKE problem ecc.

, February 09, 2002 3:07 AM To: MySQL list (E-mail) Subject: a LIKE problem ecc. Hi! I use a query : SELECT * FROM Table1 WHERE name LIKE "K%" (K = Greek char = ASCII 137) but it selects also "k" (small K Greek) and "L" (Greek , ASCII 138) Why so and what I have

a LIKE problem ecc.

Hi! I use a query : SELECT * FROM Table1 WHERE name LIKE "K%" (K = Greek char = ASCII 137) but it selects also "k" (small K Greek) and "L" (Greek , ASCII 138) Why so and what I have to do? Something is in Apache setup? Also is there a way to print a counter at first row intead of ID (autoincrem