Greetings,

maybe it's just me being stupid, I'll best jump right to the code:

sqlite3_open_v2( "testdat", &sqlDB, SQLITE_OPEN_READWRITE | 
SQLITE_OPEN_CREATE, NULL );
sqlite3_prepare_v2( sqlDB, "SELECT b FROM whee WHERE a='bing';", -1, 
&sqlStat, NULL );
sqlite3_step( sqlStat );
const unsigned char *testValue = sqlite3_column_text( sqlStat, 0 );

both a and b are varchar(20)s

calling the query from the command-line tool returns the proper result "bang", 
however, running this code the value testValue shows up as ""
for longer strings only the first four characters are corrupted, and the rest 
reads okay, what am I doing wrong?

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to