> I can't seem to find any information on the web site. Would any person > have some information on how to change the default collation, this would > be extremely useful.
Unfortunately you can't change the default collation. You can set an individual column to compare using a case insensitive collation function by adding 'COLLATE NOCASE' to it's definition. http://www.sqlite.org/lang_createtable.html __________________________________ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/
