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