Thank you, I didn't understand that earlier. You saved me a lot of time!
Bob
On 10/18/13 10:30 PM, Igor Tandetnik wrote:
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.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
