581343 - Form field autosuggest works for Georgian small letter in, but not for capital letter in

Status: UNCONFIRMED

(Toolkit :: Form Manager, defect, P3)

Description

[Victor Engmark]

User-Agent:       Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.7) Gecko/20100715 Ubuntu/10.04 (lucid) Firefox/3.6.7
Build Identifier: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.7) Gecko/20100715 Ubuntu/10.04 (lucid) Firefox/3.6.7

During some Unicode testing of the Flickr search interface, I noticed that when pasting Unicode "Georgian small letter in" (U+2D08) it would suggest both itself and "Georgian capital letter in" (U+10A8), but not the other way round.

Reproducible: Always

Steps to Reproduce:
1. Submit the Flickr search form with only the Georgian small letter in.
2. Submit the Flickr search form with only the Georgian capital letter in.
3. Paste the Georgian capital letter in into the form.
Actual Results:  
No autosuggestions appear.

Expected Results:  
The autosuggest box below the input field should contain both the Georgian small letter in and the Georgian capital letter in.

Comment 1

[Matthew N. [:MattN]]

From a quick look, this may be caused by a combination of bug 394604 and/or a bug in SQLite's 'LIKE' operator:

"A bug: SQLite only understands upper/lower case for ASCII characters by default. The LIKE operator is case sensitive by default for unicode characters that are beyond the ASCII range." (http://www.sqlite.org/lang_expr.html)

"Ⴈ".toLowerCase()   => ი   (\u10D8)
"ი".toUpperCase()   => ი   (\u10D8)   (no change)

When I tested on Minefield, my result was that the Georgian capital letter result showed but the small letter did not.

Build:
Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6; rv:2.0b3pre) Gecko/20100728 Minefield/4.0b3pre