On 10/18/2013 9:32 PM, Bob Cochran wrote:
I want to create a table like this:
glosskey of type text
caption_text of type varchar or text
The glosskey and caption_text both need to contain French language text.
To accomplish this, I think I need to take the following steps:
1. Compile and install the International Components for Unicode (ICU)
library ( http://site.icu-project.org/ ).
2. Compile the SQLite amalgamation with the SQLITE_ENABLE_ICU option.
3. Define the table so that it supports the French locale. I guess this
is the IANA language subtag "fr".
You only need all that if you want text in these columns to be sorted
using French collation. You don't need to do anything special just to
have SQLite store characters used in French, or indeed any Unicode
characters.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
