44

   blob                                      blob  

45

   character,graphic                 

char

  

46

   clob                                      clob  

47

   date                                     date  

48

   decimal                                decimal  

49

   

double

                                 

double

  

50

    integer                               integer  

51

    longvargraphic                   longvarchar  

52

    longvarchar  

53

  

54

real                                        real  

55

 smallint                                 smallint  

56

 time                                      time  

57

 timestamp                            timestamp  

58

 vargraphic                            varchar  

59

 varchar  

60

  

61

MySQL 与 java.sql.Types

   

的对应

62

  

63

MySQL                          java.sql.Types  

64

  bigint                              bigint  

65

   tinyblob                           binary  

66

   bit                                bit  

67

   

enum

,set,

char

                     

char

  

68

   date,year                          date  

69

   decimal,numeric                   decimal  

70

   

double

,real                       

double

  

71

   mediumint,

int

                     integer  

72

   blob,mediumblob                  blob  

73

   longblob  

74

   

float

                               real  

75

  

76

smallint                           smallint  

77

   time                             time  

78

   timestamp,datetime                timestamp  

79

   tinyint                           tinyint  

80

   varbinary,binary                varbinay  

81

   varchar,tinytext,text             varchar  

82

  

83

  

84

Sybase 与 java.sql.Types

   

的对应

85

  

86

Sybase                            java.sql.Types  

87

   binary                                 binary