Why not get a better database by stripping out the trailing spaces?
Joel Cochran wrote:
Hi Bob, always nice to meet a fellow Cochran!
This is DB2/400 for V5R1 of OS/400, and yes it is stored in EBCDIC. I am
using the IBM supplied .Net Managed Provider to read the data into a C#
program, (which I believe automatically converts it to ASCII) and then
using
the SQLite Managed Provider to insert the records into SQLite. The SQLite
version is the most recent (1.0.40?) and the platform is Windows. The data
file is then shipped to a Compact Framework application and is used on a
Windows Mobile device, so there is that platform as well.
Thanks,
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------