Yes, that's what I have decided to do: I am going to trim off the trailing blank on the way into SQLite.
Thanks everyone, -- Joel Cochran On 3/27/07, John Stanton <[EMAIL PROTECTED]> wrote:
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] -----------------------------------------------------------------------------