mysql> show create table db.rawdata\G
*************************** 1. row ***************************
       Table: rawdata
Create Table: CREATE TABLE `rawdata` (
  `vTransID` bigint(20) NOT NULL DEFAULT '0',
  `AccountNumber` varchar(100) DEFAULT NULL,
  `AccountName` varchar(100) DEFAULT NULL,
  `AccountGroup` varchar(100) DEFAULT NULL,
  `AccountBaseCurrencyCode` varchar(100) DEFAULT NULL,
  `AccountBaseCurrencyName` varchar(100) DEFAULT NULL,
  `SecurityShortDescription` varchar(100) DEFAULT NULL,
  `SecurityDescription1` varchar(100) DEFAULT NULL,
  `SecurityDescription2` varchar(100) DEFAULT NULL,
  `SecurityDescription3` varchar(100) DEFAULT NULL,
  `SecurityDescription4` varchar(100) DEFAULT NULL,
  `SecurityDescription5` varchar(100) DEFAULT NULL,
  `LocationCode` varchar(100) DEFAULT NULL,
  `LocationName` varchar(100) DEFAULT NULL,
  `LocalCurrencyCode` varchar(100) DEFAULT NULL,
  `LocalCurrencyName` varchar(100) DEFAULT NULL,
  `ReferenceNumber` varchar(100) DEFAULT NULL,
  `ClientReference` varchar(100) DEFAULT NULL,
  `RelatedReferenceNumber` varchar(100) DEFAULT NULL,
  `TransactionType` varchar(100) DEFAULT NULL,
  `TransactionName` varchar(100) DEFAULT NULL,
  `MainTransactionTypeCode` varchar(100) DEFAULT NULL,
  `SubTransactionTypeCode` varchar(100) DEFAULT NULL,
  `DetailTransactionTypeName` varchar(100) DEFAULT NULL,
  `TransactionStatus` varchar(100) DEFAULT NULL,
  `FailReasonCode` varchar(100) DEFAULT NULL,
  `FailReasonName` varchar(100) DEFAULT NULL,
  `TransactionDescription1` varchar(100) DEFAULT NULL,
  `TransactionDescription2` varchar(100) DEFAULT NULL,
  `TransactionDescription3` varchar(100) DEFAULT NULL,
  `TransactionDescription4` varchar(100) DEFAULT NULL,
  `TransactionDescription5` varchar(100) DEFAULT NULL,
  `TradeExDate` datetime DEFAULT NULL,
  `ContractualSettlePayDate` varchar(100) DEFAULT NULL,
  `ActualSettleDate` varchar(100) DEFAULT NULL,
  `AlternateDeliveryDate` varchar(100) DEFAULT NULL,
  `ReversalDate` varchar(100) DEFAULT NULL,
  `CreateDate` varchar(100) DEFAULT NULL,
  `CancelDate` varchar(100) DEFAULT NULL,
  `PaymentDate` varchar(100) DEFAULT NULL,
  `TradingBrokerCode` varchar(100) DEFAULT NULL,
  `TradingBICBrokerCode` varchar(100) DEFAULT NULL,
  `TradingBrokerName` varchar(100) DEFAULT NULL,
  `ClearingBrokerCode` varchar(100) DEFAULT NULL,
  `ClearingBICBrokerCode` varchar(100) DEFAULT NULL,
  `ClearingBrokerName` varchar(100) DEFAULT NULL,
  `AmortizedFace` varchar(100) DEFAULT NULL,
  `SharesPar` varchar(100) DEFAULT NULL,
  `LocalPrice` varchar(100) DEFAULT NULL,
  `LocalNetAmount` varchar(100) DEFAULT NULL,
  `CountryofIncorporationCode` varchar(100) DEFAULT NULL,
  `CountryofIncorporationName` varchar(100) DEFAULT NULL,
  `CUSIPCINS` varchar(100) DEFAULT NULL,
  `ISIN` varchar(100) DEFAULT NULL,
  `QUICK` varchar(100) DEFAULT NULL,
  `SEDOL` varchar(100) DEFAULT NULL,
  `SICOVAM` varchar(100) DEFAULT NULL,
  `TICKER` varchar(100) DEFAULT NULL,
  `VALOREN` varchar(100) DEFAULT NULL,
  `WPK` varchar(100) DEFAULT NULL,
  `BeginDate` varchar(100) DEFAULT NULL,
  `EndDate` varchar(100) DEFAULT NULL,
  `DaysLate` varchar(100) DEFAULT NULL,
  `TMPGEffectiveRate` varchar(100) DEFAULT NULL,
  `TMPGFailCharge` varchar(100) DEFAULT NULL,
  `ReportRunDate` varchar(100) DEFAULT NULL,
  `ReportRunTime` varchar(100) DEFAULT NULL,
  `CommissionExpenses` varchar(100) DEFAULT NULL,
  `ForeignExchangeFees` varchar(100) DEFAULT NULL,
  `RegistrationFees` varchar(100) DEFAULT NULL,
  `MiscellaneousFees` varchar(100) DEFAULT NULL,
  `OrderPlacementDate` varchar(100) DEFAULT NULL,
  `OrderPlacementTime` varchar(100) DEFAULT NULL,
  `OrderExpirationDate` varchar(100) DEFAULT NULL,
  `BuyerOrderPartyCode` varchar(100) DEFAULT NULL,
  `BuyerOrderPartyBICCode` varchar(100) DEFAULT NULL,
  `BuyerOrderPartyNameAddress` varchar(100) DEFAULT NULL,
  `SellerOrderPartyCode` varchar(100) DEFAULT NULL,
  `SellerOrderPartyBICCode` varchar(100) DEFAULT NULL,
  `SellerOrderPartyNameAddress` varchar(100) DEFAULT NULL,
  `ConfirmationOrderBrokerCode` varchar(100) DEFAULT NULL,
  `ConfirmationOrderBICBrokerCode` varchar(100) DEFAULT NULL,
  `ConfirmationOrderBrokerName` varchar(100) DEFAULT NULL,
  `OrderReferenceNumber` varchar(100) DEFAULT NULL,
  `DepositoryTypeCode` varchar(100) DEFAULT NULL,
  `DepositoryReferenceNumber` varchar(100) DEFAULT NULL,
  `TxnFee` varchar(100) DEFAULT NULL,
  `TxnFeeVATRate` varchar(100) DEFAULT NULL,
  `TxnFeeVAT` varchar(100) DEFAULT NULL,
  `BankTaxWithheld` varchar(100) DEFAULT NULL,
  `GrossAmount` varchar(100) DEFAULT NULL,
  `InterestBoughtSold` varchar(100) DEFAULT NULL,
  `LocalRate` varchar(100) DEFAULT NULL,
  `LocalTaxAmount` varchar(100) DEFAULT NULL,
  `PrincipalAmount` varchar(100) DEFAULT NULL,
  `SourceTaxWithheld` varchar(100) DEFAULT NULL,
  `TransactionSettlementTypeCode` varchar(100) DEFAULT NULL,
  `FlatTax` varchar(100) DEFAULT NULL,
  `FlatTaxAmount` varchar(100) DEFAULT NULL,
  `Solidarity` varchar(100) DEFAULT NULL,
  `SolidarityAmount` varchar(100) DEFAULT NULL,
  `FlatTaxCurrency` varchar(100) DEFAULT NULL,
  `AccountGSP` varchar(100) DEFAULT NULL,
  `ExtendedAccount` varchar(100) DEFAULT NULL,
  `OmnibusIndicator` varchar(100) DEFAULT NULL,
  `OmnibusTradeQualifier` varchar(100) DEFAULT NULL,
  `OmnibusTradeID` varchar(100) DEFAULT NULL,
  `DetailTransactionStatus` varchar(100) DEFAULT NULL,
  `SourceTaxWithholdingRate` varchar(100) DEFAULT NULL,
  `CashOffsetNumber` varchar(100) DEFAULT NULL,
  `DepotCode` varchar(100) DEFAULT NULL,
  `DepotName` varchar(100) DEFAULT NULL,
  `GlobalCustodianCode` varchar(100) DEFAULT NULL,
  `GlobalCustodianName` varchar(100) DEFAULT NULL,
  `MaturityDate` varchar(100) DEFAULT NULL,
  `CashValueDate` varchar(100) DEFAULT NULL,
  `AssetTypeCode` varchar(100) DEFAULT NULL,
  `AssetType` varchar(100) DEFAULT NULL,
  `TradeBrokerNumberType` varchar(100) DEFAULT NULL,
  `ClearingBrokerNumberType` varchar(100) DEFAULT NULL,
  `CurrentFactor` varchar(100) DEFAULT NULL,
  `CurrentFactorDate` varchar(100) DEFAULT NULL,
  `PreviousFactor` varchar(100) DEFAULT NULL,
  `PreviousFactorDate` varchar(100) DEFAULT NULL,
  `TaxBNYWithholdingRate` varchar(100) DEFAULT NULL,
  `BankWithholdingTaxRate` varchar(100) DEFAULT NULL,
  `FXBNYWithholdingTransRate` varchar(100) DEFAULT NULL,
  `FXBrokerCommissionTransRate` varchar(100) DEFAULT NULL,
  `FXContractNumber` varchar(100) DEFAULT NULL,
  `FXFundingTransRate` varchar(100) DEFAULT NULL,
  `FXLinkedFlag` varchar(100) DEFAULT NULL,
  `FXTransactionLocalRate` varchar(100) DEFAULT NULL,
  `FXSourceWithholdingRate` varchar(100) DEFAULT NULL,
  `FXRelatedReferenceNumber` varchar(100) DEFAULT NULL,
  `MarketReference` varchar(100) DEFAULT NULL,
  `ContractualIndicatorCode` varchar(100) DEFAULT NULL,
  `SettlementPolicy` varchar(100) DEFAULT NULL,
  `IASAccountNumber` varchar(100) DEFAULT NULL,
  `CID` varchar(100) DEFAULT NULL,
  `LastChangeDate` varchar(100) DEFAULT NULL,
  `RecordDate` varchar(100) DEFAULT NULL,
  `ReversalIndicator` varchar(100) DEFAULT NULL,
  `ReversalTradeNumber` varchar(100) DEFAULT NULL,
  `LinkedDetailTransactionDescription1` varchar(100) DEFAULT NULL,
  `LinkedDetailTradeExDate` varchar(100) DEFAULT NULL,
  `LinkedDetailClientReferenceNumber` varchar(100) DEFAULT NULL,
  `Linked1stLocalAmount` varchar(100) DEFAULT NULL,
  `Linked1stLocalCurrencyCode` varchar(100) DEFAULT NULL,
  `Linked2ndLocalAmount` varchar(100) DEFAULT NULL,
  `Linked2ndLocalCurrencyCode` varchar(100) DEFAULT NULL,
  `LinkedDetailReferenceNumber` varchar(100) DEFAULT NULL,
  `Linked2ndCashAccountNumber` varchar(100) DEFAULT NULL,
  `Linked1stCashAccountNumber` varchar(100) DEFAULT NULL,
  `LinkedDetailTranTypeDescription` varchar(100) DEFAULT NULL,
  `GLIndicator` varchar(100) DEFAULT NULL,
  `FundingDate` varchar(100) DEFAULT NULL,
  `NetAmount` varchar(100) DEFAULT NULL,
  `vStartDate` datetime DEFAULT NULL,
  `vEndDate` datetime DEFAULT NULL,
  `vRemove` char(1) DEFAULT 'F',
  `vCancel` char(1) DEFAULT 'F',
  `clientID` mediumint(9) DEFAULT NULL,
  `loadSequenceID` mediumint(9) DEFAULT NULL,
  `vTransactionType` varchar(10) DEFAULT NULL,
  `vCUSIP` varchar(50) DEFAULT NULL,
  `vTicker` varchar(10) DEFAULT NULL,
  `vMatchingTransID` int(11) DEFAULT NULL,
  `vNote` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`vTransID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
1 row in set (0.01 sec)

mysql> select * from information_schema.tables where table_name in ('rawdata')\G
*************************** 1. row ***************************
  TABLE_CATALOG: def
   TABLE_SCHEMA: db
     TABLE_NAME: rawdata
     TABLE_TYPE: BASE TABLE
         ENGINE: InnoDB
        VERSION: 10
     ROW_FORMAT: Dynamic
     TABLE_ROWS: 320517
 AVG_ROW_LENGTH: 1118
    DATA_LENGTH: 358612992
MAX_DATA_LENGTH: 0
   INDEX_LENGTH: 0
      DATA_FREE: 20971520
 AUTO_INCREMENT: NULL
    CREATE_TIME: 2023-10-30 15:45:35
    UPDATE_TIME: NULL
     CHECK_TIME: NULL
TABLE_COLLATION: latin1_swedish_ci
       CHECKSUM: NULL
 CREATE_OPTIONS:
  TABLE_COMMENT:

mysql> select @@version;
+---------------+
| @@version     |
+---------------+
| 5.7.24-27-log |
+---------------+
1 row in set (0.00 sec)

mysql> set show_old_temporals=ON;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> select * from information_schema.columns WHERE table_name = 'rawdata' and column_type LIKE '%5.5 binary format%'\G
*************************** 1. row ***************************
           TABLE_CATALOG: def
            TABLE_SCHEMA: db
              TABLE_NAME: rawdata
             COLUMN_NAME: TradeExDate
        ORDINAL_POSITION: 33
          COLUMN_DEFAULT: NULL
             IS_NULLABLE: YES
               DATA_TYPE: datetime
CHARACTER_MAXIMUM_LENGTH: NULL
  CHARACTER_OCTET_LENGTH: NULL
       NUMERIC_PRECISION: NULL
           NUMERIC_SCALE: NULL
      DATETIME_PRECISION: 0
      CHARACTER_SET_NAME: NULL
          COLLATION_NAME: NULL
             COLUMN_TYPE: datetime /* 5.5 binary format */
              COLUMN_KEY:
                   EXTRA:
              PRIVILEGES: select,insert,update,references
          COLUMN_COMMENT:
   GENERATION_EXPRESSION: