unicode in SQLite and AIR

[Guest]

Hi guys

I want certain columns in my SQLite database to be able to accept unicode characters such as • and accented characters such as á. Is this possible in the SQLite version that AIR uses?

If so, what do I need to use when setting up my tables...

                                 "CREATE TABLE IF NOT EXISTS tester10 (" +

                                 "    id INTEGER PRIMARY KEY AUTOINCREMENT, " +

                                 "    Col1 NVARCHAR, " +

                                 "    Col2 NVARCHAR, " +

                                 "    Col3 NVARCHAR" +

                                   ")";

I thought NVARCHAR would do it, but it's entering the bullet point like: • and accented á like: Ái

Thanks for your help.

[Guest]

This may help ( http://www.sqlite.org/faq.html#q18 😞
quote:
"

(18) Case-insensitive matching of Unicode characters does not work.

The default configuration of SQLite only supports case-insensitive comparisons of ASCII characters. The reason for this is that doing full Unicode case-insensitive comparisons and case conversions requires tables and logic that would nearly double the size of the SQLite library. The SQLite developers reason that any application that needs full Unicode case support probably already has the necessary tables and functions and so SQLite should not take up space to duplicate this ability.

Instead of providing full Unicode case support by default, SQLite provides the ability to link against external Unicode comparison and conversion routines. The application can overload the built-in NOCASE collating sequence (using sqlite3_create_collation()) and the built-in like(), upper(), and lower() functions (using sqlite3_create_function()). The SQLite source code includes an "ICU" extension that does these overloads. Or, developers can write their own overloads based on their own Unicode-aware comparison routines already contained within their project.

"

[Guest]

Thanks mate. I learnt a bit from that.