Greek language probelm

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
link2shahid
Forum Newbie
Posts: 1
Joined: Thu Dec 25, 2008 1:58 am

Greek language probelm

Post 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
jason.carter
Forum Commoner
Posts: 35
Joined: Sat Jan 10, 2009 10:05 am

Re: Greek language probelm

Post 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.
Post Reply