Hi Joel,
It's been a while since I've had to code DB2 and my memory might be
faulty. But the SQL standard says char(n) has to be padded with trailing
spaces, right? See this http://troels.arvin.dk/db/rdbms/
under the heading "The CHAR type".
Thanks
Bob Cochran
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]
-----------------------------------------------------------------------------
