InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 16:31:00 GMT20http://www.teradata.com/teradataforum/Topic6812-9-1.aspxHello,<br>i was just wondering about a truncation of a varchar :<br>when inserting in a field in varchar(32000)format an extract of requesttext (for a very long view), <br>length of 12499 in dbc.tables, length of 18000 in dbc.tabletext), the shortest length is kept.<br>I had to enforce a char(32000) to get the full requesttext, but i don't know why ...<br><br>insert into Table1<br> select DBNAME,<br> TBNAME,<br> 1,<br> TXT_V<br> from (select T1.databasename,T1.tablename,<br> case when T2.requesttext is not null then CAST(T2.requesttext as char(32000)) else CAST(T1.requesttext as char(32000)) end (char(32000)) VTXT <br> from DBC.TABLES T1 LEFT OUTER JOIN DBC.TABLETEXT T2<br> ON T1.databasename = T2.databasename and T1.tablename = T2.tablename<br> where T1.tablekind='V'and (T1.databasename,T1.tablename) <br> in (select ... from Table2)<br> ) TMP (DBNAME, TBNAME, TXT_V)<br> ;<br> Thanks for any comment about the right way to deal with varchar ... Wed, 07 Mar 2007 10:21:08 GMTPierre