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".

or alternatively, for step 3:

Define specific columns to support the French locale.

Is the above sequence correct?

Thanks!

Bob Cochran


_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to