#DateForumTypeThreadPost
430 Sep 2015 @ 10:32 PDTDatabaseReplyDBQL SQLTextInfo 3577: row size or sort key size overflowThanks, Fred.  I found the UTF-16 warning!  I don't see a similar warning that explains that 4-byte UTF-8 encodings are not supported.  But the "UTF8 Multibyte Sequences&quo...
329 Sep 2015 @ 08:47 PDTDatabaseReplyDBQL SQLTextInfo 3577: row size or sort key size overflow@noeth: "If your session uses UTF8 you need to multiple the defined size times 3, for UTF16 times 2." UTF-8 uses 1-4 bytes per glyph, so shouldn't Teradata allocate 4 bytes (not 3) p...
210 Jun 2015 @ 07:09 PDTDatabaseReplycreating a view on a SQL query starting with "WITH" clauseRegarding the first question ... about using WITH in a CREATE VIEW ...   The v14.00 doc for CREATE VIEW says it is valid ... http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#pa...
104 May 2015 @ 08:54 PDTUDAReplywhy should we use SET table ?@Fred I used your 2/10/2009 example SQL exactly in a TD v14 env and both INSERT statements failed on the same 2801 error. Might TD have changed the behavior such that SET and MULTISET now functio...