Exception thrown with SQLite result from Column with NULL value

Question

when selecting a column that can contains a NULL value I get an exception thrown on this statement.

self.DirectionFromCity = [NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement, 8)];

How should I go about setting these attributes as NULL values are OK for the Database.

Liam · Accepted Answer · 2010-03-10 12:41:40Z

3

As per docs NSString throws an exception if the bytes are null

What you need to do is check the returned value and only create the string if it is not null

char *localityChars = sqlite3_column_text(compiledStatement, 8);

if (localityChars == nil) {
     self.DirectionFromCity = nil;
} else {
     self.DirectionFromCity = [NSString stringWithUTF8String: localityChars];
}

In response to the comment below re code growing with the extra checking, you can shrink it down using

self.DirectionFromCity = localityChars != nil?[NSString stringWithUTF8String: localityChars]:nil;

or push it out to a method that will do the same functionality

self.DirectionFromCity = [self getSQLiteColumn:compiledStatement];

edited Mar 10, 2010 at 12:41

answered Mar 10, 2010 at 9:52

Liam

8,1224 gold badges29 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

MB. Over a year ago

Thanks, Ouch... I have 35 columns that can contain NULL this will add a lot of overhead to the app......

Liam Over a year ago

The overhead will be quite small, the only real difference is the 'if' block

MB. Over a year ago

Thanks Again, I am concerned about both app performance and the size of the code neat solutions

Collectives™ on Stack Overflow

Exception thrown with SQLite result from Column with NULL value

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related