Didier Cabalé <[email protected]> wrote: > I would like to limit the data stored in my SQLite database only to > ASCII characters. For example, if a user tries to enter 'cabalé' (note > the 'e' with an accent), then it will be stored as 'cabale' (without > the accent) in the database. > How would you manage to get this, other than creating a transformation > routine with whatever external program?
I wouldn't - I would create a transformation routine in my application. There is nothing in SQLite that would be remotely helpful in this task. See also: http://blogs.msdn.com/michkap/archive/2005/02/19/376617.aspx http://blogs.msdn.com/michkap/archive/2007/05/14/2629747.aspx Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
