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