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