Re: select first letters

[nikos]

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