1*079eb577SAndrew Rist /************************************************************** 2*079eb577SAndrew Rist * 3*079eb577SAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 4*079eb577SAndrew Rist * or more contributor license agreements. See the NOTICE file 5*079eb577SAndrew Rist * distributed with this work for additional information 6*079eb577SAndrew Rist * regarding copyright ownership. The ASF licenses this file 7*079eb577SAndrew Rist * to you under the Apache License, Version 2.0 (the 8*079eb577SAndrew Rist * "License"); you may not use this file except in compliance 9*079eb577SAndrew Rist * with the License. You may obtain a copy of the License at 10*079eb577SAndrew Rist * 11*079eb577SAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 12*079eb577SAndrew Rist * 13*079eb577SAndrew Rist * Unless required by applicable law or agreed to in writing, 14*079eb577SAndrew Rist * software distributed under the License is distributed on an 15*079eb577SAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16*079eb577SAndrew Rist * KIND, either express or implied. See the License for the 17*079eb577SAndrew Rist * specific language governing permissions and limitations 18*079eb577SAndrew Rist * under the License. 19*079eb577SAndrew Rist * 20*079eb577SAndrew Rist *************************************************************/ 21cdf0e10cSrcweir 22cdf0e10cSrcweir #include <stdio.h> 23cdf0e10cSrcweir #include <com/sun/star/sdbc/DataType.hpp> 24cdf0e10cSrcweir #include <com/sun/star/sdbc/ColumnValue.hpp> 25cdf0e10cSrcweir #include <com/sun/star/sdbc/ColumnSearch.hpp> 26cdf0e10cSrcweir #include "mysqlc_types.hxx" 27cdf0e10cSrcweir 28cdf0e10cSrcweir using namespace com::sun::star::sdbc; 29cdf0e10cSrcweir 30cdf0e10cSrcweir TypeInfoDef mysqlc_types[] = { 31cdf0e10cSrcweir 32cdf0e10cSrcweir // ------------- MySQL-Type: BIT. SDBC-Type: Bit ------------- 33cdf0e10cSrcweir { 34cdf0e10cSrcweir "BIT", // Typename 35cdf0e10cSrcweir com::sun::star::sdbc::DataType::BIT, // sdbc-type 36cdf0e10cSrcweir 1, // Precision 37cdf0e10cSrcweir "", // Literal prefix 38cdf0e10cSrcweir "", // Literal suffix 39cdf0e10cSrcweir "", // Create params 40cdf0e10cSrcweir com::sun::star::sdbc::ColumnValue::NULLABLE, // nullable 41cdf0e10cSrcweir sal_True, // case sensitive 42cdf0e10cSrcweir com::sun::star::sdbc::ColumnSearch::FULL, // searchable 43cdf0e10cSrcweir sal_False, // unsignable 44cdf0e10cSrcweir sal_False, // fixed_prec_scale 45cdf0e10cSrcweir sal_False, // auto_increment 46cdf0e10cSrcweir "BIT", // local type name 47cdf0e10cSrcweir 0, // minimum scale 48cdf0e10cSrcweir 0, // maximum scale 49cdf0e10cSrcweir 0, // sql data type (unsued) 50cdf0e10cSrcweir 0, // sql datetime sub (unsued) 51cdf0e10cSrcweir 10 // num prec radix 52cdf0e10cSrcweir }, 53cdf0e10cSrcweir 54cdf0e10cSrcweir // ------------ MySQL-Type: BOOL. SDBC-Type: Bit ------------- 55cdf0e10cSrcweir { 56cdf0e10cSrcweir "BOOL", // Typename 57cdf0e10cSrcweir com::sun::star::sdbc::DataType::BIT, // sdbc-type 58cdf0e10cSrcweir 1, // Precision 59cdf0e10cSrcweir "", // Literal prefix 60cdf0e10cSrcweir "", // Literal suffix 61cdf0e10cSrcweir "", // Create params 62cdf0e10cSrcweir com::sun::star::sdbc::ColumnValue::NULLABLE, // nullable 63cdf0e10cSrcweir sal_True, // case sensitive 64cdf0e10cSrcweir com::sun::star::sdbc::ColumnSearch::FULL, // searchable 65cdf0e10cSrcweir sal_False, // unsignable 66cdf0e10cSrcweir sal_False, // fixed_prec_scale 67cdf0e10cSrcweir sal_False, // auto_increment 68cdf0e10cSrcweir "BOOL", // local type name 69cdf0e10cSrcweir 0, // minimum scale 70cdf0e10cSrcweir 0, // maximum scale 71cdf0e10cSrcweir 0, // sql data type (unsued) 72cdf0e10cSrcweir 0, // sql datetime sub (unsued) 73cdf0e10cSrcweir 10 // num prec radix 74cdf0e10cSrcweir }, 75cdf0e10cSrcweir 76cdf0e10cSrcweir // --------- MySQL-Type: TINYINT SDBC-Type: TINYINT ---------- 77cdf0e10cSrcweir { 78cdf0e10cSrcweir "TINYINT", // Typename 79cdf0e10cSrcweir com::sun::star::sdbc::DataType::TINYINT, // sdbc-type 80cdf0e10cSrcweir 3, // Precision 81cdf0e10cSrcweir "", // Literal prefix 82cdf0e10cSrcweir "", // Literal suffix 83cdf0e10cSrcweir "[(M)] [UNSIGNED] [ZEROFILL]", // Create params 84cdf0e10cSrcweir com::sun::star::sdbc::ColumnValue::NULLABLE, // nullable 85cdf0e10cSrcweir sal_False, // case sensitive 86cdf0e10cSrcweir com::sun::star::sdbc::ColumnSearch::FULL, // searchable 87cdf0e10cSrcweir sal_True, // unsignable 88cdf0e10cSrcweir sal_False, // fixed_prec_scale 89cdf0e10cSrcweir sal_True, // auto_increment 90cdf0e10cSrcweir "TINYINT", // local type name 91cdf0e10cSrcweir 0, // minimum scale 92cdf0e10cSrcweir 0, // maximum scale 93cdf0e10cSrcweir 0, // sql data type (unsued) 94cdf0e10cSrcweir 0, // sql datetime sub (unsued) 95cdf0e10cSrcweir 10 // num prec radix 96cdf0e10cSrcweir }, 97cdf0e10cSrcweir 98cdf0e10cSrcweir // ----------- MySQL-Type: BIGINT SDBC-Type: BIGINT ---------- 99cdf0e10cSrcweir { 100cdf0e10cSrcweir "BIGINT", // Typename 101cdf0e10cSrcweir com::sun::star::sdbc::DataType::BIGINT, // sdbc-type 102cdf0e10cSrcweir 19, // Precision 103cdf0e10cSrcweir "", // Literal prefix 104cdf0e10cSrcweir "", // Literal suffix 105cdf0e10cSrcweir "[(M)] [UNSIGNED] [ZEROFILL]", // Create params 106cdf0e10cSrcweir com::sun::star::sdbc::ColumnValue::NULLABLE, // nullable 107cdf0e10cSrcweir sal_False, // case sensitive 108cdf0e10cSrcweir com::sun::star::sdbc::ColumnSearch::FULL, // searchable 109cdf0e10cSrcweir sal_True, // unsignable 110cdf0e10cSrcweir sal_False, // fixed_prec_scale 111cdf0e10cSrcweir sal_True, // auto_increment 112cdf0e10cSrcweir "BIGINT", // local type name 113cdf0e10cSrcweir 0, // minimum scale 114cdf0e10cSrcweir 0, // maximum scale 115cdf0e10cSrcweir 0, // sql data type (unsued) 116cdf0e10cSrcweir 0, // sql datetime sub (unsued) 117cdf0e10cSrcweir 10 // num prec radix 118cdf0e10cSrcweir }, 119cdf0e10cSrcweir 120cdf0e10cSrcweir // ----------- MySQL-Type: LONG VARBINARY SDBC-Type: LONGVARBINARY ---------- 121cdf0e10cSrcweir { 122cdf0e10cSrcweir "LONG VARBINARY", // Typename 123cdf0e10cSrcweir com::sun::star::sdbc::DataType::LONGVARBINARY, // sdbc-type 124cdf0e10cSrcweir 16777215, // Precision 125cdf0e10cSrcweir "'", // Literal prefix 126cdf0e10cSrcweir "'", // Literal suffix 127cdf0e10cSrcweir "", // Create params 128cdf0e10cSrcweir com::sun::star::sdbc::ColumnValue::NULLABLE, // nullable 129cdf0e10cSrcweir sal_True, // case sensitive 130cdf0e10cSrcweir com::sun::star::sdbc::ColumnSearch::FULL, // searchable 131cdf0e10cSrcweir sal_False, // unsignable 132cdf0e10cSrcweir sal_False, // fixed_prec_scale 133cdf0e10cSrcweir sal_False, // auto_increment 134cdf0e10cSrcweir "LONG VARBINARY", // local type name 135cdf0e10cSrcweir 0, // minimum scale 136cdf0e10cSrcweir 0, // maximum scale 137cdf0e10cSrcweir 0, // sql data type (unsued) 138cdf0e10cSrcweir 0, // sql datetime sub (unsued) 139cdf0e10cSrcweir 10 // num prec radix 140cdf0e10cSrcweir }, 141cdf0e10cSrcweir 142cdf0e10cSrcweir // ----------- MySQL-Type: MEDIUMBLOB SDBC-Type: LONGVARBINARY ---------- 143cdf0e10cSrcweir { 144cdf0e10cSrcweir "MEDIUMBLOB", // Typename 145cdf0e10cSrcweir com::sun::star::sdbc::DataType::LONGVARBINARY, // sdbc-type 146cdf0e10cSrcweir 16777215, // Precision 147cdf0e10cSrcweir "'", // Literal prefix 148cdf0e10cSrcweir "'", // Literal suffix 149cdf0e10cSrcweir "", // Create params 150cdf0e10cSrcweir com::sun::star::sdbc::ColumnValue::NULLABLE, // nullable 151cdf0e10cSrcweir sal_True, // case sensitive 152cdf0e10cSrcweir com::sun::star::sdbc::ColumnSearch::FULL, // searchable 153cdf0e10cSrcweir sal_False, // unsignable 154cdf0e10cSrcweir sal_False, // fixed_prec_scale 155cdf0e10cSrcweir sal_False, // auto_increment 156cdf0e10cSrcweir "MEDIUMBLOB", // local type name 157cdf0e10cSrcweir 0, // minimum scale 158cdf0e10cSrcweir 0, // maximum scale 159cdf0e10cSrcweir 0, // sql data type (unsued) 160cdf0e10cSrcweir 0, // sql datetime sub (unsued) 161cdf0e10cSrcweir 10 // num prec radix 162cdf0e10cSrcweir }, 163cdf0e10cSrcweir 164cdf0e10cSrcweir // ----------- MySQL-Type: LONGBLOB SDBC-Type: LONGVARBINARY ---------- 165cdf0e10cSrcweir { 166cdf0e10cSrcweir "LONGBLOB", // Typename 167cdf0e10cSrcweir com::sun::star::sdbc::DataType::LONGVARBINARY, // sdbc-type 168cdf0e10cSrcweir 0xFFFFFFFF, // Precision 169cdf0e10cSrcweir "'", // Literal prefix 170cdf0e10cSrcweir "'", // Literal suffix 171cdf0e10cSrcweir "", // Create params 172cdf0e10cSrcweir com::sun::star::sdbc::ColumnValue::NULLABLE, // nullable 173cdf0e10cSrcweir sal_True, // case sensitive 174cdf0e10cSrcweir com::sun::star::sdbc::ColumnSearch::FULL, // searchable 175cdf0e10cSrcweir sal_False, // unsignable 176cdf0e10cSrcweir sal_False, // fixed_prec_scale 177cdf0e10cSrcweir sal_False, // auto_increment 178cdf0e10cSrcweir "LONGBLOB", // local type name 179cdf0e10cSrcweir 0, // minimum scale 180cdf0e10cSrcweir 0, // maximum scale 181cdf0e10cSrcweir 0, // sql data type (unsued) 182cdf0e10cSrcweir 0, // sql datetime sub (unsued) 183cdf0e10cSrcweir 10 // num prec radix 184cdf0e10cSrcweir }, 185cdf0e10cSrcweir 186cdf0e10cSrcweir // ----------- MySQL-Type: BLOB SDBC-Type: LONGVARBINARY ---------- 187cdf0e10cSrcweir { 188cdf0e10cSrcweir "BLOB", // Typename 189cdf0e10cSrcweir com::sun::star::sdbc::DataType::LONGVARBINARY, // sdbc-type 190cdf0e10cSrcweir 0xFFFF, // Precision 191cdf0e10cSrcweir "'", // Literal prefix 192cdf0e10cSrcweir "'", // Literal suffix 193cdf0e10cSrcweir "", // Create params 194cdf0e10cSrcweir com::sun::star::sdbc::ColumnValue::NULLABLE, // nullable 195cdf0e10cSrcweir sal_True, // case sensitive 196cdf0e10cSrcweir com::sun::star::sdbc::ColumnSearch::FULL, // searchable 197cdf0e10cSrcweir sal_False, // unsignable 198cdf0e10cSrcweir sal_False, // fixed_prec_scale 199cdf0e10cSrcweir sal_False, // auto_increment 200cdf0e10cSrcweir "BLOB", // local type name 201cdf0e10cSrcweir 0, // minimum scale 202cdf0e10cSrcweir 0, // maximum scale 203cdf0e10cSrcweir 0, // sql data type (unsued) 204cdf0e10cSrcweir 0, // sql datetime sub (unsued) 205cdf0e10cSrcweir 10 // num prec radix 206cdf0e10cSrcweir }, 207cdf0e10cSrcweir 208cdf0e10cSrcweir // ----------- MySQL-Type: TINYBLOB SDBC-Type: LONGVARBINARY ---------- 209cdf0e10cSrcweir { 210cdf0e10cSrcweir "TINYBLOB", // Typename 211cdf0e10cSrcweir com::sun::star::sdbc::DataType::LONGVARBINARY, // sdbc-type 212cdf0e10cSrcweir 0xFF, // Precision 213cdf0e10cSrcweir "'", // Literal prefix 214cdf0e10cSrcweir "'", // Literal suffix 215cdf0e10cSrcweir "", // Create params 216cdf0e10cSrcweir com::sun::star::sdbc::ColumnValue::NULLABLE, // nullable 217cdf0e10cSrcweir sal_True, // case sensitive 218cdf0e10cSrcweir com::sun::star::sdbc::ColumnSearch::FULL, // searchable 219cdf0e10cSrcweir sal_False, // unsignable 220cdf0e10cSrcweir sal_False, // fixed_prec_scale 221cdf0e10cSrcweir sal_False, // auto_increment 222cdf0e10cSrcweir "TINYBLOB", // local type name 223cdf0e10cSrcweir 0, // minimum scale 224cdf0e10cSrcweir 0, // maximum scale 225cdf0e10cSrcweir 0, // sql data type (unsued) 226cdf0e10cSrcweir 0, // sql datetime sub (unsued) 227cdf0e10cSrcweir 10 // num prec radix 228cdf0e10cSrcweir }, 229cdf0e10cSrcweir 230cdf0e10cSrcweir // ----------- MySQL-Type: VARBINARY SDBC-Type: VARBINARY ---------- 231cdf0e10cSrcweir { 232cdf0e10cSrcweir "VARBINARY", // Typename 233cdf0e10cSrcweir com::sun::star::sdbc::DataType::VARBINARY, // sdbc-type 234cdf0e10cSrcweir 0xFF, // Precision 235cdf0e10cSrcweir "'", // Literal prefix 236cdf0e10cSrcweir "'", // Literal suffix 237cdf0e10cSrcweir "(M)", // Create params 238cdf0e10cSrcweir com::sun::star::sdbc::ColumnValue::NULLABLE, // nullable 239cdf0e10cSrcweir sal_True, // case sensitive 240cdf0e10cSrcweir com::sun::star::sdbc::ColumnSearch::FULL, // searchable 241cdf0e10cSrcweir sal_False, // unsignable 242cdf0e10cSrcweir sal_False, // fixed_prec_scale 243cdf0e10cSrcweir sal_False, // auto_increment 244cdf0e10cSrcweir "VARBINARY", // local type name 245cdf0e10cSrcweir 0, // minimum scale 246cdf0e10cSrcweir 0, // maximum scale 247cdf0e10cSrcweir 0, // sql data type (unsued) 248cdf0e10cSrcweir 0, // sql datetime sub (unsued) 249cdf0e10cSrcweir 10 // num prec radix 250cdf0e10cSrcweir }, 251cdf0e10cSrcweir 252cdf0e10cSrcweir // ----------- MySQL-Type: BINARY SDBC-Type: BINARY ---------- 253cdf0e10cSrcweir { 254cdf0e10cSrcweir "BINARY", // Typename 255cdf0e10cSrcweir com::sun::star::sdbc::DataType::BINARY, // sdbc-type 256cdf0e10cSrcweir 0xFF, // Precision 257cdf0e10cSrcweir "'", // Literal prefix 258cdf0e10cSrcweir "'", // Literal suffix 259cdf0e10cSrcweir "(M)", // Create params 260cdf0e10cSrcweir com::sun::star::sdbc::ColumnValue::NULLABLE, // nullable 261cdf0e10cSrcweir sal_True, // case sensitive 262cdf0e10cSrcweir com::sun::star::sdbc::ColumnSearch::FULL, // searchable 263cdf0e10cSrcweir sal_False, // unsignable 264cdf0e10cSrcweir sal_False, // fixed_prec_scale 265cdf0e10cSrcweir sal_False, // auto_increment 266cdf0e10cSrcweir "VARBINARY", // local type name 267cdf0e10cSrcweir 0, // minimum scale 268cdf0e10cSrcweir 0, // maximum scale 269cdf0e10cSrcweir 0, // sql data type (unsued) 270cdf0e10cSrcweir 0, // sql datetime sub (unsued) 271cdf0e10cSrcweir 10 // num prec radix 272cdf0e10cSrcweir }, 273cdf0e10cSrcweir 274cdf0e10cSrcweir // ----------- MySQL-Type: LONG VARCHAR SDBC-Type: LONG VARCHAR ---------- 275cdf0e10cSrcweir { 276cdf0e10cSrcweir "LONG VARCHAR", // Typename 277cdf0e10cSrcweir com::sun::star::sdbc::DataType::LONGVARCHAR, // sdbc-type 278cdf0e10cSrcweir 0xFFFFFF, // Precision 279cdf0e10cSrcweir "'", // Literal prefix 280cdf0e10cSrcweir "'", // Literal suffix 281cdf0e10cSrcweir "", // Create params 282cdf0e10cSrcweir com::sun::star::sdbc::ColumnValue::NULLABLE, // nullable 283cdf0e10cSrcweir sal_False, // case sensitive 284cdf0e10cSrcweir com::sun::star::sdbc::ColumnSearch::FULL, // searchable 285cdf0e10cSrcweir sal_False, // unsignable 286cdf0e10cSrcweir sal_False, // fixed_prec_scale 287cdf0e10cSrcweir sal_False, // auto_increment 288cdf0e10cSrcweir "LONG VARCHAR", // local type name 289cdf0e10cSrcweir 0, // minimum scale 290cdf0e10cSrcweir 0, // maximum scale 291cdf0e10cSrcweir 0, // sql data type (unsued) 292cdf0e10cSrcweir 0, // sql datetime sub (unsued) 293cdf0e10cSrcweir 10 // num prec radix 294cdf0e10cSrcweir }, 295cdf0e10cSrcweir 296cdf0e10cSrcweir // ----------- MySQL-Type: MEDIUMTEXT SDBC-Type: LONG VARCHAR ---------- 297cdf0e10cSrcweir { 298cdf0e10cSrcweir "MEDIUMTEXT", // Typename 299cdf0e10cSrcweir com::sun::star::sdbc::DataType::LONGVARCHAR, // sdbc-type 300cdf0e10cSrcweir 0xFFFFFF, // Precision 301cdf0e10cSrcweir "'", // Literal prefix 302cdf0e10cSrcweir "'", // Literal suffix 303cdf0e10cSrcweir "", // Create params 304cdf0e10cSrcweir com::sun::star::sdbc::ColumnValue::NULLABLE, // nullable 305cdf0e10cSrcweir sal_False, // case sensitive 306cdf0e10cSrcweir com::sun::star::sdbc::ColumnSearch::FULL, // searchable 307cdf0e10cSrcweir sal_False, // unsignable 308cdf0e10cSrcweir sal_False, // fixed_prec_scale 309cdf0e10cSrcweir sal_False, // auto_increment 310cdf0e10cSrcweir "MEDIUMTEXT", // local type name 311cdf0e10cSrcweir 0, // minimum scale 312cdf0e10cSrcweir 0, // maximum scale 313cdf0e10cSrcweir 0, // sql data type (unsued) 314cdf0e10cSrcweir 0, // sql datetime sub (unsued) 315cdf0e10cSrcweir 10 // num prec radix 316cdf0e10cSrcweir }, 317cdf0e10cSrcweir 318cdf0e10cSrcweir // ----------- MySQL-Type: LONGTEXT SDBC-Type: LONG VARCHAR ---------- 319cdf0e10cSrcweir { 320cdf0e10cSrcweir "LONGTEXT", // Typename 321cdf0e10cSrcweir com::sun::star::sdbc::DataType::LONGVARCHAR, // sdbc-type 322cdf0e10cSrcweir 0xFFFFFF, // Precision 323cdf0e10cSrcweir "'", // Literal prefix 324cdf0e10cSrcweir "'", // Literal suffix 325cdf0e10cSrcweir "", // Create params 326cdf0e10cSrcweir com::sun::star::sdbc::ColumnValue::NULLABLE, // nullable 327cdf0e10cSrcweir sal_False, // case sensitive 328cdf0e10cSrcweir com::sun::star::sdbc::ColumnSearch::FULL, // searchable 329cdf0e10cSrcweir sal_False, // unsignable 330cdf0e10cSrcweir sal_False, // fixed_prec_scale 331cdf0e10cSrcweir sal_False, // auto_increment 332cdf0e10cSrcweir "LONGTEXT", // local type name 333cdf0e10cSrcweir 0, // minimum scale 334cdf0e10cSrcweir 0, // maximum scale 335cdf0e10cSrcweir 0, // sql data type (unsued) 336cdf0e10cSrcweir 0, // sql datetime sub (unsued) 337cdf0e10cSrcweir 10 // num prec radix 338cdf0e10cSrcweir }, 339cdf0e10cSrcweir 340cdf0e10cSrcweir // ----------- MySQL-Type: TEXT SDBC-Type: LONG VARCHAR ---------- 341cdf0e10cSrcweir { 342cdf0e10cSrcweir "TEXT", // Typename 343cdf0e10cSrcweir com::sun::star::sdbc::DataType::LONGVARCHAR, // sdbc-type 344cdf0e10cSrcweir 0xFFFF, // Precision 345cdf0e10cSrcweir "'", // Literal prefix 346cdf0e10cSrcweir "'", // Literal suffix 347cdf0e10cSrcweir "", // Create params 348cdf0e10cSrcweir com::sun::star::sdbc::ColumnValue::NULLABLE, // nullable 349cdf0e10cSrcweir sal_False, // case sensitive 350cdf0e10cSrcweir com::sun::star::sdbc::ColumnSearch::FULL, // searchable 351cdf0e10cSrcweir sal_False, // unsignable 352cdf0e10cSrcweir sal_False, // fixed_prec_scale 353cdf0e10cSrcweir sal_False, // auto_increment 354cdf0e10cSrcweir "TEXT", // local type name 355cdf0e10cSrcweir 0, // minimum scale 356cdf0e10cSrcweir 0, // maximum scale 357cdf0e10cSrcweir 0, // sql data type (unsued) 358cdf0e10cSrcweir 0, // sql datetime sub (unsued) 359cdf0e10cSrcweir 10 // num prec radix 360cdf0e10cSrcweir }, 361cdf0e10cSrcweir 362cdf0e10cSrcweir // ----------- MySQL-Type: TINYTEXT SDBC-Type: LONG VARCHAR ---------- 363cdf0e10cSrcweir { 364cdf0e10cSrcweir "TINYTEXT", // Typename 365cdf0e10cSrcweir com::sun::star::sdbc::DataType::LONGVARCHAR, // sdbc-type 366cdf0e10cSrcweir 0xFF, // Precision 367cdf0e10cSrcweir "'", // Literal prefix 368cdf0e10cSrcweir "'", // Literal suffix 369cdf0e10cSrcweir "", // Create params 370cdf0e10cSrcweir com::sun::star::sdbc::ColumnValue::NULLABLE, // nullable 371cdf0e10cSrcweir sal_False, // case sensitive 372cdf0e10cSrcweir com::sun::star::sdbc::ColumnSearch::FULL, // searchable 373cdf0e10cSrcweir sal_False, // unsignable 374cdf0e10cSrcweir sal_False, // fixed_prec_scale 375cdf0e10cSrcweir sal_False, // auto_increment 376cdf0e10cSrcweir "TINYTEXT", // local type name 377cdf0e10cSrcweir 0, // minimum scale 378cdf0e10cSrcweir 0, // maximum scale 379cdf0e10cSrcweir 0, // sql data type (unsued) 380cdf0e10cSrcweir 0, // sql datetime sub (unsued) 381cdf0e10cSrcweir 10 // num prec radix 382cdf0e10cSrcweir }, 383cdf0e10cSrcweir 384cdf0e10cSrcweir // ----------- MySQL-Type: CHAR SDBC-Type: CHAR ---------- 385cdf0e10cSrcweir { 386cdf0e10cSrcweir "CHAR", // Typename 387cdf0e10cSrcweir com::sun::star::sdbc::DataType::CHAR, // sdbc-type 388cdf0e10cSrcweir 0xFF, // Precision 389cdf0e10cSrcweir "'", // Literal prefix 390cdf0e10cSrcweir "'", // Literal suffix 391cdf0e10cSrcweir "(M)", // Create params 392cdf0e10cSrcweir com::sun::star::sdbc::ColumnValue::NULLABLE, // nullable 393cdf0e10cSrcweir sal_False, // case sensitive 394cdf0e10cSrcweir com::sun::star::sdbc::ColumnSearch::FULL, // searchable 395cdf0e10cSrcweir sal_False, // unsignable 396cdf0e10cSrcweir sal_False, // fixed_prec_scale 397cdf0e10cSrcweir sal_False, // auto_increment 398cdf0e10cSrcweir "NUMERIC", // local type name 399cdf0e10cSrcweir 0, // minimum scale 400cdf0e10cSrcweir 0, // maximum scale 401cdf0e10cSrcweir 0, // sql data type (unsued) 402cdf0e10cSrcweir 0, // sql datetime sub (unsued) 403cdf0e10cSrcweir 10 // num prec radix 404cdf0e10cSrcweir }, 405cdf0e10cSrcweir 406cdf0e10cSrcweir // ----------- MySQL-Type: DECIMAL SDBC-Type: DECIMAL ---------- 407cdf0e10cSrcweir { 408cdf0e10cSrcweir "DECIMAL", // Typename 409cdf0e10cSrcweir com::sun::star::sdbc::DataType::DECIMAL, // sdbc-type 410cdf0e10cSrcweir 17, // Precision 411cdf0e10cSrcweir "", // Literal prefix 412cdf0e10cSrcweir "", // Literal suffix 413cdf0e10cSrcweir "[(M[,D])] [ZEROFILL]", // Create params 414cdf0e10cSrcweir com::sun::star::sdbc::ColumnValue::NULLABLE, // nullable 415cdf0e10cSrcweir sal_False, // case sensitive 416cdf0e10cSrcweir com::sun::star::sdbc::ColumnSearch::FULL, // searchable 417cdf0e10cSrcweir sal_False, // unsignable 418cdf0e10cSrcweir sal_False, // fixed_prec_scale 419cdf0e10cSrcweir sal_True, // auto_increment 420cdf0e10cSrcweir "DECIMAL", // local type name 421cdf0e10cSrcweir -308, // minimum scale 422cdf0e10cSrcweir 308, // maximum scale 423cdf0e10cSrcweir 0, // sql data type (unsued) 424cdf0e10cSrcweir 0, // sql datetime sub (unsued) 425cdf0e10cSrcweir 10 // num prec radix 426cdf0e10cSrcweir }, 427cdf0e10cSrcweir 428cdf0e10cSrcweir // ----------- MySQL-Type: NUMERIC SDBC-Type: NUMERIC ---------- 429cdf0e10cSrcweir { 430cdf0e10cSrcweir "NUMERIC", // Typename 431cdf0e10cSrcweir com::sun::star::sdbc::DataType::NUMERIC, // sdbc-type 432cdf0e10cSrcweir 17, // Precision 433cdf0e10cSrcweir "", // Literal prefix 434cdf0e10cSrcweir "", // Literal suffix 435cdf0e10cSrcweir "[(M[,D])] [ZEROFILL]", // Create params 436cdf0e10cSrcweir com::sun::star::sdbc::ColumnValue::NULLABLE, // nullable 437cdf0e10cSrcweir sal_False, // case sensitive 438cdf0e10cSrcweir com::sun::star::sdbc::ColumnSearch::FULL, // searchable 439cdf0e10cSrcweir sal_False, // unsignable 440cdf0e10cSrcweir sal_False, // fixed_prec_scale 441cdf0e10cSrcweir sal_True, // auto_increment 442cdf0e10cSrcweir "NUMERIC", // local type name 443cdf0e10cSrcweir -308, // minimum scale 444cdf0e10cSrcweir 308, // maximum scale 445cdf0e10cSrcweir 0, // sql data type (unsued) 446cdf0e10cSrcweir 0, // sql datetime sub (unsued) 447cdf0e10cSrcweir 10 // num prec radix 448cdf0e10cSrcweir }, 449cdf0e10cSrcweir 450cdf0e10cSrcweir // ----------- MySQL-Type: INTEGER SDBC-Type: INTEGER ---------- 451cdf0e10cSrcweir { 452cdf0e10cSrcweir "INTEGER", // Typename 453cdf0e10cSrcweir com::sun::star::sdbc::DataType::INTEGER, // sdbc-type 454cdf0e10cSrcweir 10, // Precision 455cdf0e10cSrcweir "", // Literal prefix 456cdf0e10cSrcweir "", // Literal suffix 457cdf0e10cSrcweir "[(M)] [UNSIGNED] [ZEROFILL]", // Create params 458cdf0e10cSrcweir com::sun::star::sdbc::ColumnValue::NULLABLE, // nullable 459cdf0e10cSrcweir sal_False, // case sensitive 460cdf0e10cSrcweir com::sun::star::sdbc::ColumnSearch::FULL, // searchable 461cdf0e10cSrcweir sal_True, // unsignable 462cdf0e10cSrcweir sal_False, // fixed_prec_scale 463cdf0e10cSrcweir sal_True, // auto_increment 464cdf0e10cSrcweir "INTEGER", // local type name 465cdf0e10cSrcweir 0, // minimum scale 466cdf0e10cSrcweir 0, // maximum scale 467cdf0e10cSrcweir 0, // sql data type (unsued) 468cdf0e10cSrcweir 0, // sql datetime sub (unsued) 469cdf0e10cSrcweir 10 // num prec radix 470cdf0e10cSrcweir }, 471cdf0e10cSrcweir 472cdf0e10cSrcweir // ----------- MySQL-Type: INT SDBC-Type: INTEGER ---------- 473cdf0e10cSrcweir { 474cdf0e10cSrcweir "INT", // Typename 475cdf0e10cSrcweir com::sun::star::sdbc::DataType::INTEGER, // sdbc-type 476cdf0e10cSrcweir 10, // Precision 477cdf0e10cSrcweir "", // Literal prefix 478cdf0e10cSrcweir "", // Literal suffix 479cdf0e10cSrcweir "[(M)] [UNSIGNED] [ZEROFILL]", // Create params 480cdf0e10cSrcweir com::sun::star::sdbc::ColumnValue::NULLABLE, // nullable 481cdf0e10cSrcweir sal_False, // case sensitive 482cdf0e10cSrcweir com::sun::star::sdbc::ColumnSearch::FULL, // searchable 483cdf0e10cSrcweir sal_True, // unsignable 484cdf0e10cSrcweir sal_False, // fixed_prec_scale 485cdf0e10cSrcweir sal_True, // auto_increment 486cdf0e10cSrcweir "INT", // local type name 487cdf0e10cSrcweir 0, // minimum scale 488cdf0e10cSrcweir 0, // maximum scale 489cdf0e10cSrcweir 0, // sql data type (unsued) 490cdf0e10cSrcweir 0, // sql datetime sub (unsued) 491cdf0e10cSrcweir 10 // num prec radix 492cdf0e10cSrcweir }, 493cdf0e10cSrcweir 494cdf0e10cSrcweir // ----------- MySQL-Type: MEDIUMINT SDBC-Type: INTEGER ---------- 495cdf0e10cSrcweir { 496cdf0e10cSrcweir "MEDIUMINT", // Typename 497cdf0e10cSrcweir com::sun::star::sdbc::DataType::INTEGER, // sdbc-type 498cdf0e10cSrcweir 7, // Precision 499cdf0e10cSrcweir "", // Literal prefix 500cdf0e10cSrcweir "", // Literal suffix 501cdf0e10cSrcweir "[(M)] [UNSIGNED] [ZEROFILL]", // Create params 502cdf0e10cSrcweir com::sun::star::sdbc::ColumnValue::NULLABLE, // nullable 503cdf0e10cSrcweir sal_False, // case sensitive 504cdf0e10cSrcweir com::sun::star::sdbc::ColumnSearch::FULL, // searchable 505cdf0e10cSrcweir sal_True, // unsignable 506cdf0e10cSrcweir sal_False, // fixed_prec_scale 507cdf0e10cSrcweir sal_True, // auto_increment 508cdf0e10cSrcweir "MEDIUMINT", // local type name 509cdf0e10cSrcweir 0, // minimum scale 510cdf0e10cSrcweir 0, // maximum scale 511cdf0e10cSrcweir 0, // sql data type (unsued) 512cdf0e10cSrcweir 0, // sql datetime sub (unsued) 513cdf0e10cSrcweir 10 // num prec radix 514cdf0e10cSrcweir }, 515cdf0e10cSrcweir 516cdf0e10cSrcweir // ----------- MySQL-Type: SMALLINT SDBC-Type: INTEGER ---------- 517cdf0e10cSrcweir { 518cdf0e10cSrcweir "SMALLINT", // Typename 519cdf0e10cSrcweir com::sun::star::sdbc::DataType::SMALLINT, // sdbc-type 520cdf0e10cSrcweir 5, // Precision 521cdf0e10cSrcweir "", // Literal prefix 522cdf0e10cSrcweir "", // Literal suffix 523cdf0e10cSrcweir "[(M)] [UNSIGNED] [ZEROFILL]", // Create params 524cdf0e10cSrcweir com::sun::star::sdbc::ColumnValue::NULLABLE, // nullable 525cdf0e10cSrcweir sal_False, // case sensitive 526cdf0e10cSrcweir com::sun::star::sdbc::ColumnSearch::FULL, // searchable 527cdf0e10cSrcweir sal_True, // unsignable 528cdf0e10cSrcweir sal_False, // fixed_prec_scale 529cdf0e10cSrcweir sal_True, // auto_increment 530cdf0e10cSrcweir "SMALLINT", // local type name 531cdf0e10cSrcweir 0, // minimum scale 532cdf0e10cSrcweir 0, // maximum scale 533cdf0e10cSrcweir 0, // sql data type (unsued) 534cdf0e10cSrcweir 0, // sql datetime sub (unsued) 535cdf0e10cSrcweir 10 // num prec radix 536cdf0e10cSrcweir }, 537cdf0e10cSrcweir 538cdf0e10cSrcweir // ----------- MySQL-Type: FLOAT SDBC-Type: REAL ---------- 539cdf0e10cSrcweir { 540cdf0e10cSrcweir "FLOAT", // Typename 541cdf0e10cSrcweir com::sun::star::sdbc::DataType::REAL, // sdbc-type 542cdf0e10cSrcweir 10, // Precision 543cdf0e10cSrcweir "", // Literal prefix 544cdf0e10cSrcweir "", // Literal suffix 545cdf0e10cSrcweir "[(M,D)] [ZEROFILL]", // Create params 546cdf0e10cSrcweir com::sun::star::sdbc::ColumnValue::NULLABLE, // nullable 547cdf0e10cSrcweir sal_False, // case sensitive 548cdf0e10cSrcweir com::sun::star::sdbc::ColumnSearch::FULL, // searchable 549cdf0e10cSrcweir sal_False, // unsignable 550cdf0e10cSrcweir sal_False, // fixed_prec_scale 551cdf0e10cSrcweir sal_True, // auto_increment 552cdf0e10cSrcweir "FLOAT", // local type name 553cdf0e10cSrcweir -38, // minimum scale 554cdf0e10cSrcweir 38, // maximum scale 555cdf0e10cSrcweir 0, // sql data type (unsued) 556cdf0e10cSrcweir 0, // sql datetime sub (unsued) 557cdf0e10cSrcweir 10 // num prec radix 558cdf0e10cSrcweir }, 559cdf0e10cSrcweir 560cdf0e10cSrcweir // ----------- MySQL-Type: DOUBLE SDBC-Type: DOUBLE ---------- 561cdf0e10cSrcweir { 562cdf0e10cSrcweir "DOUBLE", // Typename 563cdf0e10cSrcweir com::sun::star::sdbc::DataType::DOUBLE, // sdbc-type 564cdf0e10cSrcweir 17, // Precision 565cdf0e10cSrcweir "", // Literal prefix 566cdf0e10cSrcweir "", // Literal suffix 567cdf0e10cSrcweir "[(M,D)] [ZEROFILL]", // Create params 568cdf0e10cSrcweir com::sun::star::sdbc::ColumnValue::NULLABLE, // nullable 569cdf0e10cSrcweir sal_False, // case sensitive 570cdf0e10cSrcweir com::sun::star::sdbc::ColumnSearch::FULL, // searchable 571cdf0e10cSrcweir sal_False, // unsignable 572cdf0e10cSrcweir sal_False, // fixed_prec_scale 573cdf0e10cSrcweir sal_True, // auto_increment 574cdf0e10cSrcweir "DOUBLE", // local type name 575cdf0e10cSrcweir -308, // minimum scale 576cdf0e10cSrcweir 308, // maximum scale 577cdf0e10cSrcweir 0, // sql data type (unsued) 578cdf0e10cSrcweir 0, // sql datetime sub (unsued) 579cdf0e10cSrcweir 10 // num prec radix 580cdf0e10cSrcweir }, 581cdf0e10cSrcweir 582cdf0e10cSrcweir // ----------- MySQL-Type: DOUBLE PRECISION SDBC-Type: DOUBLE ---------- 583cdf0e10cSrcweir { 584cdf0e10cSrcweir "DOUBLE PRECISION", // Typename 585cdf0e10cSrcweir com::sun::star::sdbc::DataType::DOUBLE, // sdbc-type 586cdf0e10cSrcweir 17, // Precision 587cdf0e10cSrcweir "", // Literal prefix 588cdf0e10cSrcweir "", // Literal suffix 589cdf0e10cSrcweir "[(M,D)] [ZEROFILL]", // Create params 590cdf0e10cSrcweir com::sun::star::sdbc::ColumnValue::NULLABLE, // nullable 591cdf0e10cSrcweir sal_False, // case sensitive 592cdf0e10cSrcweir com::sun::star::sdbc::ColumnSearch::FULL, // searchable 593cdf0e10cSrcweir sal_False, // unsignable 594cdf0e10cSrcweir sal_False, // fixed_prec_scale 595cdf0e10cSrcweir sal_True, // auto_increment 596cdf0e10cSrcweir "DOUBLE PRECISION", // local type name 597cdf0e10cSrcweir -308, // minimum scale 598cdf0e10cSrcweir 308, // maximum scale 599cdf0e10cSrcweir 0, // sql data type (unsued) 600cdf0e10cSrcweir 0, // sql datetime sub (unsued) 601cdf0e10cSrcweir 10 // num prec radix 602cdf0e10cSrcweir }, 603cdf0e10cSrcweir 604cdf0e10cSrcweir // ----------- MySQL-Type: REAL SDBC-Type: DOUBLE ---------- 605cdf0e10cSrcweir { 606cdf0e10cSrcweir "REAL", // Typename 607cdf0e10cSrcweir com::sun::star::sdbc::DataType::DOUBLE, // sdbc-type 608cdf0e10cSrcweir 17, // Precision 609cdf0e10cSrcweir "", // Literal prefix 610cdf0e10cSrcweir "", // Literal suffix 611cdf0e10cSrcweir "[(M,D)] [ZEROFILL]", // Create params 612cdf0e10cSrcweir com::sun::star::sdbc::ColumnValue::NULLABLE, // nullable 613cdf0e10cSrcweir sal_False, // case sensitive 614cdf0e10cSrcweir com::sun::star::sdbc::ColumnSearch::FULL, // searchable 615cdf0e10cSrcweir sal_False, // unsignable 616cdf0e10cSrcweir sal_False, // fixed_prec_scale 617cdf0e10cSrcweir sal_True, // auto_increment 618cdf0e10cSrcweir "REAL", // local type name 619cdf0e10cSrcweir -308, // minimum scale 620cdf0e10cSrcweir 308, // maximum scale 621cdf0e10cSrcweir 0, // sql data type (unsued) 622cdf0e10cSrcweir 0, // sql datetime sub (unsued) 623cdf0e10cSrcweir 10 // num prec radix 624cdf0e10cSrcweir }, 625cdf0e10cSrcweir 626cdf0e10cSrcweir // ----------- MySQL-Type: VARCHAR SDBC-Type: VARCHAR ---------- 627cdf0e10cSrcweir { 628cdf0e10cSrcweir "VARCHAR", // Typename 629cdf0e10cSrcweir com::sun::star::sdbc::DataType::VARCHAR, // sdbc-type 630cdf0e10cSrcweir 255, // Precision 631cdf0e10cSrcweir "'", // Literal prefix 632cdf0e10cSrcweir "'", // Literal suffix 633cdf0e10cSrcweir "(M)", // Create params 634cdf0e10cSrcweir com::sun::star::sdbc::ColumnValue::NULLABLE, // nullable 635cdf0e10cSrcweir sal_False, // case sensitive 636cdf0e10cSrcweir com::sun::star::sdbc::ColumnSearch::FULL, // searchable 637cdf0e10cSrcweir sal_False, // unsignable 638cdf0e10cSrcweir sal_False, // fixed_prec_scale 639cdf0e10cSrcweir sal_False, // auto_increment 640cdf0e10cSrcweir "VARCHAR", // local type name 641cdf0e10cSrcweir 0, // minimum scale 642cdf0e10cSrcweir 0, // maximum scale 643cdf0e10cSrcweir 0, // sql data type (unsued) 644cdf0e10cSrcweir 0, // sql datetime sub (unsued) 645cdf0e10cSrcweir 10 // num prec radix 646cdf0e10cSrcweir }, 647cdf0e10cSrcweir 648cdf0e10cSrcweir // ----------- MySQL-Type: ENUM SDBC-Type: VARCHAR ---------- 649cdf0e10cSrcweir { 650cdf0e10cSrcweir "ENUM", // Typename 651cdf0e10cSrcweir com::sun::star::sdbc::DataType::VARCHAR, // sdbc-type 652cdf0e10cSrcweir 0xFFFF, // Precision 653cdf0e10cSrcweir "'", // Literal prefix 654cdf0e10cSrcweir "'", // Literal suffix 655cdf0e10cSrcweir "", // Create params 656cdf0e10cSrcweir com::sun::star::sdbc::ColumnValue::NULLABLE, // nullable 657cdf0e10cSrcweir sal_False, // case sensitive 658cdf0e10cSrcweir com::sun::star::sdbc::ColumnSearch::FULL, // searchable 659cdf0e10cSrcweir sal_False, // unsignable 660cdf0e10cSrcweir sal_False, // fixed_prec_scale 661cdf0e10cSrcweir sal_False, // auto_increment 662cdf0e10cSrcweir "ENUM", // local type name 663cdf0e10cSrcweir 0, // minimum scale 664cdf0e10cSrcweir 0, // maximum scale 665cdf0e10cSrcweir 0, // sql data type (unsued) 666cdf0e10cSrcweir 0, // sql datetime sub (unsued) 667cdf0e10cSrcweir 10 // num prec radix 668cdf0e10cSrcweir }, 669cdf0e10cSrcweir 670cdf0e10cSrcweir // ----------- MySQL-Type: SET SDBC-Type: VARCHAR ---------- 671cdf0e10cSrcweir { 672cdf0e10cSrcweir "SET", // Typename 673cdf0e10cSrcweir com::sun::star::sdbc::DataType::VARCHAR, // sdbc-type 674cdf0e10cSrcweir 64, // Precision 675cdf0e10cSrcweir "'", // Literal prefix 676cdf0e10cSrcweir "'", // Literal suffix 677cdf0e10cSrcweir "", // Create params 678cdf0e10cSrcweir com::sun::star::sdbc::ColumnValue::NULLABLE, // nullable 679cdf0e10cSrcweir sal_False, // case sensitive 680cdf0e10cSrcweir com::sun::star::sdbc::ColumnSearch::FULL, // searchable 681cdf0e10cSrcweir sal_False, // unsignable 682cdf0e10cSrcweir sal_False, // fixed_prec_scale 683cdf0e10cSrcweir sal_False, // auto_increment 684cdf0e10cSrcweir "SET", // local type name 685cdf0e10cSrcweir 0, // minimum scale 686cdf0e10cSrcweir 0, // maximum scale 687cdf0e10cSrcweir 0, // sql data type (unsued) 688cdf0e10cSrcweir 0, // sql datetime sub (unsued) 689cdf0e10cSrcweir 10 // num prec radix 690cdf0e10cSrcweir }, 691cdf0e10cSrcweir 692cdf0e10cSrcweir // ----------- MySQL-Type: DATE SDBC-Type: DATE ---------- 693cdf0e10cSrcweir { 694cdf0e10cSrcweir "DATE", // Typename 695cdf0e10cSrcweir com::sun::star::sdbc::DataType::DATE, // sdbc-type 696cdf0e10cSrcweir 0, // Precision 697cdf0e10cSrcweir "'", // Literal prefix 698cdf0e10cSrcweir "'", // Literal suffix 699cdf0e10cSrcweir "", // Create params 700cdf0e10cSrcweir com::sun::star::sdbc::ColumnValue::NULLABLE, // nullable 701cdf0e10cSrcweir sal_False, // case sensitive 702cdf0e10cSrcweir com::sun::star::sdbc::ColumnSearch::FULL, // searchable 703cdf0e10cSrcweir sal_False, // unsignable 704cdf0e10cSrcweir sal_False, // fixed_prec_scale 705cdf0e10cSrcweir sal_False, // auto_increment 706cdf0e10cSrcweir "DATE", // local type name 707cdf0e10cSrcweir 0, // minimum scale 708cdf0e10cSrcweir 0, // maximum scale 709cdf0e10cSrcweir 0, // sql data type (unsued) 710cdf0e10cSrcweir 0, // sql datetime sub (unsued) 711cdf0e10cSrcweir 10 // num prec radix 712cdf0e10cSrcweir }, 713cdf0e10cSrcweir 714cdf0e10cSrcweir // ----------- MySQL-Type: TIME SDBC-Type: TIME ---------- 715cdf0e10cSrcweir { 716cdf0e10cSrcweir "TIME", // Typename 717cdf0e10cSrcweir com::sun::star::sdbc::DataType::TIME, // sdbc-type 718cdf0e10cSrcweir 0, // Precision 719cdf0e10cSrcweir "'", // Literal prefix 720cdf0e10cSrcweir "'", // Literal suffix 721cdf0e10cSrcweir "", // Create params 722cdf0e10cSrcweir com::sun::star::sdbc::ColumnValue::NULLABLE, // nullable 723cdf0e10cSrcweir sal_False, // case sensitive 724cdf0e10cSrcweir com::sun::star::sdbc::ColumnSearch::FULL, // searchable 725cdf0e10cSrcweir sal_False, // unsignable 726cdf0e10cSrcweir sal_False, // fixed_prec_scale 727cdf0e10cSrcweir sal_False, // auto_increment 728cdf0e10cSrcweir "TIME", // local type name 729cdf0e10cSrcweir 0, // minimum scale 730cdf0e10cSrcweir 0, // maximum scale 731cdf0e10cSrcweir 0, // sql data type (unsued) 732cdf0e10cSrcweir 0, // sql datetime sub (unsued) 733cdf0e10cSrcweir 10 // num prec radix 734cdf0e10cSrcweir }, 735cdf0e10cSrcweir 736cdf0e10cSrcweir // ----------- MySQL-Type: DATETIME SDBC-Type: TIMESTAMP ---------- 737cdf0e10cSrcweir { 738cdf0e10cSrcweir "DATETIME", // Typename 739cdf0e10cSrcweir com::sun::star::sdbc::DataType::TIMESTAMP, // sdbc-type 740cdf0e10cSrcweir 0, // Precision 741cdf0e10cSrcweir "'", // Literal prefix 742cdf0e10cSrcweir "'", // Literal suffix 743cdf0e10cSrcweir "", // Create params 744cdf0e10cSrcweir com::sun::star::sdbc::ColumnValue::NULLABLE, // nullable 745cdf0e10cSrcweir sal_False, // case sensitive 746cdf0e10cSrcweir com::sun::star::sdbc::ColumnSearch::FULL, // searchable 747cdf0e10cSrcweir sal_False, // unsignable 748cdf0e10cSrcweir sal_False, // fixed_prec_scale 749cdf0e10cSrcweir sal_False, // auto_increment 750cdf0e10cSrcweir "DATETIME", // local type name 751cdf0e10cSrcweir 0, // minimum scale 752cdf0e10cSrcweir 0, // maximum scale 753cdf0e10cSrcweir 0, // sql data type (unsued) 754cdf0e10cSrcweir 0, // sql datetime sub (unsued) 755cdf0e10cSrcweir 10 // num prec radix 756cdf0e10cSrcweir }, 757cdf0e10cSrcweir 758cdf0e10cSrcweir // ----------- MySQL-Type: TIMESTAMP SDBC-Type: TIMESTAMP ---------- 759cdf0e10cSrcweir { 760cdf0e10cSrcweir "TIMESTAMP", // Typename 761cdf0e10cSrcweir com::sun::star::sdbc::DataType::TIMESTAMP, // sdbc-type 762cdf0e10cSrcweir 0, // Precision 763cdf0e10cSrcweir "'", // Literal prefix 764cdf0e10cSrcweir "'", // Literal suffix 765cdf0e10cSrcweir "[(M)]", // Create params 766cdf0e10cSrcweir com::sun::star::sdbc::ColumnValue::NULLABLE, // nullable 767cdf0e10cSrcweir sal_False, // case sensitive 768cdf0e10cSrcweir com::sun::star::sdbc::ColumnSearch::FULL, // searchable 769cdf0e10cSrcweir sal_False, // unsignable 770cdf0e10cSrcweir sal_False, // fixed_prec_scale 771cdf0e10cSrcweir sal_False, // auto_increment 772cdf0e10cSrcweir "TIMESTAMP", // local type name 773cdf0e10cSrcweir 0, // minimum scale 774cdf0e10cSrcweir 0, // maximum scale 775cdf0e10cSrcweir 0, // sql data type (unsued) 776cdf0e10cSrcweir 0, // sql datetime sub (unsued) 777cdf0e10cSrcweir 10 // num prec radix 778cdf0e10cSrcweir }, 779cdf0e10cSrcweir 780cdf0e10cSrcweir // ----------- MySQL-Type: TIMESTAMP SDBC-Type: TIMESTAMP ---------- 781cdf0e10cSrcweir { 782cdf0e10cSrcweir 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 783cdf0e10cSrcweir } 784cdf0e10cSrcweir }; 785