On 3/26/07, Joel Cochran <[EMAIL PROTECTED]> wrote:
Howdy all,
I am new to SQLite, so I hope this isn't too much of a newbie question, but
I searched the Internet, the archives, and the help docs and could not find
any mention of this.
I am populating an SQLite database from a legacy IBM AS/400 database. The
400 stores all character fields with padded blanks. As a result, when I
export the data the blanks remain. Normally this is not a problem, but I
noticed in SQLite when I do a select statement the MYFIELD = 'A' will not
work if the data is in fact 'A ' (a trailing blank).
Try MYFIELD LIKE 'A%'
SQLite apparently does not ignore trailing blanks on character matching like
other DBs do.
I am not sure they do. I am speaking from memory, but I am pretty sure
that both SQL Server and Oracle don't just ignore blanks.
--
Puneet Kishor http://punkish.eidesis.org/
Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/
Open Source Geospatial Foundation http://www.osgeo.org/education/
---------------------------------------------------------------------
collaborate, communicate, compete
=====================================================================
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
