question marks
Posted by:
Cash Perkins ()
Date: November 06, 2009 07:36PM
Hi..
I have used the following script to create table and load data:
CREATE TABLE `TaskAccepts` (
`SR_Number` VARCHAR(12) NOT NULL,
`Type_Name` VARCHAR(25),
`Summary` VARCHAR(255),
`Status_Name` VARCHAR(12),
`Severity_Name` VARCHAR(2),
`Language` VARCHAR(2),
`Timezone` VARCHAR(12),
`Region` VARCHAR(30),
`Gem` VARCHAR(30),
`Country_Group` VARCHAR(30),
`Country` VARCHAR(30),
`Task_Number` VARCHAR(16),
`Task_Type` VARCHAR(25),
`Task_Name` VARCHAR(255),
`Owner_Group` VARCHAR(40),
`Business_Unit` VARCHAR(12),
`Vertical` VARCHAR(12),
`Geo` VARCHAR(30),
`Gem2` VARCHAR(30),
`Country2` VARCHAR(30),
`Partner_Sun` VARCHAR(10),
`Assignee` VARCHAR(50),
`L5_Name` VARCHAR(50),
`L6_Name` VARCHAR(50),
`L7_Name` VARCHAR(50),
`L8_Name` VARCHAR(50),
`L9_Name` VARCHAR(50),
`Task_Status` VARCHAR(12),
`Task_Creation_Date` VARCHAR(20),
`CalYear` VARCHAR(4),
`CalYearQtr` VARCHAR(6),
`CalYearMonth` VARCHAR(7),
`Week` VARCHAR(2),
`Date` VARCHAR(20),
`PlannedStartDate` VARCHAR(20),
`ScheduledStartDate` VARCHAR(20),
`ActualStartDate` VARCHAR(20),
`TaskClosedDate` VARCHAR(20),
`CalYear2` VARCHAR(4),
`CalYearQtr2` VARCHAR(6),
`CalYearMonth2` VARCHAR(7),
`Week2` VARCHAR(2),
`Date2` VARCHAR(20),
`Duration` VARCHAR(12),
`DurationUom` VARCHAR(12),
`NumDaysOpen` VARCHAR(12),
`FullName` VARCHAR(50),
`L9_Employee` VARCHAR(50),
`L8_Employee` VARCHAR(50),
`L7_Employee` VARCHAR(50),
`L6_Employee` VARCHAR(50),
`L5_Employee` VARCHAR(50),
`WorkgroupName` VARCHAR(40),
`AffectedProductSerial` VARCHAR(100),
`ApplicationVersion` VARCHAR(100),
`OSVersionLOV` VARCHAR(100),
`PlatformLOV` VARCHAR(100),
`ProductLOV` VARCHAR(100),
`Level_1` VARCHAR(12),
`Level_2` VARCHAR(12),
`Level_3` VARCHAR(20),
`Level_4` VARCHAR(30),
`Level_5` VARCHAR(30)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
load data local infile './TasksAssigned.csv' into table TaskAccepts fields terminated by '\t' lines terminated by '\n';
This appears to work, but when I look at the data there is a ? between every character... where it should say Name... it says N?a?m?e?
What am I missing?
Thanks a bundle!