"Michael Flum" <[EMAIL PROTECTED]> wrote: > I have a short program that requires storing of Ascii strings that > happen to be numbers. It seem that when I retrieve the data it has been > interrupted as a numeric value and is returned altered. I.E. "0E00" is > returned as "0", "0000" is returned as "0", "76E0" is returned as "76" > > SQL_Write( db, "CREATE TABLE P ( ENCODING INTEGER PRIMARY KEY UNIQUE, > ST STRING, EN STRING, SW STRING,DW STRING,BX STRING);" ); >
Use TEXT instead of STRING as the column datatype. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
