Unicode

[Peter Haworth]

Interesting, thanks Mark.

In case any database developers are interested, it seems that the SQLite
upper() and lower() functions only work with ASCII characters as does
COLLATE NOCASE so at least Livecode is ahead of SQLite.  It is possible to
write your own collation handlers for SQLite but wouldn't have any idea
where to start with something like that.

I often use COLLATE NOCASE along with a UNIQUE constraint in my databases
to guarantee the uniqueness of a column's values no matter what case; I
guess I'll have to be sure no non-ASCII language users are involved in the
future!

Pete
lcSQL Software <http://www.lcsql.com>
Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>

On Wed, May 6, 2015 at 12:42 AM, Mark Waddingham <mark at livecode.com> wrote:

> On 2015-05-06 01:53, Peter Haworth wrote:
>
>> Right, this is where I get confused on the issue of whether there are
>> uppercase equivalents of all lowercase glyphs in all languages.  The link
>> you provided sheds light on this
>>
>
> The Greek alphabet does have upper and lower case variants. However, in
> the case of typing 'qwerty' and 'QWERTY' using a Greek keyboard layout then
> you get the strings:
>   qwerty = ;ςερτυ
> and
>   QWERTY = :΅ΕΡΤΥ
>
> Which (by virtue of the punctuation and the terminal sigma on q and w) are
> definitely not the same when compared caselessly ;)
>
> Mark.
>
> i.e. Don't assume that shift-<letter> gives you an uppercase version of
> <letter> in any keyboard layout.
>
> --
> Mark Waddingham ~ mark at livecode.com ~ http://www.livecode.com/
> LiveCode: Everyone can create apps
>
>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>