mySQL BETWEEN, Not inclusive Options

[Dag]

Why operator BETWEEN doesn't return the last data group?

CODE

    $sql = "SELECT * FROM $tbl WHERE `data` BETWEEN 'R' and 'Z'";

Z data are not loaded. If I use NOT BETWEEN A and R - then I see them.

Means, first letter IS included and last NOT.

Thanks in advance.

[Dag]

Back to subject. We are not talking about local rules but about multilingual / international DB and sorting way. I'll not learn each single language or countri rulez to push something to work on the propper way. A after Z - it's ok if u are working in DK and making their local DB. But if u r doing that what I am doing (and not only me), then each variation of A with any diacritical mark will be before Z )