Create Table & VARCHAR

Database

Create Table & VARCHAR

Hello team, my first post!

I'm trying to create a table and upload it to a Teradata environment so that I can run a simple query. Everything looks to upload correctly, but I'm getting some character errors when I query against the table. I'm using VARCHAR to define my columns, that include both numbers and letters, here are example formats for the columns:

Augusta

8-27-2014

RES

0562805182902

Question: Should all of these be proceeded by VARCHAR? or should the date field or the text fields be something else? If so, what?

Many thanks!

Dave M.

Tags (1)
1 REPLY
N/A

Re: Create Table & VARCHAR

Dave,

please share the DDL of the table you have created on Teradata.

Rglass