android Sqlite text data type won't accept white spaces and special characters?

view story

http://stackoverflow.com – In my sql query table is created but value is not inserted this is my query, CREATE TABLE IF NOT EXISTS BpFullDirectory ( codeval integer primary key, name text, jobTypeName text, DOB text, cid text, countryCode text, countryId text, countryName text, email text, hobbies text, joinDate text, mobileApp text, mobileNumber text, nickname text, officeExtentionNumber text, officeNumber text, phoneModel text, socialMediaPlatform text, subName text, twitterHandle text, imagestring text, jobcategory text); -- and this is my insert tabl (HowTos)