Hello Joel, Why not strip the spaces before insertion?
C Monday, March 26, 2007, 4:36:02 PM, you wrote: JC> Howdy all, JC> I am new to SQLite, so I hope this isn't too much of a newbie question, but JC> I searched the Internet, the archives, and the help docs and could not find JC> any mention of this. JC> I am populating an SQLite database from a legacy IBM AS/400 database. The JC> 400 stores all character fields with padded blanks. As a result, when I JC> export the data the blanks remain. Normally this is not a problem, but I JC> noticed in SQLite when I do a select statement the MYFIELD = 'A' will not JC> work if the data is in fact 'A ' (a trailing blank). JC> SQLite apparently does not ignore trailing blanks on character matching like JC> other DBs do. Has anyone else experienced this, and if so what have you JC> done about it? I know I could rewrite the export routine to trim the JC> trailing blanks as they come out of the parent DB, but I was hoping there JC> may be another solution. If nothing else, maybe I can find one of you to JC> commiserate with! JC> Thanks, -- Best regards, Teg mailto:[EMAIL PROTECTED] ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
