View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Improvement to accept 'text' format for huge comments and so on - ProjeQtOr
 

Improvement to accept 'text' format for huge comments and so on

More
06 Aug 2014 17:37 #1 by Jean-Luc
Improvement to accept 'text' format for huge comments and so on was created by Jean-Luc
At now, all description an comment fileds are defined as 'varchar(4000)'. That is too short (I had to import text until >32k chars).

So I added some lines in ./view/objetctDetail.php (between lines 380 and 381)
from
(…)
			$dataLength = $obj->getDataLength($col);
			//echo $col . "/" . $dataType . "/" . $dataLength;
			if ($dataLength) {
(…)
to
(…)
			$dataLength = $obj->getDataLength($col);
			//echo $col . "/" . $dataType . "/" . $dataLength;
			if ($dataType=='text')
				$dataLength = 65535 ;
			else if ($dataType=='mediumtext')
				$dataLength = 16777215 ;
			if ($dataLength) {
(…)
This change allows to change any field format from 'varchar(4000)' to 'text' or 'medium text', the second one offering until several millions characters for texts.

Very easy to apply, and doesn't cost anything !

(At now, I have several fields added or so altered, and a lot of lines containing texts with more than ten thousand characters. All works fine !)

Please Log in or Create an account to join the conversation.

More
13 Aug 2014 16:51 #2 by babynus
Replied by babynus on topic Improvement to accept 'text' format for huge comments and so on
Thanks for the proposal.
I recorded a ticket for this purpose.

Nb :
1) not sure to implement it in onjectDatail.php, possibly better to do this directly in SqlElement::getDatalength()
2) Will have to check the impact on PostgreSql
Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

Moderators: babynus, protion
Time to create page: 0.029 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.

Login Form