MySQL truncates my insert in if it has more than 256 chars

When I try to run an insert in the prompt command of mysql, the value
of my column "Distribution" is truncated in the 256 position. It has
about 500 caracters but just 256 are inserted

mysql version
---------------------
/usr/local/mysql5/bin/mysql Ver 14.12 Distrib 5.0.51a, for redhat-
linux-gnu (i686) using EditLine wrapper

Linux version
---------------------
Linux bms65 2.4.18-14
Red Hat Linux release 8.0 (Psyche)

Table description (Just the column with problem)
--------------------------------
| Distribution | tinytext | NO | | NULL
| |

insert command
--------------------------
insert into conteudosituations set (.... other columns here)

Distribution='Primary:ACE016:NT,Primary:ACE017:NT, Primary:ACE022:NT,Primary:ACE023:NT,Primary:ACE025 :NT,Primary:ACE029:NT,Primary:ACE031:NT,Primary:AC E032:NT,Primary:ACE033:NT,Primary:ACE036:NT,Primar y:ACE037:NT,Primary:ACE041:NT,Primary:ACE042:NT,Pr imary:ACE043:NT,Primary:ACE047:NT,Primary:ACE053:N T,Primary:ACE080:NT,Primary:ACE085:NT,Primary:ACE0 86:NT,Primary:ACE094:NT,Primary:ACE099:NT,Primary: ACE11ARQ1:NT,Primary:ACE12ARQ1:NT,Primary:ACE13ARQ 1:NT,Primary:ACE1ARQ1:NT,Primary:ACE1BD2:NT,Primar y:ACE1BD3:NT,Primary:ACE1BD4:NT,Primary:ACE1BD6:NT ,Primary:ACE1CSG1:NT,Primary:ACE1CTX2:NT,Primary:A CE1NOT10:NT,Primary:ACE1NOT1:NT,Primary:ACE1NOT2:N T,Primary:ACE1NOT3:NT,Primary:ACE1NOT5:NT,Primary: ACE1NOT7:NT,Primary:ACE1NOT9:NT,Primary:ACE1SIP2:N T,Primary:ACE1SIP4:NT,Primary:ACE2ARQ1:NT,Primary: ACE2SIP1:NT,Primary:ACE3SIP1:NT,Primary:ACE3SIP2:N T,Primary:ACE4SIP1:NT,Primary:ACE4SIP2:NT,Primary: ACE6SIP1:NT,Primary:ACE7NOT1:NT,Primary:ACE8BD2:NT ,Primary:ACE8NOT1:NT,Primary:ACINDAR02:NT,Primary: ACINDAR07:NT,Primary:ACINDAR09:NT,Primary:ACINDAR1 02:NT,Primary:ACINDAR104:NT,Primary:ACINDAR10:NT,P rimary:ACINDAR12:NT,Primary:ACINDAR151:NT,Primary: ACINDAR154:NT,Primary:ACINDAR158:NT,Primary:ACINDA R159:NT,Primary:ACINDAR15:NT,Primary:ACINDAR163:NT ,Primary:ACINDAR164:NT,Primary:ACINDAR167:NT,Prima ry:ACINDAR168:NT,Primary:ACINDAR16:NT,Primary:ACIN DAR171:NT,Primary:ACINDAR172:NT,Primary:ACINDAR205 :NT,Primary:ACINDAR21:NT,Primary:ACINDAR24:NT,Prim ary:ACINDAR26:NT,Primary:ACINDAR28:NT,Primary:ACIN DAR29:NT,Primary:ACINDAR30:NT,Primary:ACINDAR31:NT ,Primary:ACINDAR34:NT,Primary:ACINDAR35:NT,Primary :ACINDAR36:NT,Primary:ACINDAR40:NT,Primary:ACINDAR 44:NT,Primary:ACINDAR45:NT,Primary:ACINDAR46:NT,Pr imary:ACINDAR47:NT,Primary:ACINDAR49:NT,Primary:AC INDAR50:NT,Primary:ACINDAR52:NT,Primary:ACINDAR53: NT,Primary:ACINDAR56:NT,Primary:ACINDAR58:NT,Prima ry:ACINDAR59:NT,Primary:ACINDAR65:NT,Primary:ACIND AR66:NT,Primary:ACINDAR69:NT,Primary:ACINDAR704:NT ,Primary:ACINDAR70:NT,Primary:ACINDAR71:NT,Primary :ACINDAR72:NT,Primary:ACINDAR73:NT,Primary:ACINDAR 74:NT,Primary:ACINDAR75:NT,Primary:ACINDAR77:NT,Pr imary:ACINDAR78:NT,Primary:ACINDAR79:NT,Primary:AC INDAR801:NT,Primary:ACINDAR81:NT,Primary:ACINDAR82 :NT,Primary:ACINDAR83:NT,Primary:ACINDAR84:NT,Prim ary:ARC002:NT,Primary:ARC045:NT,Primary:BBA01:NT,P rimary:BBA02:NT,Primary:BBA0300:NT,Primary:BBA0301 :NT,Primary:BBA0302:NT,Primary:BBA0303:NT,Primary: BBA03:NT,Primary:BBA0400:NT,Primary:BBA0401:NT,Pri mary:BBA0402:NT,Primary:BBA0403:NT,Primary:BBA0500 :NT,Primary:BBA0501:NT,Primary:BBA0502:NT,Primary: BBA0503:NT,Primary:BBA05:NT,Primary:BBA07:NT,Prima ry:BBA08:NT,Primary:BBA09:NT,Primary:BBA11:NT,Prim ary:BBA12:NT,Primary:BBA13:NT,Primary:BBA16:NT,Pri mary:BBA17:NT,Primary:BBA18:NT,Primary:BBA201:NT,P rimary:BBA20:NT,Primary:BBA21:NT,Primary:BBA22:NT, Primary:BBA251:NT,Primary:BBA25:NT,Primary:BBA26:N T,Primary:BBA27:NT,Primary:BBA45:NT,Primary:BMB01: NT,Primary:BMB02:NT,Primary:BMB03:NT,Primary:BMB05 :NT,Primary:BMB11:NT,Primary:BMBA03:NT,Primary:BMF 01:NT,Primary:BMF02:NT,Primary:BMS05:NT,Primary:BM S100:NT,Primary:BMS101:NT,Primary:BMS109:NT,Primar y:BMS114:NT,Primary:BMS116:NT,Primary:BMS153:NT,Pr imary:BMS154:NT,Primary:BMS159:NT,Primary:BMS162:N T,Primary:BMS163:NT,Primary:BMS164:NT,Primary:BMS1 65:NT,Primary:BMS166:NT,Primary:BMS167:NT,Primary: BMS170:NT,Primary:BMS171:NT,Primary:BMS173:NT,Prim ary:BMS175:NT,Primary:BMS176:NT,Primary:BMS177:NT, Primary:BMS178:NT,Primary:BMS181:NT,Primary:BMS188 :NT,Primary:BMS189:NT,Primary:BMS18:NT,Primary:BMS 200A:NT,Primary:BMS200C:NT,Primary:BMS200X:NT,Prim ary:BMS200Y:NT,Primary:BMS20:NT,Primary:BMS25:NT,P rimary:BMS27:NT,Primary:BMS302:NT,Primary:BMS304:N T,Primary:BMS311:NT,Primary:BMS314:NT,Primary:BMS3 18:NT,Primary:BMS320R:NT,Primary:BMS324:NT,Primary :BMS325:NT,Primary:BMS327:NT,Primary:BMS328:NT,Pri mary:BMS32:NT,Primary:BMS34:NT,Primary:BMS36:NT,Pr imary:BMS38:NT,Primary:BMS403:NT,Primary:BMS404:NT ,Primary:BMS408:NT,Primary:BMS415:NT,Primary:BMS42 3:NT,Primary:BMS43:NT,Primary:BMS46:NT,Primary:BMS 501:NT,Primary:BMS502:NT,Primary:BMS507:NT,Primary :BMS508:NT,Primary:BMS513:NT,Primary:BMS601:NT,Pri mary:BMS602:NT,Primary:BMS606:NT,Primary:BMS62:NT, Primary:BMS63:NT,Primary:BMS66:NT,Primary:BMS73:NT ,Primary:BMS80:NT,Primary:BMS82:NT,Primary:BMS83:N T,Primary:BMS91:NT,Primary:BMS92:NT,Primary:BMS_NT PROD:NT,Primary:CA:NT,Primary:CR00001:NT,Primary:C R00002:NT,Primary:CSBM0004:NT,Primary:CSBM0009:NT, Primary:CSBM0012:NT,Primary:CSBM0015:NT,Primary:CS BM0021:NT,Primary:CSBM0101:NT,Primary:CSBM0102:NT, Primary:CSBM0103:NT,Primary:CSBM0109:NT,Primary:CS BM0110:NT,Primary:CSBM0111:NT,Primary:CSBM0112:NT, Primary:CSBM0113:NT,Primary:CSBM0116:NT,Primary:CS BM0120:NT,Primary:CSBM0121:NT,Primary:CSBM0126:NT, Primary:CSBM0131:NT,Primary:CSBM0132:NT,Primary:CS BM0141:NT,Primary:CSBM0142:NT,Primary:CSBM0143:NT, Primary:CSBM0145:NT,Primary:CSBM0146:NT,Primary:CS BM0147:NT,Primary:CSBM0149:NT,Primary:CSBM0151:NT, Primary:CSBM0153:NT,Primary:CSBM0155:NT,Primary:CS BM0156:NT,Primary:CSBM0158:NT,Primary:CSBM0161:NT, Primary:CSBM0163:NT,Primary:CSBM0164:NT,Primary:CS BM0400:NT,Primary:CSBM0401:NT,Primary:CSBM0402:NT, Primary:CSBM0403:NT,Primary:CSBM1101:NT,Primary:CS BM1102:NT,Primary:CSBM1103:NT,Primary:CSBM1110:NT, Primary:CSBM1111:NT,Primary:CSBM1120:NT,Primary:CS BM1121:NT,Primary:CSBM1141:NT,Primary:CSBM1142:NT, Primary:CSBM1145:NT,Primary:CSBM1146:NT,Primary:CS BM1201:NT,Primary:CSBM1203:NT,Primary:CSBM1301:NT, Primary:CSBM1308:NT,Primary:CSBM132:NT,Primary:CSB M1401:NT,Primary:CSBM1403:NT,Primary:CSBM1501:NT,P rimary:CSBM1601:NT,Primary:CSBM2101:NT,Primary:CSB M2102:NT,Primary:CSBM2103:NT,Primary:CSBM2110:NT,P rimary:CSBM2111:NT,Primary:CSBM2120:NT,Primary:CSB M2121:NT,Primary:CSBM2141:NT,Primary:CSBM2142:NT,P rimary:CSBM2144:NT,Primary:CSBM2145:NT,Primary:CSB M2146:NT,Primary:CSBM3101:NT,Primary:CSBM3102:NT,P rimary:CSBM3103:NT,Primary:CSBM3110:NT,Primary:CSB M3111:NT,Primary:CSBM3120:NT,Primary:CSBM3121:NT,P rimary:CSBM3141:NT,Primary:CSBM3142:NT,Primary:CSB M3144:NT,Primary:CSBM3145:NT,Primary:CSBM3146:NT,P rimary:CSBM3148:NT,Primary:CSBM4110:NT,Primary:CSB M4111:NT,Primary:CSBM4112:NT,Primary:CSBM4113:NT,P rimary:CSBM4115:NT,Primary:CSBM4120:NT,Primary:CSB M4121:NT,Primary:CSBM4124:NT,Primary:CSBM4125:NT,P rimary:CSBM4141:NT,Primary:CSBM4142:NT,Primary:CSB M4143:NT,Primary:CSBM4145:NT,Primary:CSBM4146:NT,P rimary:CSBM6101:NT,Primary:CSBM6103:NT,Primary:CSB M62:NT,Primary:CSBM7101:NT,Primary:CSBM7103:NT,Pri mary:CSBM7131:NT,Primary:CSBM83:NT,Primary:CSBM910 1:NT,Primary:CSBM9102:NT,Primary:CSBM9103:NT,Prima ry:CSBM9108:NT,Primary:DITREF02:NT,Primary:SASV000 3:NT,Primary:SASV0004:NT,Primary:VCNTFX:NT,Primary :VDS001:NT,Primary:VDS002:NT,Primary:VDS007:NT,Pri mary:VDS008:NT,Primary:VDS010:NT,Primary:VDS011:NT ,Primary:VDS018:NT,Primary:VDS031:NT,Primary:VDS03 2:NT,Primary:VDS041:NT,Primary:VDS042:NT,Primary:V DS044:NT,Primary:VDS045:NT,Primary:VDS047:NT,Prima ry:VDS048:NT,Primary:VDS060:NT,Primary:VDS061:NT,P rimary:VDS062:NT',




Why is it truncation my Distribution column since it is a tinetext?
--
Leo

leoh wrote:
> When I try to run an insert in the prompt command of mysql, the value
> of my column "Distribution" is truncated in the 256 position. It has
> about 500 caracters but just 256 are inserted
>
> mysql version
> ---------------------
> /usr/local/mysql5/bin/mysql Ver 14.12 Distrib 5.0.51a, for redhat-
> linux-gnu (i686) using EditLine wrapper
>
> Linux version
> ---------------------
> Linux bms65 2.4.18-14
> Red Hat Linux release 8.0 (Psyche)
>
> Table description (Just the column with problem)
> --------------------------------
> | Distribution | tinytext | NO | | NULL
> | |
>
> insert command
> --------------------------
> insert into conteudosituations set (.... other columns here)
>
> Distribution='Primary:ACE016:NT,Primary:ACE017:NT, Primary:ACE022:NT,Primary:ACE023:NT,Primary:ACE025 :NT,Primary:ACE029:NT,Primary:ACE031:NT,Primary:AC E032:NT,Primary:ACE033:NT,Primary:ACE036:NT,Primar y:ACE037:NT,Primary:ACE041:NT,Primary:ACE042:NT,Pr imary:ACE043:NT,Primary:ACE047:NT,Primary:ACE053:N T,Primary:ACE080:NT,Primary:ACE085:NT,Primary:ACE0 86:NT,Primary:ACE094:NT,Primary:ACE099:NT,Primary: ACE11ARQ1:NT,Primary:ACE12ARQ1:NT,Primary:ACE13ARQ 1:NT,Primary:ACE1ARQ1:NT,Primary:ACE1BD2:NT,Primar y:ACE1BD3:NT,Primary:ACE1BD4:NT,Primary:ACE1BD6:NT ,Primary:ACE1CSG1:NT,Primary:ACE1CTX2:NT,Primary:A CE1NOT10:NT,Primary:ACE1NOT1:NT,Primary:ACE1NOT2:N T,Primary:ACE1NOT3:NT,Primary:ACE1NOT5:NT,Primary: ACE1NOT7:NT,Primary:ACE1NOT9:NT,Primary:ACE1SIP2:N T,Primary:ACE1SIP4:NT,Primary:ACE2ARQ1:NT,Primary: ACE2SIP1:NT,Primary:ACE3SIP1:NT,Primary:ACE3SIP2:N T,Primary:ACE4SIP1:NT,Primary:ACE4SIP2:NT,Primary: ACE6SIP1:NT,Primary:ACE7NOT1:NT,Primary:ACE8BD2:NT ,Primary:ACE8NOT1:NT,Primary:ACINDAR0
2:NT,Primary:ACINDAR07:NT,Primary:ACINDAR09:NT,Pri mary:ACINDAR102:NT,Primary:ACINDAR104:NT,Primary:A CINDAR10:NT,Primary:ACINDAR12:NT,Primary:ACINDAR15 1:NT,Primary:ACINDAR154:NT,Primary:ACINDAR158:NT,P rimary:ACINDAR159:NT,Primary:ACINDAR15:NT,Primary: ACINDAR163:NT,Primary:ACINDAR164:NT,Primary:ACINDA R167:NT,Primary:ACINDAR168:NT,Primary:ACINDAR16:NT ,Primary:ACINDAR171:NT,Primary:ACINDAR172:NT,Prima ry:ACINDAR205:NT,Primary:ACINDAR21:NT,Primary:ACIN DAR24:NT,Primary:ACINDAR26:NT,Primary:ACINDAR28:NT ,Primary:ACINDAR29:NT,Primary:ACINDAR30:NT,Primary :ACINDAR31:NT,Primary:ACINDAR34:NT,Primary:ACINDAR 35:NT,Primary:ACINDAR36:NT,Primary:ACINDAR40:NT,Pr imary:ACINDAR44:NT,Primary:ACINDAR45:NT,Primary:AC INDAR46:NT,Primary:ACINDAR47:NT,Primary:ACINDAR49: NT,Primary:ACINDAR50:NT,Primary:ACINDAR52:NT,Prima ry:ACINDAR53:NT,Primary:ACINDAR56:NT,Primary:ACIND AR58:NT,Primary:ACINDAR59:NT,Primary:ACINDAR65:NT, Primary:ACINDAR66:NT,Primary:ACINDAR69:NT,Primary: ACINDAR704:NT,Primary:ACINDAR70:NT,Prima
ry:ACINDAR71:NT,Primary:ACINDAR72:NT,Primary:ACIND AR73:NT,Primary:ACINDAR74:NT,Primary:ACINDAR75:NT, Primary:ACINDAR77:NT,Primary:ACINDAR78:NT,Primary: ACINDAR79:NT,Primary:ACINDAR801:NT,Primary:ACINDAR 81:NT,Primary:ACINDAR82:NT,Primary:ACINDAR83:NT,Pr imary:ACINDAR84:NT,Primary:ARC002:NT,Primary:ARC04 5:NT,Primary:BBA01:NT,Primary:BBA02:NT,Primary:BBA 0300:NT,Primary:BBA0301:NT,Primary:BBA0302:NT,Prim ary:BBA0303:NT,Primary:BBA03:NT,Primary:BBA0400:NT ,Primary:BBA0401:NT,Primary:BBA0402:NT,Primary:BBA 0403:NT,Primary:BBA0500:NT,Primary:BBA0501:NT,Prim ary:BBA0502:NT,Primary:BBA0503:NT,Primary:BBA05:NT ,Primary:BBA07:NT,Primary:BBA08:NT,Primary:BBA09:N T,Primary:BBA11:NT,Primary:BBA12:NT,Primary:BBA13: NT,Primary:BBA16:NT,Primary:BBA17:NT,Primary:BBA18 :NT,Primary:BBA201:NT,Primary:BBA20:NT,Primary:BBA 21:NT,Primary:BBA22:NT,Primary:BBA251:NT,Primary:B BA25:NT,Primary:BBA26:NT,Primary:BBA27:NT,Primary: BBA45:NT,Primary:BMB01:NT,Primary:BMB02:NT,Primary :BMB03:NT,Primary:BMB05:NT,Primary:BMB11
:NT,Primary:BMBA03:NT,Primary:BMF01:NT,Primary:BMF 02:NT,Primary:BMS05:NT,Primary:BMS100:NT,Primary:B MS101:NT,Primary:BMS109:NT,Primary:BMS114:NT,Prima ry:BMS116:NT,Primary:BMS153:NT,Primary:BMS154:NT,P rimary:BMS159:NT,Primary:BMS162:NT,Primary:BMS163: NT,Primary:BMS164:NT,Primary:BMS165:NT,Primary:BMS 166:NT,Primary:BMS167:NT,Primary:BMS170:NT,Primary :BMS171:NT,Primary:BMS173:NT,Primary:BMS175:NT,Pri mary:BMS176:NT,Primary:BMS177:NT,Primary:BMS178:NT ,Primary:BMS181:NT,Primary:BMS188:NT,Primary:BMS18 9:NT,Primary:BMS18:NT,Primary:BMS200A:NT,Primary:B MS200C:NT,Primary:BMS200X:NT,Primary:BMS200Y:NT,Pr imary:BMS20:NT,Primary:BMS25:NT,Primary:BMS27:NT,P rimary:BMS302:NT,Primary:BMS304:NT,Primary:BMS311: NT,Primary:BMS314:NT,Primary:BMS318:NT,Primary:BMS 320R:NT,Primary:BMS324:NT,Primary:BMS325:NT,Primar y:BMS327:NT,Primary:BMS328:NT,Primary:BMS32:NT,Pri mary:BMS34:NT,Primary:BMS36:NT,Primary:BMS38:NT,Pr imary:BMS403:NT,Primary:BMS404:NT,Primary:BMS408:N T,Primary:BMS415:NT,Primary:BMS423:NT,Pr
imary:BMS43:NT,Primary:BMS46:NT,Primary:BMS501:NT, Primary:BMS502:NT,Primary:BMS507:NT,Primary:BMS508 :NT,Primary:BMS513:NT,Primary:BMS601:NT,Primary:BM S602:NT,Primary:BMS606:NT,Primary:BMS62:NT,Primary :BMS63:NT,Primary:BMS66:NT,Primary:BMS73:NT,Primar y:BMS80:NT,Primary:BMS82:NT,Primary:BMS83:NT,Prima ry:BMS91:NT,Primary:BMS92:NT,Primary:BMS_NTPROD:NT ,Primary:CA:NT,Primary:CR00001:NT,Primary:CR00002: NT,Primary:CSBM0004:NT,Primary:CSBM0009:NT,Primary :CSBM0012:NT,Primary:CSBM0015:NT,Primary:CSBM0021: NT,Primary:CSBM0101:NT,Primary:CSBM0102:NT,Primary :CSBM0103:NT,Primary:CSBM0109:NT,Primary:CSBM0110: NT,Primary:CSBM0111:NT,Primary:CSBM0112:NT,Primary :CSBM0113:NT,Primary:CSBM0116:NT,Primary:CSBM0120: NT,Primary:CSBM0121:NT,Primary:CSBM0126:NT,Primary :CSBM0131:NT,Primary:CSBM0132:NT,Primary:CSBM0141: NT,Primary:CSBM0142:NT,Primary:CSBM0143:NT,Primary :CSBM0145:NT,Primary:CSBM0146:NT,Primary:CSBM0147: NT,Primary:CSBM0149:NT,Primary:CSBM0151:NT,Primary :CSBM0153:NT,Primary:CSBM0155:NT,Primary
:CSBM0156:NT,Primary:CSBM0158:NT,Primary:CSBM0161: NT,Primary:CSBM0163:NT,Primary:CSBM0164:NT,Primary :CSBM0400:NT,Primary:CSBM0401:NT,Primary:CSBM0402: NT,Primary:CSBM0403:NT,Primary:CSBM1101:NT,Primary :CSBM1102:NT,Primary:CSBM1103:NT,Primary:CSBM1110: NT,Primary:CSBM1111:NT,Primary:CSBM1120:NT,Primary :CSBM1121:NT,Primary:CSBM1141:NT,Primary:CSBM1142: NT,Primary:CSBM1145:NT,Primary:CSBM1146:NT,Primary :CSBM1201:NT,Primary:CSBM1203:NT,Primary:CSBM1301: NT,Primary:CSBM1308:NT,Primary:CSBM132:NT,Primary: CSBM1401:NT,Primary:CSBM1403:NT,Primary:CSBM1501:N T,Primary:CSBM1601:NT,Primary:CSBM2101:NT,Primary: CSBM2102:NT,Primary:CSBM2103:NT,Primary:CSBM2110:N T,Primary:CSBM2111:NT,Primary:CSBM2120:NT,Primary: CSBM2121:NT,Primary:CSBM2141:NT,Primary:CSBM2142:N T,Primary:CSBM2144:NT,Primary:CSBM2145:NT,Primary: CSBM2146:NT,Primary:CSBM3101:NT,Primary:CSBM3102:N T,Primary:CSBM3103:NT,Primary:CSBM3110:NT,Primary: CSBM3111:NT,Primary:CSBM3120:NT,Primary:CSBM3121:N T,Primary:CSBM3141:NT,Primary:CSBM3142:N
T,Primary:CSBM3144:NT,Primary:CSBM3145:NT,Primary: CSBM3146:NT,Primary:CSBM3148:NT,Primary:CSBM4110:N T,Primary:CSBM4111:NT,Primary:CSBM4112:NT,Primary: CSBM4113:NT,Primary:CSBM4115:NT,Primary:CSBM4120:N T,Primary:CSBM4121:NT,Primary:CSBM4124:NT,Primary: CSBM4125:NT,Primary:CSBM4141:NT,Primary:CSBM4142:N T,Primary:CSBM4143:NT,Primary:CSBM4145:NT,Primary: CSBM4146:NT,Primary:CSBM6101:NT,Primary:CSBM6103:N T,Primary:CSBM62:NT,Primary:CSBM7101:NT,Primary:CS BM7103:NT,Primary:CSBM7131:NT,Primary:CSBM83:NT,Pr imary:CSBM9101:NT,Primary:CSBM9102:NT,Primary:CSBM 9103:NT,Primary:CSBM9108:NT,Primary:DITREF02:NT,Pr imary:SASV0003:NT,Primary:SASV0004:NT,Primary:VCNT FX:NT,Primary:VDS001:NT,Primary:VDS002:NT,Primary: VDS007:NT,Primary:VDS008:NT,Primary:VDS010:NT,Prim ary:VDS011:NT,Primary:VDS018:NT,Primary:VDS031:NT, Primary:VDS032:NT,Primary:VDS041:NT,Primary:VDS042 :NT,Primary:VDS044:NT,Primary:VDS045:NT,Primary:VD S047:NT,Primary:VDS048:NT,Primary:VDS060:NT,Primar y:VDS061:NT,Primary:VDS062:NT',
>
>
>
>
> Why is it truncation my Distribution column since it is a tinetext?
> --
> Leo
>

From the manual:

TINYTEXT [CHARACTER SET charset_name] [COLLATE collation_name]

A TEXT column with a maximum length of 255 (28 – 1) characters


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

On Feb 25, 8:53 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
>
>
> > Why is it truncation my Distribution column since it is a tinetext?
> > --
> > Leo
>
> From the manual:
>
> TINYTEXT [CHARACTER SET charset_name] [COLLATE collation_name]
>
> A TEXT column with a maximum length of 255 (28 - 1) characters
>

I thought that, since VARCHAR could be 255, tinytext would accept
higher values. So I skiped the basic fact that this assumption should
be checked in the manuals. Sorry for this question.

Thank you Jerry.