Welcome! Log In Create A New Profile

Database

Posted by 47641789

Announcements		Last Post
	SoC Curricula	09/30/2017 01:08PM
	Demarcation or scoping of examinations and assessment	02/13/2017 07:59AM
	School of Computing Short Learning Programmes	11/24/2014 08:37AM
	Unisa contact information	07/28/2011 01:28PM

Forums Messages New

47641789

Database
October 14, 2013 06:16PM

Registered: 10 years ago
Posts: 4
Rating: 0

is it okay if i modify the table fields TYPE from name(VARCHAR) to name(TEXT), because with VARCHAR i get wrong values, if i enter a record into a field with a TYPE (VARCHAR) it cancel everything after a space if my record contain a space, e.g if i enter "Nkele Thumbuni" only Nkele will be entered into the database, but with a TYPE(TEXT) the whole string "Nkele Thumbuni" is being entered into the database.

Reply Quote

bigron11

Re: Database
October 14, 2013 08:11PM

Admin
Registered: 11 years ago
Posts: 6,606
Rating: 396

VARCHAR only removes trailing spaces, it should accept strings with spaces.
There is possibly a problem with the way your SQL query is structured.

On a pedantic note - you cannot enter a record into a field. A record is made up of fields.