I must have misunderstood, then. I thought the Greek characters were more than one byte.
Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -----Original Message----- > From: nikos [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 25, 2007 12:15 PM > To: Jerry Schwartz; mysql@lists.mysql.com > Subject: Re: select first letters > > Finaly I use ord(). > Thank you. > > Jerry Schwartz wrote: > > The multi-byte extension doesn't seem to include one, but > it appears > > that somebody put one together and posted it in the notes on chr(). > > > > http://us2.php.net/manual/en/function.chr.php#69082 > > > > Regards, > > > > Jerry Schwartz > > Global Information Incorporated > > 195 Farmington Ave. > > Farmington, CT 06032 > > > > 860.674.8796 / FAX: 860.674.8341 > > > > > > > -------------------------------------------------------------- > ---------- > > *From:* nikos [mailto:[EMAIL PROTECTED] > > *Sent:* Wednesday, April 25, 2007 11:41 AM > > *To:* Jerry Schwartz; mysql@lists.mysql.com > > *Subject:* Re: select first letters > > > > Jerry do you know if there is a php command that returns ascci > > number of a letter? > > I'll want to use chr() command because I want to > transfer via link > > the letter to next page but greek characters transformed to > > something like "%CE%9C". > > Thank you > > > > Jerry Schwartz wrote: > >> It would depend upon the collating sequence for the field. > >> > >> Regards, > >> > >> Jerry Schwartz > >> Global Information Incorporated > >> 195 Farmington Ave. > >> Farmington, CT 06032 > >> > >> 860.674.8796 / FAX: 860.674.8341 > >> > >> > >> > >>> -----Original Message----- > >>> From: nikos [mailto:[EMAIL PROTECTED] > >>> Sent: Wednesday, April 25, 2007 10:07 AM > >>> To: Dus(an Pavlica; mysql@lists.mysql.com > >>> Subject: Re: select first letters > >>> > >>> Seems that work in v. 4.1.21 > >>> but not in 5.0.27 > >>> > >>> Thank you Dusan > >>> > >>> Dus(an Pavlica wrote: > >>> > >>>> I'm not sure, but I think that greek characters are > sorted after > >>>> English chars so try this: > >>>> > >>>> SELECT DISTINCT LEFT(title,1) FROM odigos_details WHERE > >>>> > >>> LEFT(title,1) > >>> > >>>>> 'z' ORDER BY title > >>>>> > >>>> HTH, > >>>> Dusan > >>>> > >>>> nikos napsal(a): > >>>> > >>>>> Hello list. > >>>>> I want to select discinct the first letters of titles in a > >>>>> > >>> UTF8 table > >>> > >>>>> but only the greek ones. > >>>>> There are both english and greek charakter titles. > >>>>> How can I exclude the english from selection? > >>>>> > >>>>> My table is: > >>>>> > >>>>> CREATE TABLE `odigos_details` ( > >>>>> `id` int(11) NOT NULL auto_increment, > >>>>> `cat` tinyint(3) default NULL, > >>>>> `territory` tinyint(3) default NULL, > >>>>> `title` varchar(150) default NULL, > >>>>> `story` text, > >>>>> `link` varchar(100) default NULL, > >>>>> `address` varchar(150) default NULL, > >>>>> `tel` varchar(50) default NULL, > >>>>> `fax` varchar(11) default NULL, > >>>>> `photo` varchar(100) default NULL, > >>>>> PRIMARY KEY (`id`) > >>>>> ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 > >>>>> > >>>>> and I run: > >>>>> > >>>>> SELECT DISTINCT LEFT(title,1) FROM odigos_details > ORDER BY title > >>>>> > >>>>> witch is working fine. > >>>>> > >>>>> Thank you. > >>>>> Nikos > >>>>> > >>>>> > >> > >> > >> > >> > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
