Page 1 of 1

Greek language probelm

Posted: Fri Jan 09, 2009 7:34 am
by link2shahid
i have a problem with greek language. i want to display record from mysql table "Product" row [namegre]. for Example:here is Alaphabicts A | B | C | ........ | Z in (Greek)now i want to display just those items which start from B word. i.ei have three product in my tableA chairB chairC chair so the result might be (B chair) Another Problemi have another problem as well sometime the user insert the 1st letter of the word capital (Small chair) (small chair) means case sensitive. the problem comes when i want to list product with small c. the items which start from capital C not display. i will be so thanksfull if you can solve this problem. i am attaching the product files as well.thanks

Re: Greek language probelm

Posted: Sun Jan 11, 2009 3:43 pm
by jason.carter
See this -
http://dev.mysql.com/doc/refman/5.0/en/charset.html - Has a detailed documentation.

Try
SET NAMES 'greek';

You have to run this when you open a db connection. It will work for all the Greek queries for the duration of the connection.