Even if I use:
SELECT upper('João') Like upper('JOÃO') as value
It returns false.
public function testLike():Boolean{
var stmt:SQLStatement = new SQLStatement();
stmt.sqlConnection = sqlConnection;
stmt.text = "SELECT upper('João') Like upper('JOÃO') as value";
stmt.execute();
var result:Array
I don't know your specific use case, but I just use lower() in my queries.
On 25 October 2013 18:19, Carlos Monteiro wrote:
> Hi,
>
> How do you get around the sqlite case sensitive bug?
>
> http://www.sqlite.org/lang_expr.html
> (A bug: SQLite only understands upper/lower case for ASCII chara
Hi,
How do you get around the sqlite case sensitive bug?
http://www.sqlite.org/lang_expr.html
(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. For example, the
