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