FAQ-1061 Why do I get an KErrOverflow error when I try and insert more than 50 characters into an EDbColText field ?


FAQ-1061 Why do I get an KErrOverflow error when I try and insert more than 50 characters into an EDbColText field ?

» Symbian OS » Developer Knowledgebase » FAQ-1061

Classification:	C++	Category:	DBMS
Created:	05/27/2004	Modified:	05/27/2004
Number:	FAQ-1061
Platform:	ER5, Symbian OS v6.0, Symbian OS v6.1, Symbian OS v7.0, Symbian OS v7.0s, Symbian OS v8.0, Symbian OS v8.0a, Symbian OS v8.0b

Question:
The SDK documentation states that this database field can hold between 0-255 characters. Why is this failing ?

Answer:
Although 0-255 is defined as the minimum and maximum range for this field type, by default short text fields are limited to 50 characters.

To increase this limit, specify the limit when adding the field to CDbColSet. For instance to increase the limit to 100
characters use the following:

columns->AddL(TDbCol(KCol1, EDbColText, 100));