ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/public/ibx/trunk/fbintf/testsuite/reference.log
Revision: 117
Committed: Mon Jan 22 13:58:11 2018 UTC (6 years, 3 months ago) by tony
File size: 68495 byte(s)
Log Message: 
Fixes Merged

File Contents

# Content
1 Firebird API Test Suite
2 Copyright MWA Software 2016
3
4 Starting Tests
5 Client API Version = 3.768
6 Running Test 1: Create and Drop a Database
7 Creating a Database with empty parameters
8 Create Database fails (as expected): I/O error during "open O_CREAT" operation for file ""
9 Error while trying to create file
10 No such file or directory
11 Creating a Database using an SQL Statement
12 Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = mint18-FB3
13 SQL Dialect = 3
14 DB Connect String = localhost:/tmp/fbintf-testsuite/testsuite1.fdb
15 DB Charset ID = 0
16 DB SQL Dialect = 3
17 DB Remote Protocol = TCPv4
18 DB ODS Major Version = 12
19 DB ODS Minor Version = 0
20 DPB
21 Count = 3
22 28 = SYSDBA
23 29 = masterkey
24 65 = 3
25
26 Dropping Database
27 Creating a Database with a DPD
28 DB Connect String = localhost:/tmp/fbintf-testsuite/testsuite1.fdb
29 DB Charset ID = 4
30 DB SQL Dialect = 3
31 DB Remote Protocol = TCPv4
32 DB ODS Major Version = 12
33 DB ODS Minor Version = 0
34 Dropping Database
35 DPB
36 Count = 4
37 28 = SYSDBA
38 29 = masterkey
39 48 = UTF8
40 65 = 3
41
42 Creating a Database with a DPD
43 Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = mint18-FB3
44 ODS major = 12
45 ODS minor = 0
46 DB Connect String = localhost:/tmp/fbintf-testsuite/testsuite1.fdb
47 DB Charset ID = 4
48 DB SQL Dialect = 3
49 DB Remote Protocol = TCPv4
50 DB ODS Major Version = 12
51 DB ODS Minor Version = 0
52 RDB$DESCRIPTION =
53 RDB$RELATION_ID = 128
54 RDB$SECURITY_CLASS = SQL$363
55 RDB$CHARACTER_SET_NAME = UTF8
56 RDB$LINGER =
57 Dropping Database
58
59
60 Running Test 2: Open the employee database and run a query
61 Opening localhost:employee
62 Database Open
63 Metadata
64 SQLType =SQL_SHORT
65 sub type = 0
66 Table = EMPLOYEE
67 Owner = SYSDBA
68 Column Name = EMP_NO
69 Alias Name = EMP_NO
70 Field Name = EMP_NO
71 Scale = 0
72 Charset id = 0
73 Not Null
74 Size = 2
75
76 SQLType =SQL_VARYING
77 sub type = 0
78 Table = EMPLOYEE
79 Owner = SYSDBA
80 Column Name = FIRST_NAME
81 Alias Name = FIRST_NAME
82 Field Name = FIRST_NAME
83 Scale = 0
84 Charset id = 0
85 Not Null
86 Size = 15
87
88 SQLType =SQL_VARYING
89 sub type = 0
90 Table = EMPLOYEE
91 Owner = SYSDBA
92 Column Name = LAST_NAME
93 Alias Name = LAST_NAME
94 Field Name = LAST_NAME
95 Scale = 0
96 Charset id = 0
97 Not Null
98 Size = 20
99
100 SQLType =SQL_VARYING
101 sub type = 0
102 Table = EMPLOYEE
103 Owner = SYSDBA
104 Column Name = PHONE_EXT
105 Alias Name = PHONE_EXT
106 Field Name = PHONE_EXT
107 Scale = 0
108 Charset id = 0
109 Nullable
110 Size = 4
111
112 SQLType =SQL_TIMESTAMP
113 sub type = 0
114 Table = EMPLOYEE
115 Owner = SYSDBA
116 Column Name = HIRE_DATE
117 Alias Name = HIRE_DATE
118 Field Name = HIRE_DATE
119 Scale = 0
120 Charset id = 0
121 Not Null
122 Size = 8
123
124 SQLType =SQL_TEXT
125 sub type = 0
126 Table = EMPLOYEE
127 Owner = SYSDBA
128 Column Name = DEPT_NO
129 Alias Name = DEPT_NO
130 Field Name = DEPT_NO
131 Scale = 0
132 Charset id = 0
133 Not Null
134 Size = 3
135
136 SQLType =SQL_VARYING
137 sub type = 0
138 Table = EMPLOYEE
139 Owner = SYSDBA
140 Column Name = JOB_CODE
141 Alias Name = JOB_CODE
142 Field Name = JOB_CODE
143 Scale = 0
144 Charset id = 0
145 Not Null
146 Size = 5
147
148 SQLType =SQL_SHORT
149 sub type = 0
150 Table = EMPLOYEE
151 Owner = SYSDBA
152 Column Name = JOB_GRADE
153 Alias Name = JOB_GRADE
154 Field Name = JOB_GRADE
155 Scale = 0
156 Charset id = 0
157 Not Null
158 Size = 2
159
160 SQLType =SQL_VARYING
161 sub type = 0
162 Table = EMPLOYEE
163 Owner = SYSDBA
164 Column Name = JOB_COUNTRY
165 Alias Name = JOB_COUNTRY
166 Field Name = JOB_COUNTRY
167 Scale = 0
168 Charset id = 0
169 Not Null
170 Size = 15
171
172 SQLType =SQL_INT64
173 sub type = 0
174 Table = EMPLOYEE
175 Owner = SYSDBA
176 Column Name = SALARY
177 Alias Name = SALARY
178 Field Name = SALARY
179 Scale = -2
180 Charset id = 0
181 Not Null
182 Size = 8
183
184 SQLType =SQL_VARYING
185 sub type = 0
186 Table = EMPLOYEE
187 Owner = SYSDBA
188 Column Name = FULL_NAME
189 Alias Name = FULL_NAME
190 Field Name = FULL_NAME
191 Scale = 0
192 Charset id = 0
193 Nullable
194 Size = 37
195
196 Plan =
197 Select Expression
198 -> First N Records
199 -> Table "EMPLOYEE" Full Scan
200 Select First 3 * from EMPLOYEE
201
202 EMP_NO = 2
203 FIRST_NAME = Robert
204 LAST_NAME = Nelson
205 PHONE_EXT = 250
206 HIRE_DATE = 28/12/1988 00:00:00.000
207 DEPT_NO = 600
208 JOB_CODE = VP
209 JOB_GRADE = 2
210 JOB_COUNTRY = USA
211 SALARY = 105,900.00
212 FULL_NAME = Nelson, Robert
213 EMP_NO = 4
214 FIRST_NAME = Bruce
215 LAST_NAME = Young
216 PHONE_EXT = 233
217 HIRE_DATE = 28/12/1988 00:00:00.000
218 DEPT_NO = 621
219 JOB_CODE = Eng
220 JOB_GRADE = 2
221 JOB_COUNTRY = USA
222 SALARY = 97,500.00
223 FULL_NAME = Young, Bruce
224 EMP_NO = 5
225 FIRST_NAME = Kim
226 LAST_NAME = Lambert
227 PHONE_EXT = 22
228 HIRE_DATE = 6/2/1989 00:00:00.000
229 DEPT_NO = 130
230 JOB_CODE = Eng
231 JOB_GRADE = 2
232 JOB_COUNTRY = USA
233 SALARY = 102,750.00
234 FULL_NAME = Lambert, Kim
235
236 Select * from EMPLOYEE Where EMP_NO = ?
237 SQL Params
238 SQLType =SQL_SHORT
239 sub type = 0
240 Field Name =
241 Scale = 0
242 Charset id = 0
243 Not Null
244 Size = 2
245
246 EMP_NO = 8
247 FIRST_NAME = Leslie
248 LAST_NAME = Johnson
249 PHONE_EXT = 410
250 HIRE_DATE = 5/4/1989 00:00:00.000
251 DEPT_NO = 180
252 JOB_CODE = Mktg
253 JOB_GRADE = 3
254 JOB_COUNTRY = USA
255 SALARY = 64,635.00
256 FULL_NAME = Johnson, Leslie
257
258 With param names
259 Select * from EMPLOYEE Where EMP_NO = :EMP_NO
260 SQL Params
261 SQLType =SQL_SHORT
262 sub type = 0
263 Field Name = EMP_NO
264 Scale = 0
265 Charset id = 0
266 Not Null
267 Size = 2
268
269 EMP_NO = 8
270 FIRST_NAME = Leslie
271 LAST_NAME = Johnson
272 PHONE_EXT = 410
273 HIRE_DATE = 5/4/1989 00:00:00.000
274 DEPT_NO = 180
275 JOB_CODE = Mktg
276 JOB_GRADE = 3
277 JOB_COUNTRY = USA
278 SALARY = 64,635.00
279 FULL_NAME = Johnson, Leslie
280
281
282
283 Running Test 3: ad hoc queries
284 Opening localhost:employee
285 Database Open
286 Employee Count = 42
287 Employee Count = 41
288 Employee Count = 42
289 Employee Count = 41
290 Employee Count = 42
291 Constrained Employee Count = 3
292 "Johnson" Employee Count = 2
293 "Yanowski" Employee Count = 1
294
295
296 Running Test 4: Update, Insert and Delete Queries
297 Opening localhost:employee
298 Database Open
299 Select Count = 1 InsertCount = 0 UpdateCount = 1 DeleteCount = 0
300 EMP_NO = 8
301 FIRST_NAME = Leslie
302 LAST_NAME = Johnson
303 PHONE_EXT = 410
304 HIRE_DATE = 5/4/1989 00:00:00.000
305 DEPT_NO = 180
306 JOB_CODE = Mktg
307 JOB_GRADE = 3
308 JOB_COUNTRY = USA
309 SALARY = 64,635.00
310 FULL_NAME = Johnson, Leslie
311
312 Current memory = 1.960264000000000000E+0007
313 Delta memory = 2.616000000000000000E+0003
314 Max memory = 1.966621600000000000E+0007
315 Elapsed time= 0.000 sec
316 Cpu = 0.000 sec
317 Buffers = 2.048000000000000000E+0003
318 Reads = 0.000000000000000000E+0000
319 Writes = 0.000000000000000000E+0000
320 Fetches = 2.000000000000000000E+0000
321 Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
322 Relation Name = EMPLOYEE
323 Metadata
324 SQLType =SQL_SHORT
325 sub type = 0
326 Table = EMPLOYEE
327 Owner = SYSDBA
328 Column Name = EMP_NO
329 Alias Name = EMP_NO
330 Field Name = EMP_NO
331 Scale = 0
332 Charset id = 0
333 Not Null
334 Size = 2
335
336 SQLType =SQL_VARYING
337 sub type = 0
338 Table = EMPLOYEE
339 Owner = SYSDBA
340 Column Name = FIRST_NAME
341 Alias Name = FIRST_NAME
342 Field Name = FIRST_NAME
343 Scale = 0
344 Charset id = 0
345 Not Null
346 Size = 15
347
348 SQLType =SQL_VARYING
349 sub type = 0
350 Table = EMPLOYEE
351 Owner = SYSDBA
352 Column Name = LAST_NAME
353 Alias Name = LAST_NAME
354 Field Name = LAST_NAME
355 Scale = 0
356 Charset id = 0
357 Not Null
358 Size = 20
359
360 SQLType =SQL_VARYING
361 sub type = 0
362 Table = EMPLOYEE
363 Owner = SYSDBA
364 Column Name = PHONE_EXT
365 Alias Name = PHONE_EXT
366 Field Name = PHONE_EXT
367 Scale = 0
368 Charset id = 0
369 Nullable
370 Size = 4
371
372 SQLType =SQL_TIMESTAMP
373 sub type = 0
374 Table = EMPLOYEE
375 Owner = SYSDBA
376 Column Name = HIRE_DATE
377 Alias Name = HIRE_DATE
378 Field Name = HIRE_DATE
379 Scale = 0
380 Charset id = 0
381 Not Null
382 Size = 8
383
384 SQLType =SQL_TEXT
385 sub type = 0
386 Table = EMPLOYEE
387 Owner = SYSDBA
388 Column Name = DEPT_NO
389 Alias Name = DEPT_NO
390 Field Name = DEPT_NO
391 Scale = 0
392 Charset id = 0
393 Not Null
394 Size = 3
395
396 SQLType =SQL_VARYING
397 sub type = 0
398 Table = EMPLOYEE
399 Owner = SYSDBA
400 Column Name = JOB_CODE
401 Alias Name = JOB_CODE
402 Field Name = JOB_CODE
403 Scale = 0
404 Charset id = 0
405 Not Null
406 Size = 5
407
408 SQLType =SQL_SHORT
409 sub type = 0
410 Table = EMPLOYEE
411 Owner = SYSDBA
412 Column Name = JOB_GRADE
413 Alias Name = JOB_GRADE
414 Field Name = JOB_GRADE
415 Scale = 0
416 Charset id = 0
417 Not Null
418 Size = 2
419
420 SQLType =SQL_VARYING
421 sub type = 0
422 Table = EMPLOYEE
423 Owner = SYSDBA
424 Column Name = JOB_COUNTRY
425 Alias Name = JOB_COUNTRY
426 Field Name = JOB_COUNTRY
427 Scale = 0
428 Charset id = 0
429 Not Null
430 Size = 15
431
432 SQLType =SQL_INT64
433 sub type = 0
434 Table = EMPLOYEE
435 Owner = SYSDBA
436 Column Name = SALARY
437 Alias Name = SALARY
438 Field Name = SALARY
439 Scale = -2
440 Charset id = 0
441 Not Null
442 Size = 8
443
444 SQLType =SQL_VARYING
445 sub type = 0
446 Table = EMPLOYEE
447 Owner = SYSDBA
448 Column Name = FULL_NAME
449 Alias Name = FULL_NAME
450 Field Name = FULL_NAME
451 Scale = 0
452 Charset id = 0
453 Nullable
454 Size = 37
455
456 EMP_NO = 150
457 FIRST_NAME = John
458 LAST_NAME = Doe
459 PHONE_EXT =
460 HIRE_DATE = 1/4/2015 00:00:00.000
461 DEPT_NO = 600
462 JOB_CODE = Eng
463 JOB_GRADE = 4
464 JOB_COUNTRY = England
465 SALARY = 41,000.89
466 FULL_NAME = Doe, John
467
468 Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
469 EMP_NO = 151
470 FIRST_NAME = Major
471 LAST_NAME = Major
472 PHONE_EXT =
473 HIRE_DATE = 1/4/2015 00:00:00.000
474 DEPT_NO = 600
475 JOB_CODE = Eng
476 JOB_GRADE = 4
477 JOB_COUNTRY = England
478 SALARY = 40,000.59
479 FULL_NAME = Major, Major
480
481 Now Delete the rows
482 Select Count = 1 InsertCount = 0 UpdateCount = 0 DeleteCount = 1
483 Select Count = 1 InsertCount = 0 UpdateCount = 0 DeleteCount = 1
484 Inserting
485 Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
486 EMP_NO = 150
487 FIRST_NAME = Jane
488 LAST_NAME = Doe
489 PHONE_EXT = NULL
490 HIRE_DATE = 1/4/2015 00:00:00.000
491 DEPT_NO = 600
492 JOB_CODE = Eng
493 JOB_GRADE = 4
494 JOB_COUNTRY = England
495 SALARY = 41,000.89
496 FULL_NAME = Doe, Jane
497
498 Employee Count = 43
499 Prepare Query again
500
501 EMP_NO = 150
502 FIRST_NAME = Jane
503 LAST_NAME = Doe
504 PHONE_EXT = NULL
505 HIRE_DATE = 1/4/2015 00:00:00.000
506 DEPT_NO = 600
507 JOB_CODE = Eng
508 JOB_GRADE = 4
509 JOB_COUNTRY = England
510 SALARY = 41,000.89
511 FULL_NAME = Doe, Jane
512
513 Prepare Query again with a different transaction
514
515 EMP_NO = 8
516 FIRST_NAME = Leslie
517 LAST_NAME = Johnson
518 PHONE_EXT = 410
519 HIRE_DATE = 5/4/1989 00:00:00.000
520 DEPT_NO = 180
521 JOB_CODE = Mktg
522 JOB_GRADE = 3
523 JOB_COUNTRY = USA
524 SALARY = 64,635.00
525 FULL_NAME = Johnson, Leslie
526
527 Open Cursor with a different transaction
528
529 EMP_NO = 8
530 FIRST_NAME = Leslie
531 LAST_NAME = Johnson
532 PHONE_EXT = 410
533 HIRE_DATE = 5/4/1989 00:00:00.000
534 DEPT_NO = 180
535 JOB_CODE = Mktg
536 JOB_GRADE = 3
537 JOB_COUNTRY = USA
538 SALARY = 64,635.00
539 FULL_NAME = Johnson, Leslie
540 Same Statement - updated params
541 EMP_NO = 9
542 FIRST_NAME = Phil
543 LAST_NAME = Forest
544 PHONE_EXT = 229
545 HIRE_DATE = 17/4/1989 00:00:00.000
546 DEPT_NO = 622
547 JOB_CODE = Mngr
548 JOB_GRADE = 3
549 JOB_COUNTRY = USA
550 SALARY = 75,060.00
551 FULL_NAME = Forest, Phil
552
553
554
555 Running Test 5: Update Returning and Activity Check
556 Opening localhost:employee
557 Database Open
558 Database Closed
559 Database Open
560 Select Count = 1 InsertCount = 0 UpdateCount = 1 DeleteCount = 0
561 Last Name = Johnson
562 EMP_NO = 8
563 FIRST_NAME = Leslie
564 LAST_NAME = Johnson
565 PHONE_EXT = 410
566 HIRE_DATE = 31/1/2016 00:00:00.000
567 DEPT_NO = 180
568 JOB_CODE = Mktg
569 JOB_GRADE = 3
570 JOB_COUNTRY = USA
571 SALARY = 64,635.00
572 FULL_NAME = Johnson, Leslie
573
574 Inserting
575 Full Name = Doe, John
576 Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
577 Database Activity = TRUE
578 Transaction Activity = TRUE
579 Database Activity = FALSE
580 Transaction Activity = FALSE
581 Employee Count = 43
582 Database Activity = TRUE
583 Transaction Activity = TRUE
584 Transaction Active
585 Transaction inactive
586
587
588 Running Test 6: Blob Handling
589 Metadata
590 SQLType =SQL_TEXT
591 sub type = 0
592 Table = RDB$CHARACTER_SETS
593 Owner = SYSDBA
594 Column Name = RDB$CHARACTER_SET_NAME
595 Alias Name = RDB$CHARACTER_SET_NAME
596 Field Name = RDB$CHARACTER_SET_NAME
597 Scale = 0
598 Charset id = 4
599 Nullable
600 Size = 124
601
602 SQLType =SQL_SHORT
603 sub type = 0
604 Table = RDB$CHARACTER_SETS
605 Owner = SYSDBA
606 Column Name = RDB$CHARACTER_SET_ID
607 Alias Name = RDB$CHARACTER_SET_ID
608 Field Name = RDB$CHARACTER_SET_ID
609 Scale = 0
610 Charset id = 0
611 Nullable
612 Size = 2
613
614 RDB$CHARACTER_SET_NAME = NONE (Charset Id = 4 Codepage = 65001)
615 RDB$CHARACTER_SET_ID = 0
616 RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 4 Codepage = 65001)
617 RDB$CHARACTER_SET_ID = 1
618 RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 4 Codepage = 65001)
619 RDB$CHARACTER_SET_ID = 2
620 RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 4 Codepage = 65001)
621 RDB$CHARACTER_SET_ID = 3
622 RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 4 Codepage = 65001)
623 RDB$CHARACTER_SET_ID = 4
624 RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 4 Codepage = 65001)
625 RDB$CHARACTER_SET_ID = 5
626 RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 4 Codepage = 65001)
627 RDB$CHARACTER_SET_ID = 6
628 RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 4 Codepage = 65001)
629 RDB$CHARACTER_SET_ID = 9
630 RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 4 Codepage = 65001)
631 RDB$CHARACTER_SET_ID = 10
632 RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 4 Codepage = 65001)
633 RDB$CHARACTER_SET_ID = 11
634 RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 4 Codepage = 65001)
635 RDB$CHARACTER_SET_ID = 12
636 RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 4 Codepage = 65001)
637 RDB$CHARACTER_SET_ID = 13
638 RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 4 Codepage = 65001)
639 RDB$CHARACTER_SET_ID = 14
640 RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 4 Codepage = 65001)
641 RDB$CHARACTER_SET_ID = 15
642 RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 4 Codepage = 65001)
643 RDB$CHARACTER_SET_ID = 16
644 RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 4 Codepage = 65001)
645 RDB$CHARACTER_SET_ID = 17
646 RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 4 Codepage = 65001)
647 RDB$CHARACTER_SET_ID = 18
648 RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 4 Codepage = 65001)
649 RDB$CHARACTER_SET_ID = 19
650 RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 4 Codepage = 65001)
651 RDB$CHARACTER_SET_ID = 21
652 RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 4 Codepage = 65001)
653 RDB$CHARACTER_SET_ID = 22
654 RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 4 Codepage = 65001)
655 RDB$CHARACTER_SET_ID = 23
656 RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 4 Codepage = 65001)
657 RDB$CHARACTER_SET_ID = 34
658 RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 4 Codepage = 65001)
659 RDB$CHARACTER_SET_ID = 35
660 RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 4 Codepage = 65001)
661 RDB$CHARACTER_SET_ID = 36
662 RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 4 Codepage = 65001)
663 RDB$CHARACTER_SET_ID = 37
664 RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 4 Codepage = 65001)
665 RDB$CHARACTER_SET_ID = 38
666 RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 4 Codepage = 65001)
667 RDB$CHARACTER_SET_ID = 39
668 RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 4 Codepage = 65001)
669 RDB$CHARACTER_SET_ID = 40
670 RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 4 Codepage = 65001)
671 RDB$CHARACTER_SET_ID = 44
672 RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 4 Codepage = 65001)
673 RDB$CHARACTER_SET_ID = 45
674 RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 4 Codepage = 65001)
675 RDB$CHARACTER_SET_ID = 46
676 RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 4 Codepage = 65001)
677 RDB$CHARACTER_SET_ID = 47
678 RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 4 Codepage = 65001)
679 RDB$CHARACTER_SET_ID = 48
680 RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 4 Codepage = 65001)
681 RDB$CHARACTER_SET_ID = 49
682 RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 4 Codepage = 65001)
683 RDB$CHARACTER_SET_ID = 50
684 RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 4 Codepage = 65001)
685 RDB$CHARACTER_SET_ID = 51
686 RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 4 Codepage = 65001)
687 RDB$CHARACTER_SET_ID = 52
688 RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 4 Codepage = 65001)
689 RDB$CHARACTER_SET_ID = 53
690 RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 4 Codepage = 65001)
691 RDB$CHARACTER_SET_ID = 54
692 RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 4 Codepage = 65001)
693 RDB$CHARACTER_SET_ID = 55
694 RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 4 Codepage = 65001)
695 RDB$CHARACTER_SET_ID = 56
696 RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 4 Codepage = 65001)
697 RDB$CHARACTER_SET_ID = 57
698 RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 4 Codepage = 65001)
699 RDB$CHARACTER_SET_ID = 58
700 RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 4 Codepage = 65001)
701 RDB$CHARACTER_SET_ID = 59
702 RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 4 Codepage = 65001)
703 RDB$CHARACTER_SET_ID = 60
704 RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 4 Codepage = 65001)
705 RDB$CHARACTER_SET_ID = 63
706 RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 4 Codepage = 65001)
707 RDB$CHARACTER_SET_ID = 64
708 RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 4 Codepage = 65001)
709 RDB$CHARACTER_SET_ID = 65
710 RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 4 Codepage = 65001)
711 RDB$CHARACTER_SET_ID = 66
712 RDB$CHARACTER_SET_NAME = GBK (Charset Id = 4 Codepage = 65001)
713 RDB$CHARACTER_SET_ID = 67
714 RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 4 Codepage = 65001)
715 RDB$CHARACTER_SET_ID = 68
716 RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 4 Codepage = 65001)
717 RDB$CHARACTER_SET_ID = 69
718
719 Metadata
720 SQLType =SQL_LONG
721 sub type = 0
722 Table = TESTDATA
723 Owner = SYSDBA
724 Column Name = ROWID
725 Alias Name = ROWID
726 Field Name = ROWID
727 Scale = 0
728 Charset id = 0
729 Not Null
730 Size = 4
731
732 SQLType =SQL_LONG
733 sub type = 0
734 Table = TESTDATA
735 Owner = SYSDBA
736 Column Name = FIXEDPOINT
737 Alias Name = FIXEDPOINT
738 Field Name = FIXEDPOINT
739 Scale = -2
740 Charset id = 0
741 Nullable
742 Size = 4
743
744 SQLType =SQL_DOUBLE
745 sub type = 0
746 Table = TESTDATA
747 Owner = SYSDBA
748 Column Name = FLOATINGPOINT
749 Alias Name = FLOATINGPOINT
750 Field Name = FLOATINGPOINT
751 Scale = 0
752 Charset id = 0
753 Nullable
754 Size = 8
755
756 SQLType =SQL_VARYING
757 sub type = 0
758 Table = TESTDATA
759 Owner = SYSDBA
760 Column Name = TITLE
761 Alias Name = TITLE
762 Field Name = TITLE
763 Scale = 0
764 Charset id = 4
765 Nullable
766 Size = 128
767
768 SQLType =SQL_BLOB
769 sub type = 1
770 Table = TESTDATA
771 Owner = SYSDBA
772 Column Name = BLOBDATA
773 Alias Name = BLOBDATA
774 Field Name = BLOBDATA
775 Scale = 0
776 Charset id = 4
777 Nullable
778 Size = 8
779
780 Blob Meta Data
781 SQL SubType =1
782 Table = TESTDATA
783 Column = BLOBDATA
784 CharSetID = 4
785 Segment Size = 80
786
787
788 SQL Params
789 SQLType =SQL_LONG
790 sub type = 0
791 Field Name = ROWID
792 Scale = 0
793 Charset id = 0
794 Not Null
795 Size = 4
796
797 SQLType =SQL_VARYING
798 sub type = 0
799 Field Name = TITLE
800 Scale = 0
801 Charset id = 4
802 Nullable
803 Size = 128
804
805 SQLType =SQL_LONG
806 sub type = 0
807 Field Name = FP
808 Scale = -2
809 Charset id = 0
810 Nullable
811 Size = 4
812
813 SQLType =SQL_DOUBLE
814 sub type = 0
815 Field Name = DP
816 Scale = 0
817 Charset id = 0
818 Nullable
819 Size = 8
820
821 ROWID = 1
822 FIXEDPOINT = 20.28
823 FLOATINGPOINT = 3.14
824 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
825 BLOBDATA = NULL
826
827 SQL Params
828 SQLType =SQL_BLOB
829 sub type = 1
830 Field Name =
831 Scale = 0
832 Charset id = 4
833 Nullable
834 Size = 8
835
836 SQLType =SQL_LONG
837 sub type = 0
838 Field Name =
839 Scale = 0
840 Charset id = 0
841 Not Null
842 Size = 4
843
844 ROWID = 1
845 FIXEDPOINT = 20.28
846 FLOATINGPOINT = 3.14
847 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
848 BLOBDATA (Charset Id = 4 Codepage = 65001)
849
850 To be or not to be-that is the question:
851 Whether 'tis nobler in the mind to suffer
852 The slings and arrows of outrageous fortune,
853 Or to take arms against a sea of troubles,
854 And, by opposing, end them. To die, to sleep-
855 No more-and by a sleep to say we end
856 The heartache and the thousand natural shocks
857 That flesh is heir to-'tis a consummation
858 Devoutly to be wished. To die, to sleep-
859 To sleep, perchance to dream. Aye, there's the rub,
860 For in that sleep of death what dreams may come,
861 When we have shuffled off this mortal coil,
862 Must give us pause. There's the respect
863 That makes calamity of so long life.
864 For who would bear the whips and scorns of time,
865 Th' oppressor's wrong, the proud man's contumely,
866 The pangs of despised love, the law’s delay,
867 The insolence of office, and the spurns
868 That patient merit of the unworthy takes,
869 When he himself might his quietus make
870 With a bare bodkin? Who would fardels bear,
871 To grunt and sweat under a weary life,
872 But that the dread of something after death,
873 The undiscovered country from whose bourn
874 No traveler returns, puzzles the will
875 And makes us rather bear those ills we have
876 Than fly to others that we know not of?
877 Thus conscience does make cowards of us all,
878 And thus the native hue of resolution
879 Is sicklied o'er with the pale cast of thought,
880 And enterprises of great pitch and moment,
881 With this regard their currents turn awry,
882 And lose the name of action.-Soft you now,
883 The fair Ophelia.-Nymph, in thy orisons
884 Be all my sins remembered
885
886
887 SQL Params
888 SQLType =SQL_LONG
889 sub type = 0
890 Field Name = ROWID
891 Scale = 0
892 Charset id = 0
893 Not Null
894 Size = 4
895
896 SQLType =SQL_VARYING
897 sub type = 0
898 Field Name = TITLE
899 Scale = 0
900 Charset id = 4
901 Nullable
902 Size = 128
903
904 SQLType =SQL_LONG
905 sub type = 0
906 Field Name = FP
907 Scale = -2
908 Charset id = 0
909 Nullable
910 Size = 4
911
912 SQLType =SQL_DOUBLE
913 sub type = 0
914 Field Name = DP
915 Scale = 0
916 Charset id = 0
917 Nullable
918 Size = 8
919
920 ROWID = 1
921 FIXEDPOINT = 20.28
922 FLOATINGPOINT = 3.14
923 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
924 BLOBDATA (Charset Id = 4 Codepage = 65001)
925
926 To be or not to be-that is the question:
927 Whether 'tis nobler in the mind to suffer
928 The slings and arrows of outrageous fortune,
929 Or to take arms against a sea of troubles,
930 And, by opposing, end them. To die, to sleep-
931 No more-and by a sleep to say we end
932 The heartache and the thousand natural shocks
933 That flesh is heir to-'tis a consummation
934 Devoutly to be wished. To die, to sleep-
935 To sleep, perchance to dream. Aye, there's the rub,
936 For in that sleep of death what dreams may come,
937 When we have shuffled off this mortal coil,
938 Must give us pause. There's the respect
939 That makes calamity of so long life.
940 For who would bear the whips and scorns of time,
941 Th' oppressor's wrong, the proud man's contumely,
942 The pangs of despised love, the law’s delay,
943 The insolence of office, and the spurns
944 That patient merit of the unworthy takes,
945 When he himself might his quietus make
946 With a bare bodkin? Who would fardels bear,
947 To grunt and sweat under a weary life,
948 But that the dread of something after death,
949 The undiscovered country from whose bourn
950 No traveler returns, puzzles the will
951 And makes us rather bear those ills we have
952 Than fly to others that we know not of?
953 Thus conscience does make cowards of us all,
954 And thus the native hue of resolution
955 Is sicklied o'er with the pale cast of thought,
956 And enterprises of great pitch and moment,
957 With this regard their currents turn awry,
958 And lose the name of action.-Soft you now,
959 The fair Ophelia.-Nymph, in thy orisons
960 Be all my sins remembered
961
962 ROWID = 2
963 FIXEDPOINT = NULL
964 FLOATINGPOINT = NULL
965 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
966 BLOBDATA (Charset Id = 4 Codepage = 65001)
967
968 To be or not to be-that is the question:
969 Whether 'tis nobler in the mind to suffer
970 The slings and arrows of outrageous fortune,
971 Or to take arms against a sea of troubles,
972 And, by opposing, end them. To die, to sleep-
973 No more-and by a sleep to say we end
974 The heartache and the thousand natural shocks
975 That flesh is heir to-'tis a consummation
976 Devoutly to be wished. To die, to sleep-
977 To sleep, perchance to dream. Aye, there's the rub,
978 For in that sleep of death what dreams may come,
979 When we have shuffled off this mortal coil,
980 Must give us pause. There's the respect
981 That makes calamity of so long life.
982 For who would bear the whips and scorns of time,
983 Th' oppressor's wrong, the proud man's contumely,
984 The pangs of despised love, the law’s delay,
985 The insolence of office, and the spurns
986 That patient merit of the unworthy takes,
987 When he himself might his quietus make
988 With a bare bodkin? Who would fardels bear,
989 To grunt and sweat under a weary life,
990 But that the dread of something after death,
991 The undiscovered country from whose bourn
992 No traveler returns, puzzles the will
993 And makes us rather bear those ills we have
994 Than fly to others that we know not of?
995 Thus conscience does make cowards of us all,
996 And thus the native hue of resolution
997 Is sicklied o'er with the pale cast of thought,
998 And enterprises of great pitch and moment,
999 With this regard their currents turn awry,
1000 And lose the name of action.-Soft you now,
1001 The fair Ophelia.-Nymph, in thy orisons
1002 Be all my sins remembered
1003
1004
1005 Testing Blob as stored proc parameter
1006 Metadata
1007 SQLType =SQL_BLOB
1008 sub type = 1
1009 Table = TESTPROC
1010 Owner = SYSDBA
1011 Column Name = BLOBDATA
1012 Alias Name = BLOBDATA
1013 Field Name = BLOBDATA
1014 Scale = 0
1015 Charset id = 4
1016 Nullable
1017 Size = 8
1018
1019 Blob Meta Data
1020 SQL SubType =1
1021 Table = TESTPROC
1022 Column = BLOBDATA
1023 CharSetID = 4
1024 Segment Size = 80
1025
1026
1027 BLOBDATA (Charset Id = 4 Codepage = 65001)
1028
1029 To be or not to be-that is the question:
1030 Whether 'tis nobler in the mind to suffer
1031 The slings and arrows of outrageous fortune,
1032 Or to take arms against a sea of troubles,
1033 And, by opposing, end them. To die, to sleep-
1034 No more-and by a sleep to say we end
1035 The heartache and the thousand natural shocks
1036 That flesh is heir to-'tis a consummation
1037 Devoutly to be wished. To die, to sleep-
1038 To sleep, perchance to dream. Aye, there's the rub,
1039 For in that sleep of death what dreams may come,
1040 When we have shuffled off this mortal coil,
1041 Must give us pause. There's the respect
1042 That makes calamity of so long life.
1043 For who would bear the whips and scorns of time,
1044 Th' oppressor's wrong, the proud man's contumely,
1045 The pangs of despised love, the law’s delay,
1046 The insolence of office, and the spurns
1047 That patient merit of the unworthy takes,
1048 When he himself might his quietus make
1049 With a bare bodkin? Who would fardels bear,
1050 To grunt and sweat under a weary life,
1051 But that the dread of something after death,
1052 The undiscovered country from whose bourn
1053 No traveler returns, puzzles the will
1054 And makes us rather bear those ills we have
1055 Than fly to others that we know not of?
1056 Thus conscience does make cowards of us all,
1057 And thus the native hue of resolution
1058 Is sicklied o'er with the pale cast of thought,
1059 And enterprises of great pitch and moment,
1060 With this regard their currents turn awry,
1061 And lose the name of action.-Soft you now,
1062 The fair Ophelia.-Nymph, in thy orisons
1063 Be all my sins remembered
1064
1065 Metadata
1066 SQLType =SQL_TEXT
1067 sub type = 0
1068 Table = RDB$CHARACTER_SETS
1069 Owner = SYSDBA
1070 Column Name = RDB$CHARACTER_SET_NAME
1071 Alias Name = RDB$CHARACTER_SET_NAME
1072 Field Name = RDB$CHARACTER_SET_NAME
1073 Scale = 0
1074 Charset id = 53
1075 Nullable
1076 Size = 31
1077
1078 SQLType =SQL_SHORT
1079 sub type = 0
1080 Table = RDB$CHARACTER_SETS
1081 Owner = SYSDBA
1082 Column Name = RDB$CHARACTER_SET_ID
1083 Alias Name = RDB$CHARACTER_SET_ID
1084 Field Name = RDB$CHARACTER_SET_ID
1085 Scale = 0
1086 Charset id = 0
1087 Nullable
1088 Size = 2
1089
1090 RDB$CHARACTER_SET_NAME = NONE (Charset Id = 53 Codepage = 1252)
1091 RDB$CHARACTER_SET_ID = 0
1092 RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 53 Codepage = 1252)
1093 RDB$CHARACTER_SET_ID = 1
1094 RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 53 Codepage = 1252)
1095 RDB$CHARACTER_SET_ID = 2
1096 RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 53 Codepage = 1252)
1097 RDB$CHARACTER_SET_ID = 3
1098 RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 53 Codepage = 1252)
1099 RDB$CHARACTER_SET_ID = 4
1100 RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 53 Codepage = 1252)
1101 RDB$CHARACTER_SET_ID = 5
1102 RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 53 Codepage = 1252)
1103 RDB$CHARACTER_SET_ID = 6
1104 RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 53 Codepage = 1252)
1105 RDB$CHARACTER_SET_ID = 9
1106 RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 53 Codepage = 1252)
1107 RDB$CHARACTER_SET_ID = 10
1108 RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 53 Codepage = 1252)
1109 RDB$CHARACTER_SET_ID = 11
1110 RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 53 Codepage = 1252)
1111 RDB$CHARACTER_SET_ID = 12
1112 RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 53 Codepage = 1252)
1113 RDB$CHARACTER_SET_ID = 13
1114 RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 53 Codepage = 1252)
1115 RDB$CHARACTER_SET_ID = 14
1116 RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 53 Codepage = 1252)
1117 RDB$CHARACTER_SET_ID = 15
1118 RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 53 Codepage = 1252)
1119 RDB$CHARACTER_SET_ID = 16
1120 RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 53 Codepage = 1252)
1121 RDB$CHARACTER_SET_ID = 17
1122 RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 53 Codepage = 1252)
1123 RDB$CHARACTER_SET_ID = 18
1124 RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 53 Codepage = 1252)
1125 RDB$CHARACTER_SET_ID = 19
1126 RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 53 Codepage = 1252)
1127 RDB$CHARACTER_SET_ID = 21
1128 RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 53 Codepage = 1252)
1129 RDB$CHARACTER_SET_ID = 22
1130 RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 53 Codepage = 1252)
1131 RDB$CHARACTER_SET_ID = 23
1132 RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 53 Codepage = 1252)
1133 RDB$CHARACTER_SET_ID = 34
1134 RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 53 Codepage = 1252)
1135 RDB$CHARACTER_SET_ID = 35
1136 RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 53 Codepage = 1252)
1137 RDB$CHARACTER_SET_ID = 36
1138 RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 53 Codepage = 1252)
1139 RDB$CHARACTER_SET_ID = 37
1140 RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 53 Codepage = 1252)
1141 RDB$CHARACTER_SET_ID = 38
1142 RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 53 Codepage = 1252)
1143 RDB$CHARACTER_SET_ID = 39
1144 RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 53 Codepage = 1252)
1145 RDB$CHARACTER_SET_ID = 40
1146 RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 53 Codepage = 1252)
1147 RDB$CHARACTER_SET_ID = 44
1148 RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 53 Codepage = 1252)
1149 RDB$CHARACTER_SET_ID = 45
1150 RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 53 Codepage = 1252)
1151 RDB$CHARACTER_SET_ID = 46
1152 RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 53 Codepage = 1252)
1153 RDB$CHARACTER_SET_ID = 47
1154 RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 53 Codepage = 1252)
1155 RDB$CHARACTER_SET_ID = 48
1156 RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 53 Codepage = 1252)
1157 RDB$CHARACTER_SET_ID = 49
1158 RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 53 Codepage = 1252)
1159 RDB$CHARACTER_SET_ID = 50
1160 RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 53 Codepage = 1252)
1161 RDB$CHARACTER_SET_ID = 51
1162 RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 53 Codepage = 1252)
1163 RDB$CHARACTER_SET_ID = 52
1164 RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 53 Codepage = 1252)
1165 RDB$CHARACTER_SET_ID = 53
1166 RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 53 Codepage = 1252)
1167 RDB$CHARACTER_SET_ID = 54
1168 RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 53 Codepage = 1252)
1169 RDB$CHARACTER_SET_ID = 55
1170 RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 53 Codepage = 1252)
1171 RDB$CHARACTER_SET_ID = 56
1172 RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 53 Codepage = 1252)
1173 RDB$CHARACTER_SET_ID = 57
1174 RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 53 Codepage = 1252)
1175 RDB$CHARACTER_SET_ID = 58
1176 RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 53 Codepage = 1252)
1177 RDB$CHARACTER_SET_ID = 59
1178 RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 53 Codepage = 1252)
1179 RDB$CHARACTER_SET_ID = 60
1180 RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 53 Codepage = 1252)
1181 RDB$CHARACTER_SET_ID = 63
1182 RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 53 Codepage = 1252)
1183 RDB$CHARACTER_SET_ID = 64
1184 RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 53 Codepage = 1252)
1185 RDB$CHARACTER_SET_ID = 65
1186 RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 53 Codepage = 1252)
1187 RDB$CHARACTER_SET_ID = 66
1188 RDB$CHARACTER_SET_NAME = GBK (Charset Id = 53 Codepage = 1252)
1189 RDB$CHARACTER_SET_ID = 67
1190 RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 53 Codepage = 1252)
1191 RDB$CHARACTER_SET_ID = 68
1192 RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 53 Codepage = 1252)
1193 RDB$CHARACTER_SET_ID = 69
1194
1195 Metadata
1196 SQLType =SQL_LONG
1197 sub type = 0
1198 Table = TESTDATA
1199 Owner = SYSDBA
1200 Column Name = ROWID
1201 Alias Name = ROWID
1202 Field Name = ROWID
1203 Scale = 0
1204 Charset id = 0
1205 Not Null
1206 Size = 4
1207
1208 SQLType =SQL_LONG
1209 sub type = 0
1210 Table = TESTDATA
1211 Owner = SYSDBA
1212 Column Name = FIXEDPOINT
1213 Alias Name = FIXEDPOINT
1214 Field Name = FIXEDPOINT
1215 Scale = -2
1216 Charset id = 0
1217 Nullable
1218 Size = 4
1219
1220 SQLType =SQL_DOUBLE
1221 sub type = 0
1222 Table = TESTDATA
1223 Owner = SYSDBA
1224 Column Name = FLOATINGPOINT
1225 Alias Name = FLOATINGPOINT
1226 Field Name = FLOATINGPOINT
1227 Scale = 0
1228 Charset id = 0
1229 Nullable
1230 Size = 8
1231
1232 SQLType =SQL_VARYING
1233 sub type = 0
1234 Table = TESTDATA
1235 Owner = SYSDBA
1236 Column Name = TITLE
1237 Alias Name = TITLE
1238 Field Name = TITLE
1239 Scale = 0
1240 Charset id = 53
1241 Nullable
1242 Size = 32
1243
1244 SQLType =SQL_BLOB
1245 sub type = 1
1246 Table = TESTDATA
1247 Owner = SYSDBA
1248 Column Name = BLOBDATA
1249 Alias Name = BLOBDATA
1250 Field Name = BLOBDATA
1251 Scale = 0
1252 Charset id = 53
1253 Nullable
1254 Size = 8
1255
1256 Blob Meta Data
1257 SQL SubType =1
1258 Table = TESTDATA
1259 Column = BLOBDATA
1260 CharSetID = 53
1261 Segment Size = 80
1262
1263
1264 SQL Params
1265 SQLType =SQL_LONG
1266 sub type = 0
1267 Field Name = ROWID
1268 Scale = 0
1269 Charset id = 0
1270 Not Null
1271 Size = 4
1272
1273 SQLType =SQL_VARYING
1274 sub type = 0
1275 Field Name = TITLE
1276 Scale = 0
1277 Charset id = 53
1278 Nullable
1279 Size = 32
1280
1281 SQLType =SQL_LONG
1282 sub type = 0
1283 Field Name = FP
1284 Scale = -2
1285 Charset id = 0
1286 Nullable
1287 Size = 4
1288
1289 SQLType =SQL_DOUBLE
1290 sub type = 0
1291 Field Name = DP
1292 Scale = 0
1293 Charset id = 0
1294 Nullable
1295 Size = 8
1296
1297 ROWID = 1
1298 FIXEDPOINT = 20.28
1299 FLOATINGPOINT = 3.14
1300 TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1301 BLOBDATA = NULL
1302
1303 SQL Params
1304 SQLType =SQL_BLOB
1305 sub type = 1
1306 Field Name =
1307 Scale = 0
1308 Charset id = 53
1309 Nullable
1310 Size = 8
1311
1312 SQLType =SQL_LONG
1313 sub type = 0
1314 Field Name =
1315 Scale = 0
1316 Charset id = 0
1317 Not Null
1318 Size = 4
1319
1320 ROWID = 1
1321 FIXEDPOINT = 20.28
1322 FLOATINGPOINT = 3.14
1323 TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1324 BLOBDATA (Charset Id = 53 Codepage = 1252)
1325
1326 To be or not to be-that is the question:
1327 Whether 'tis nobler in the mind to suffer
1328 The slings and arrows of outrageous fortune,
1329 Or to take arms against a sea of troubles,
1330 And, by opposing, end them. To die, to sleep-
1331 No more-and by a sleep to say we end
1332 The heartache and the thousand natural shocks
1333 That flesh is heir to-'tis a consummation
1334 Devoutly to be wished. To die, to sleep-
1335 To sleep, perchance to dream. Aye, there's the rub,
1336 For in that sleep of death what dreams may come,
1337 When we have shuffled off this mortal coil,
1338 Must give us pause. There's the respect
1339 That makes calamity of so long life.
1340 For who would bear the whips and scorns of time,
1341 Th' oppressor's wrong, the proud man's contumely,
1342 The pangs of despised love, the law’s delay,
1343 The insolence of office, and the spurns
1344 That patient merit of the unworthy takes,
1345 When he himself might his quietus make
1346 With a bare bodkin? Who would fardels bear,
1347 To grunt and sweat under a weary life,
1348 But that the dread of something after death,
1349 The undiscovered country from whose bourn
1350 No traveler returns, puzzles the will
1351 And makes us rather bear those ills we have
1352 Than fly to others that we know not of?
1353 Thus conscience does make cowards of us all,
1354 And thus the native hue of resolution
1355 Is sicklied o'er with the pale cast of thought,
1356 And enterprises of great pitch and moment,
1357 With this regard their currents turn awry,
1358 And lose the name of action.-Soft you now,
1359 The fair Ophelia.-Nymph, in thy orisons
1360 Be all my sins remembered
1361
1362
1363 SQL Params
1364 SQLType =SQL_LONG
1365 sub type = 0
1366 Field Name = ROWID
1367 Scale = 0
1368 Charset id = 0
1369 Not Null
1370 Size = 4
1371
1372 SQLType =SQL_VARYING
1373 sub type = 0
1374 Field Name = TITLE
1375 Scale = 0
1376 Charset id = 53
1377 Nullable
1378 Size = 32
1379
1380 SQLType =SQL_LONG
1381 sub type = 0
1382 Field Name = FP
1383 Scale = -2
1384 Charset id = 0
1385 Nullable
1386 Size = 4
1387
1388 SQLType =SQL_DOUBLE
1389 sub type = 0
1390 Field Name = DP
1391 Scale = 0
1392 Charset id = 0
1393 Nullable
1394 Size = 8
1395
1396 ROWID = 1
1397 FIXEDPOINT = 20.28
1398 FLOATINGPOINT = 3.14
1399 TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1400 BLOBDATA (Charset Id = 53 Codepage = 1252)
1401
1402 To be or not to be-that is the question:
1403 Whether 'tis nobler in the mind to suffer
1404 The slings and arrows of outrageous fortune,
1405 Or to take arms against a sea of troubles,
1406 And, by opposing, end them. To die, to sleep-
1407 No more-and by a sleep to say we end
1408 The heartache and the thousand natural shocks
1409 That flesh is heir to-'tis a consummation
1410 Devoutly to be wished. To die, to sleep-
1411 To sleep, perchance to dream. Aye, there's the rub,
1412 For in that sleep of death what dreams may come,
1413 When we have shuffled off this mortal coil,
1414 Must give us pause. There's the respect
1415 That makes calamity of so long life.
1416 For who would bear the whips and scorns of time,
1417 Th' oppressor's wrong, the proud man's contumely,
1418 The pangs of despised love, the law’s delay,
1419 The insolence of office, and the spurns
1420 That patient merit of the unworthy takes,
1421 When he himself might his quietus make
1422 With a bare bodkin? Who would fardels bear,
1423 To grunt and sweat under a weary life,
1424 But that the dread of something after death,
1425 The undiscovered country from whose bourn
1426 No traveler returns, puzzles the will
1427 And makes us rather bear those ills we have
1428 Than fly to others that we know not of?
1429 Thus conscience does make cowards of us all,
1430 And thus the native hue of resolution
1431 Is sicklied o'er with the pale cast of thought,
1432 And enterprises of great pitch and moment,
1433 With this regard their currents turn awry,
1434 And lose the name of action.-Soft you now,
1435 The fair Ophelia.-Nymph, in thy orisons
1436 Be all my sins remembered
1437
1438 ROWID = 2
1439 FIXEDPOINT = NULL
1440 FLOATINGPOINT = NULL
1441 TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1442 BLOBDATA (Charset Id = 53 Codepage = 1252)
1443
1444 To be or not to be-that is the question:
1445 Whether 'tis nobler in the mind to suffer
1446 The slings and arrows of outrageous fortune,
1447 Or to take arms against a sea of troubles,
1448 And, by opposing, end them. To die, to sleep-
1449 No more-and by a sleep to say we end
1450 The heartache and the thousand natural shocks
1451 That flesh is heir to-'tis a consummation
1452 Devoutly to be wished. To die, to sleep-
1453 To sleep, perchance to dream. Aye, there's the rub,
1454 For in that sleep of death what dreams may come,
1455 When we have shuffled off this mortal coil,
1456 Must give us pause. There's the respect
1457 That makes calamity of so long life.
1458 For who would bear the whips and scorns of time,
1459 Th' oppressor's wrong, the proud man's contumely,
1460 The pangs of despised love, the law’s delay,
1461 The insolence of office, and the spurns
1462 That patient merit of the unworthy takes,
1463 When he himself might his quietus make
1464 With a bare bodkin? Who would fardels bear,
1465 To grunt and sweat under a weary life,
1466 But that the dread of something after death,
1467 The undiscovered country from whose bourn
1468 No traveler returns, puzzles the will
1469 And makes us rather bear those ills we have
1470 Than fly to others that we know not of?
1471 Thus conscience does make cowards of us all,
1472 And thus the native hue of resolution
1473 Is sicklied o'er with the pale cast of thought,
1474 And enterprises of great pitch and moment,
1475 With this regard their currents turn awry,
1476 And lose the name of action.-Soft you now,
1477 The fair Ophelia.-Nymph, in thy orisons
1478 Be all my sins remembered
1479
1480
1481 Testing Blob as stored proc parameter
1482 Metadata
1483 SQLType =SQL_BLOB
1484 sub type = 1
1485 Table = TESTPROC
1486 Owner = SYSDBA
1487 Column Name = BLOBDATA
1488 Alias Name = BLOBDATA
1489 Field Name = BLOBDATA
1490 Scale = 0
1491 Charset id = 53
1492 Nullable
1493 Size = 8
1494
1495 Blob Meta Data
1496 SQL SubType =1
1497 Table = TESTPROC
1498 Column = BLOBDATA
1499 CharSetID = 53
1500 Segment Size = 80
1501
1502
1503 BLOBDATA (Charset Id = 53 Codepage = 1252)
1504
1505 To be or not to be-that is the question:
1506 Whether 'tis nobler in the mind to suffer
1507 The slings and arrows of outrageous fortune,
1508 Or to take arms against a sea of troubles,
1509 And, by opposing, end them. To die, to sleep-
1510 No more-and by a sleep to say we end
1511 The heartache and the thousand natural shocks
1512 That flesh is heir to-'tis a consummation
1513 Devoutly to be wished. To die, to sleep-
1514 To sleep, perchance to dream. Aye, there's the rub,
1515 For in that sleep of death what dreams may come,
1516 When we have shuffled off this mortal coil,
1517 Must give us pause. There's the respect
1518 That makes calamity of so long life.
1519 For who would bear the whips and scorns of time,
1520 Th' oppressor's wrong, the proud man's contumely,
1521 The pangs of despised love, the law’s delay,
1522 The insolence of office, and the spurns
1523 That patient merit of the unworthy takes,
1524 When he himself might his quietus make
1525 With a bare bodkin? Who would fardels bear,
1526 To grunt and sweat under a weary life,
1527 But that the dread of something after death,
1528 The undiscovered country from whose bourn
1529 No traveler returns, puzzles the will
1530 And makes us rather bear those ills we have
1531 Than fly to others that we know not of?
1532 Thus conscience does make cowards of us all,
1533 And thus the native hue of resolution
1534 Is sicklied o'er with the pale cast of thought,
1535 And enterprises of great pitch and moment,
1536 With this regard their currents turn awry,
1537 And lose the name of action.-Soft you now,
1538 The fair Ophelia.-Nymph, in thy orisons
1539 Be all my sins remembered
1540
1541 Metadata
1542 SQLType =SQL_TEXT
1543 sub type = 0
1544 Table = RDB$CHARACTER_SETS
1545 Owner = SYSDBA
1546 Column Name = RDB$CHARACTER_SET_NAME
1547 Alias Name = RDB$CHARACTER_SET_NAME
1548 Field Name = RDB$CHARACTER_SET_NAME
1549 Scale = 0
1550 Charset id = 3
1551 Nullable
1552 Size = 93
1553
1554 SQLType =SQL_SHORT
1555 sub type = 0
1556 Table = RDB$CHARACTER_SETS
1557 Owner = SYSDBA
1558 Column Name = RDB$CHARACTER_SET_ID
1559 Alias Name = RDB$CHARACTER_SET_ID
1560 Field Name = RDB$CHARACTER_SET_ID
1561 Scale = 0
1562 Charset id = 0
1563 Nullable
1564 Size = 2
1565
1566 RDB$CHARACTER_SET_NAME = NONE (Charset Id = 3 Codepage = 65001)
1567 RDB$CHARACTER_SET_ID = 0
1568 RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 3 Codepage = 65001)
1569 RDB$CHARACTER_SET_ID = 1
1570 RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 3 Codepage = 65001)
1571 RDB$CHARACTER_SET_ID = 2
1572 RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 3 Codepage = 65001)
1573 RDB$CHARACTER_SET_ID = 3
1574 RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 3 Codepage = 65001)
1575 RDB$CHARACTER_SET_ID = 4
1576 RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 3 Codepage = 65001)
1577 RDB$CHARACTER_SET_ID = 5
1578 RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 3 Codepage = 65001)
1579 RDB$CHARACTER_SET_ID = 6
1580 RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 3 Codepage = 65001)
1581 RDB$CHARACTER_SET_ID = 9
1582 RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 3 Codepage = 65001)
1583 RDB$CHARACTER_SET_ID = 10
1584 RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 3 Codepage = 65001)
1585 RDB$CHARACTER_SET_ID = 11
1586 RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 3 Codepage = 65001)
1587 RDB$CHARACTER_SET_ID = 12
1588 RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 3 Codepage = 65001)
1589 RDB$CHARACTER_SET_ID = 13
1590 RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 3 Codepage = 65001)
1591 RDB$CHARACTER_SET_ID = 14
1592 RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 3 Codepage = 65001)
1593 RDB$CHARACTER_SET_ID = 15
1594 RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 3 Codepage = 65001)
1595 RDB$CHARACTER_SET_ID = 16
1596 RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 3 Codepage = 65001)
1597 RDB$CHARACTER_SET_ID = 17
1598 RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 3 Codepage = 65001)
1599 RDB$CHARACTER_SET_ID = 18
1600 RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 3 Codepage = 65001)
1601 RDB$CHARACTER_SET_ID = 19
1602 RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 3 Codepage = 65001)
1603 RDB$CHARACTER_SET_ID = 21
1604 RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 3 Codepage = 65001)
1605 RDB$CHARACTER_SET_ID = 22
1606 RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 3 Codepage = 65001)
1607 RDB$CHARACTER_SET_ID = 23
1608 RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 3 Codepage = 65001)
1609 RDB$CHARACTER_SET_ID = 34
1610 RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 3 Codepage = 65001)
1611 RDB$CHARACTER_SET_ID = 35
1612 RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 3 Codepage = 65001)
1613 RDB$CHARACTER_SET_ID = 36
1614 RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 3 Codepage = 65001)
1615 RDB$CHARACTER_SET_ID = 37
1616 RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 3 Codepage = 65001)
1617 RDB$CHARACTER_SET_ID = 38
1618 RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 3 Codepage = 65001)
1619 RDB$CHARACTER_SET_ID = 39
1620 RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 3 Codepage = 65001)
1621 RDB$CHARACTER_SET_ID = 40
1622 RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 3 Codepage = 65001)
1623 RDB$CHARACTER_SET_ID = 44
1624 RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 3 Codepage = 65001)
1625 RDB$CHARACTER_SET_ID = 45
1626 RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 3 Codepage = 65001)
1627 RDB$CHARACTER_SET_ID = 46
1628 RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 3 Codepage = 65001)
1629 RDB$CHARACTER_SET_ID = 47
1630 RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 3 Codepage = 65001)
1631 RDB$CHARACTER_SET_ID = 48
1632 RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 3 Codepage = 65001)
1633 RDB$CHARACTER_SET_ID = 49
1634 RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 3 Codepage = 65001)
1635 RDB$CHARACTER_SET_ID = 50
1636 RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 3 Codepage = 65001)
1637 RDB$CHARACTER_SET_ID = 51
1638 RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 3 Codepage = 65001)
1639 RDB$CHARACTER_SET_ID = 52
1640 RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 3 Codepage = 65001)
1641 RDB$CHARACTER_SET_ID = 53
1642 RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 3 Codepage = 65001)
1643 RDB$CHARACTER_SET_ID = 54
1644 RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 3 Codepage = 65001)
1645 RDB$CHARACTER_SET_ID = 55
1646 RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 3 Codepage = 65001)
1647 RDB$CHARACTER_SET_ID = 56
1648 RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 3 Codepage = 65001)
1649 RDB$CHARACTER_SET_ID = 57
1650 RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 3 Codepage = 65001)
1651 RDB$CHARACTER_SET_ID = 58
1652 RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 3 Codepage = 65001)
1653 RDB$CHARACTER_SET_ID = 59
1654 RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 3 Codepage = 65001)
1655 RDB$CHARACTER_SET_ID = 60
1656 RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 3 Codepage = 65001)
1657 RDB$CHARACTER_SET_ID = 63
1658 RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 3 Codepage = 65001)
1659 RDB$CHARACTER_SET_ID = 64
1660 RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 3 Codepage = 65001)
1661 RDB$CHARACTER_SET_ID = 65
1662 RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 3 Codepage = 65001)
1663 RDB$CHARACTER_SET_ID = 66
1664 RDB$CHARACTER_SET_NAME = GBK (Charset Id = 3 Codepage = 65001)
1665 RDB$CHARACTER_SET_ID = 67
1666 RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 3 Codepage = 65001)
1667 RDB$CHARACTER_SET_ID = 68
1668 RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 3 Codepage = 65001)
1669 RDB$CHARACTER_SET_ID = 69
1670
1671 Metadata
1672 SQLType =SQL_LONG
1673 sub type = 0
1674 Table = TESTDATA
1675 Owner = SYSDBA
1676 Column Name = ROWID
1677 Alias Name = ROWID
1678 Field Name = ROWID
1679 Scale = 0
1680 Charset id = 0
1681 Not Null
1682 Size = 4
1683
1684 SQLType =SQL_LONG
1685 sub type = 0
1686 Table = TESTDATA
1687 Owner = SYSDBA
1688 Column Name = FIXEDPOINT
1689 Alias Name = FIXEDPOINT
1690 Field Name = FIXEDPOINT
1691 Scale = -2
1692 Charset id = 0
1693 Nullable
1694 Size = 4
1695
1696 SQLType =SQL_DOUBLE
1697 sub type = 0
1698 Table = TESTDATA
1699 Owner = SYSDBA
1700 Column Name = FLOATINGPOINT
1701 Alias Name = FLOATINGPOINT
1702 Field Name = FLOATINGPOINT
1703 Scale = 0
1704 Charset id = 0
1705 Nullable
1706 Size = 8
1707
1708 SQLType =SQL_VARYING
1709 sub type = 0
1710 Table = TESTDATA
1711 Owner = SYSDBA
1712 Column Name = TITLE
1713 Alias Name = TITLE
1714 Field Name = TITLE
1715 Scale = 0
1716 Charset id = 4
1717 Nullable
1718 Size = 128
1719
1720 SQLType =SQL_BLOB
1721 sub type = 1
1722 Table = TESTDATA
1723 Owner = SYSDBA
1724 Column Name = BLOBDATA
1725 Alias Name = BLOBDATA
1726 Field Name = BLOBDATA
1727 Scale = 0
1728 Charset id = 4
1729 Nullable
1730 Size = 8
1731
1732 Blob Meta Data
1733 SQL SubType =1
1734 Table = TESTDATA
1735 Column = BLOBDATA
1736 CharSetID = 4
1737 Segment Size = 80
1738
1739
1740 SQL Params
1741 SQLType =SQL_LONG
1742 sub type = 0
1743 Field Name = ROWID
1744 Scale = 0
1745 Charset id = 0
1746 Not Null
1747 Size = 4
1748
1749 SQLType =SQL_VARYING
1750 sub type = 0
1751 Field Name = TITLE
1752 Scale = 0
1753 Charset id = 4
1754 Nullable
1755 Size = 128
1756
1757 SQLType =SQL_LONG
1758 sub type = 0
1759 Field Name = FP
1760 Scale = -2
1761 Charset id = 0
1762 Nullable
1763 Size = 4
1764
1765 SQLType =SQL_DOUBLE
1766 sub type = 0
1767 Field Name = DP
1768 Scale = 0
1769 Charset id = 0
1770 Nullable
1771 Size = 8
1772
1773 ROWID = 1
1774 FIXEDPOINT = 20.28
1775 FLOATINGPOINT = 3.14
1776 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1777 BLOBDATA = NULL
1778
1779 SQL Params
1780 SQLType =SQL_BLOB
1781 sub type = 1
1782 Field Name =
1783 Scale = 0
1784 Charset id = 4
1785 Nullable
1786 Size = 8
1787
1788 SQLType =SQL_LONG
1789 sub type = 0
1790 Field Name =
1791 Scale = 0
1792 Charset id = 0
1793 Not Null
1794 Size = 4
1795
1796 ROWID = 1
1797 FIXEDPOINT = 20.28
1798 FLOATINGPOINT = 3.14
1799 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1800 BLOBDATA (Charset Id = 4 Codepage = 65001)
1801
1802 To be or not to be-that is the question:
1803 Whether 'tis nobler in the mind to suffer
1804 The slings and arrows of outrageous fortune,
1805 Or to take arms against a sea of troubles,
1806 And, by opposing, end them. To die, to sleep-
1807 No more-and by a sleep to say we end
1808 The heartache and the thousand natural shocks
1809 That flesh is heir to-'tis a consummation
1810 Devoutly to be wished. To die, to sleep-
1811 To sleep, perchance to dream. Aye, there's the rub,
1812 For in that sleep of death what dreams may come,
1813 When we have shuffled off this mortal coil,
1814 Must give us pause. There's the respect
1815 That makes calamity of so long life.
1816 For who would bear the whips and scorns of time,
1817 Th' oppressor's wrong, the proud man's contumely,
1818 The pangs of despised love, the law’s delay,
1819 The insolence of office, and the spurns
1820 That patient merit of the unworthy takes,
1821 When he himself might his quietus make
1822 With a bare bodkin? Who would fardels bear,
1823 To grunt and sweat under a weary life,
1824 But that the dread of something after death,
1825 The undiscovered country from whose bourn
1826 No traveler returns, puzzles the will
1827 And makes us rather bear those ills we have
1828 Than fly to others that we know not of?
1829 Thus conscience does make cowards of us all,
1830 And thus the native hue of resolution
1831 Is sicklied o'er with the pale cast of thought,
1832 And enterprises of great pitch and moment,
1833 With this regard their currents turn awry,
1834 And lose the name of action.-Soft you now,
1835 The fair Ophelia.-Nymph, in thy orisons
1836 Be all my sins remembered
1837
1838
1839 SQL Params
1840 SQLType =SQL_LONG
1841 sub type = 0
1842 Field Name = ROWID
1843 Scale = 0
1844 Charset id = 0
1845 Not Null
1846 Size = 4
1847
1848 SQLType =SQL_VARYING
1849 sub type = 0
1850 Field Name = TITLE
1851 Scale = 0
1852 Charset id = 4
1853 Nullable
1854 Size = 128
1855
1856 SQLType =SQL_LONG
1857 sub type = 0
1858 Field Name = FP
1859 Scale = -2
1860 Charset id = 0
1861 Nullable
1862 Size = 4
1863
1864 SQLType =SQL_DOUBLE
1865 sub type = 0
1866 Field Name = DP
1867 Scale = 0
1868 Charset id = 0
1869 Nullable
1870 Size = 8
1871
1872 ROWID = 1
1873 FIXEDPOINT = 20.28
1874 FLOATINGPOINT = 3.14
1875 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1876 BLOBDATA (Charset Id = 4 Codepage = 65001)
1877
1878 To be or not to be-that is the question:
1879 Whether 'tis nobler in the mind to suffer
1880 The slings and arrows of outrageous fortune,
1881 Or to take arms against a sea of troubles,
1882 And, by opposing, end them. To die, to sleep-
1883 No more-and by a sleep to say we end
1884 The heartache and the thousand natural shocks
1885 That flesh is heir to-'tis a consummation
1886 Devoutly to be wished. To die, to sleep-
1887 To sleep, perchance to dream. Aye, there's the rub,
1888 For in that sleep of death what dreams may come,
1889 When we have shuffled off this mortal coil,
1890 Must give us pause. There's the respect
1891 That makes calamity of so long life.
1892 For who would bear the whips and scorns of time,
1893 Th' oppressor's wrong, the proud man's contumely,
1894 The pangs of despised love, the law’s delay,
1895 The insolence of office, and the spurns
1896 That patient merit of the unworthy takes,
1897 When he himself might his quietus make
1898 With a bare bodkin? Who would fardels bear,
1899 To grunt and sweat under a weary life,
1900 But that the dread of something after death,
1901 The undiscovered country from whose bourn
1902 No traveler returns, puzzles the will
1903 And makes us rather bear those ills we have
1904 Than fly to others that we know not of?
1905 Thus conscience does make cowards of us all,
1906 And thus the native hue of resolution
1907 Is sicklied o'er with the pale cast of thought,
1908 And enterprises of great pitch and moment,
1909 With this regard their currents turn awry,
1910 And lose the name of action.-Soft you now,
1911 The fair Ophelia.-Nymph, in thy orisons
1912 Be all my sins remembered
1913
1914 ROWID = 2
1915 FIXEDPOINT = NULL
1916 FLOATINGPOINT = NULL
1917 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1918 BLOBDATA (Charset Id = 4 Codepage = 65001)
1919
1920 To be or not to be-that is the question:
1921 Whether 'tis nobler in the mind to suffer
1922 The slings and arrows of outrageous fortune,
1923 Or to take arms against a sea of troubles,
1924 And, by opposing, end them. To die, to sleep-
1925 No more-and by a sleep to say we end
1926 The heartache and the thousand natural shocks
1927 That flesh is heir to-'tis a consummation
1928 Devoutly to be wished. To die, to sleep-
1929 To sleep, perchance to dream. Aye, there's the rub,
1930 For in that sleep of death what dreams may come,
1931 When we have shuffled off this mortal coil,
1932 Must give us pause. There's the respect
1933 That makes calamity of so long life.
1934 For who would bear the whips and scorns of time,
1935 Th' oppressor's wrong, the proud man's contumely,
1936 The pangs of despised love, the law’s delay,
1937 The insolence of office, and the spurns
1938 That patient merit of the unworthy takes,
1939 When he himself might his quietus make
1940 With a bare bodkin? Who would fardels bear,
1941 To grunt and sweat under a weary life,
1942 But that the dread of something after death,
1943 The undiscovered country from whose bourn
1944 No traveler returns, puzzles the will
1945 And makes us rather bear those ills we have
1946 Than fly to others that we know not of?
1947 Thus conscience does make cowards of us all,
1948 And thus the native hue of resolution
1949 Is sicklied o'er with the pale cast of thought,
1950 And enterprises of great pitch and moment,
1951 With this regard their currents turn awry,
1952 And lose the name of action.-Soft you now,
1953 The fair Ophelia.-Nymph, in thy orisons
1954 Be all my sins remembered
1955
1956
1957 Testing Blob as stored proc parameter
1958 Metadata
1959 SQLType =SQL_BLOB
1960 sub type = 1
1961 Table = TESTPROC
1962 Owner = SYSDBA
1963 Column Name = BLOBDATA
1964 Alias Name = BLOBDATA
1965 Field Name = BLOBDATA
1966 Scale = 0
1967 Charset id = 4
1968 Nullable
1969 Size = 8
1970
1971 Blob Meta Data
1972 SQL SubType =1
1973 Table = TESTPROC
1974 Column = BLOBDATA
1975 CharSetID = 4
1976 Segment Size = 80
1977
1978
1979 BLOBDATA (Charset Id = 4 Codepage = 65001)
1980
1981 To be or not to be-that is the question:
1982 Whether 'tis nobler in the mind to suffer
1983 The slings and arrows of outrageous fortune,
1984 Or to take arms against a sea of troubles,
1985 And, by opposing, end them. To die, to sleep-
1986 No more-and by a sleep to say we end
1987 The heartache and the thousand natural shocks
1988 That flesh is heir to-'tis a consummation
1989 Devoutly to be wished. To die, to sleep-
1990 To sleep, perchance to dream. Aye, there's the rub,
1991 For in that sleep of death what dreams may come,
1992 When we have shuffled off this mortal coil,
1993 Must give us pause. There's the respect
1994 That makes calamity of so long life.
1995 For who would bear the whips and scorns of time,
1996 Th' oppressor's wrong, the proud man's contumely,
1997 The pangs of despised love, the law’s delay,
1998 The insolence of office, and the spurns
1999 That patient merit of the unworthy takes,
2000 When he himself might his quietus make
2001 With a bare bodkin? Who would fardels bear,
2002 To grunt and sweat under a weary life,
2003 But that the dread of something after death,
2004 The undiscovered country from whose bourn
2005 No traveler returns, puzzles the will
2006 And makes us rather bear those ills we have
2007 Than fly to others that we know not of?
2008 Thus conscience does make cowards of us all,
2009 And thus the native hue of resolution
2010 Is sicklied o'er with the pale cast of thought,
2011 And enterprises of great pitch and moment,
2012 With this regard their currents turn awry,
2013 And lose the name of action.-Soft you now,
2014 The fair Ophelia.-Nymph, in thy orisons
2015 Be all my sins remembered
2016
2017
2018
2019 Running Test 7: Create and read back an Array
2020 Metadata
2021 SQLType =SQL_LONG
2022 sub type = 0
2023 Table = TESTDATA
2024 Owner = SYSDBA
2025 Column Name = ROWID
2026 Alias Name = ROWID
2027 Field Name = ROWID
2028 Scale = 0
2029 Charset id = 0
2030 Not Null
2031 Size = 4
2032
2033 SQLType =SQL_VARYING
2034 sub type = 0
2035 Table = TESTDATA
2036 Owner = SYSDBA
2037 Column Name = TITLE
2038 Alias Name = TITLE
2039 Field Name = TITLE
2040 Scale = 0
2041 Charset id = 4
2042 Nullable
2043 Size = 128
2044
2045 SQLType =SQL_TIMESTAMP
2046 sub type = 0
2047 Table = TESTDATA
2048 Owner = SYSDBA
2049 Column Name = DATED
2050 Alias Name = DATED
2051 Field Name = DATED
2052 Scale = 0
2053 Charset id = 0
2054 Nullable
2055 Size = 8
2056
2057 SQLType =SQL_VARYING
2058 sub type = 0
2059 Table = TESTDATA
2060 Owner = SYSDBA
2061 Column Name = NOTES
2062 Alias Name = NOTES
2063 Field Name = NOTES
2064 Scale = 0
2065 Charset id = 4
2066 Nullable
2067 Size = 256
2068
2069 SQLType =SQL_ARRAY
2070 sub type = 0
2071 Table = TESTDATA
2072 Owner = SYSDBA
2073 Column Name = MYARRAY
2074 Alias Name = MYARRAY
2075 Field Name = MYARRAY
2076 Scale = 0
2077 Charset id = 0
2078 Nullable
2079 Size = 8
2080 Array Meta Data:
2081 SQLType =SQL_LONG
2082 Scale = 0
2083 Charset id = 0
2084 Size = 4
2085 Table = TESTDATA
2086 Column = MYARRAY
2087 Dimensions = 1
2088 Bounds: (0:16)
2089
2090 SQL Params
2091 SQLType =SQL_LONG
2092 sub type = 0
2093 Field Name = ROWID
2094 Scale = 0
2095 Charset id = 0
2096 Not Null
2097 Size = 4
2098
2099 SQLType =SQL_VARYING
2100 sub type = 0
2101 Field Name = TITLE
2102 Scale = 0
2103 Charset id = 4
2104 Nullable
2105 Size = 128
2106
2107 SQLType =SQL_TIMESTAMP
2108 sub type = 0
2109 Field Name = DATED
2110 Scale = 0
2111 Charset id = 0
2112 Nullable
2113 Size = 8
2114
2115 SQLType =SQL_VARYING
2116 sub type = 0
2117 Field Name = NOTES
2118 Scale = 0
2119 Charset id = 4
2120 Nullable
2121 Size = 256
2122
2123 Param Name = ROWID
2124 Param Name = TITLE
2125 Param Name = DATED
2126 Param Name = NOTES
2127 ROWID = 1
2128 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2129 DATED = 1/4/2016 09:30:00.100
2130 NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
2131 MYARRAY = NULL
2132
2133 SQL Params
2134 SQLType =SQL_ARRAY
2135 sub type = 0
2136 Field Name = MYARRAY
2137 Scale = 0
2138 Charset id = 0
2139 Nullable
2140 Size = 8
2141
2142 ROWID = 1
2143 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2144 DATED = 1/4/2016 09:30:00.100
2145 NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
2146 Array: (0: 100) (1: 99) (2: 98) (3: 97) (4: 96) (5: 95) (6: 94) (7: 93) (8: 92) (9: 91) (10: 90) (11: 89) (12: 88) (13: 87) (14: 86) (15: 85) (16: 84)
2147
2148 Shrink to 2:10
2149 Array: (2: 98) (3: 97) (4: 96) (5: 95) (6: 94) (7: 93) (8: 92) (9: 91) (10: 90)
2150 Write updated reduced slice
2151 Show update array
2152 ROWID = 1
2153 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2154 DATED = 1/4/2016 09:30:00.100
2155 NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
2156 Array: (0: 100) (1: 99) (2: 1000) (3: 97) (4: 96) (5: 95) (6: 94) (7: 93) (8: 92) (9: 91) (10: 90) (11: 89) (12: 88) (13: 87) (14: 86) (15: 85) (16: 84)
2157
2158
2159
2160 Running Test 8: Create and read back an Array with 2 dimensions
2161 Metadata
2162 SQLType =SQL_LONG
2163 sub type = 0
2164 Table = TESTDATA
2165 Owner = SYSDBA
2166 Column Name = ROWID
2167 Alias Name = ROWID
2168 Field Name = ROWID
2169 Scale = 0
2170 Charset id = 0
2171 Not Null
2172 Size = 4
2173
2174 SQLType =SQL_VARYING
2175 sub type = 0
2176 Table = TESTDATA
2177 Owner = SYSDBA
2178 Column Name = TITLE
2179 Alias Name = TITLE
2180 Field Name = TITLE
2181 Scale = 0
2182 Charset id = 4
2183 Nullable
2184 Size = 128
2185
2186 SQLType =SQL_ARRAY
2187 sub type = 0
2188 Table = TESTDATA
2189 Owner = SYSDBA
2190 Column Name = MYARRAY
2191 Alias Name = MYARRAY
2192 Field Name = MYARRAY
2193 Scale = 0
2194 Charset id = 4
2195 Nullable
2196 Size = 8
2197 Array Meta Data:
2198 SQLType =SQL_VARYING
2199 Scale = 0
2200 Charset id = 4
2201 Size = 16
2202 Table = TESTDATA
2203 Column = MYARRAY
2204 Dimensions = 2
2205 Bounds: (0:16) (-1:7)
2206
2207 SQL Params
2208 SQLType =SQL_LONG
2209 sub type = 0
2210 Field Name = ROWID
2211 Scale = 0
2212 Charset id = 0
2213 Not Null
2214 Size = 4
2215
2216 SQLType =SQL_VARYING
2217 sub type = 0
2218 Field Name = TITLE
2219 Scale = 0
2220 Charset id = 4
2221 Nullable
2222 Size = 128
2223
2224 ROWID = 1
2225 TITLE = 2D Array (Charset Id = 4 Codepage = 65001)
2226 MYARRAY = NULL
2227
2228 ROWID = 1
2229 TITLE = 2D Array (Charset Id = 4 Codepage = 65001)
2230 Array: (0,-1: A50) (0,0: A51) (0,1: A52) (0,2: A53) (0,3: A54) (0,4: A55) (0,5: A56) (0,6: A57) (0,7: A58) (1,-1: A59) (1,0: A60) (1,1: A61) (1,2: A62) (1,3: A63) (1,4: A64) (1,5: A65) (1,6: A66) (1,7: A67) (2,-1: A68) (2,0: A69) (2,1: A70) (2,2: A71) (2,3: A72) (2,4: A73) (2,5: A74) (2,6: A75) (2,7: A76) (3,-1: A77) (3,0: A78) (3,1: A79) (3,2: A80) (3,3: A81) (3,4: A82) (3,5: A83) (3,6: A84) (3,7: A85) (4,-1: A86) (4,0: A87) (4,1: A88) (4,2: A89) (4,3: A90) (4,4: A91) (4,5: A92) (4,6: A93) (4,7: A94) (5,-1: A95) (5,0: A96) (5,1: A97) (5,2: A98) (5,3: A99) (5,4: A100) (5,5: A101) (5,6: A102) (5,7: A103) (6,-1: A104) (6,0: A105) (6,1: A106) (6,2: A107) (6,3: A108) (6,4: A109) (6,5: A110) (6,6: A111) (6,7: A112) (7,-1: A113) (7,0: A114) (7,1: A115) (7,2: A116) (7,3: A117) (7,4: A118) (7,5: A119) (7,6: A120) (7,7: A121) (8,-1: A122) (8,0: A123) (8,1: A124) (8,2: A125) (8,3: A126) (8,4: A127) (8,5: A128) (8,6: A129) (8,7: A130) (9,-1: A131) (9,0: A132) (9,1: A133) (9,2: A134) (9,3: A135) (9,4: A136) (9,5: A137) (9,6: A138) (9,7: A139) (10,-1: A140) (10,0: A141) (10,1: A142) (10,2: A143) (10,3: A144) (10,4: A145) (10,5: A146) (10,6: A147) (10,7: A148) (11,-1: A149) (11,0: A150) (11,1: A151) (11,2: A152) (11,3: A153) (11,4: A154) (11,5: A155) (11,6: A156) (11,7: A157) (12,-1: A158) (12,0: A159) (12,1: A160) (12,2: A161) (12,3: A162) (12,4: A163) (12,5: A164) (12,6: A165) (12,7: A166) (13,-1: A167) (13,0: A168) (13,1: A169) (13,2: A170) (13,3: A171) (13,4: A172) (13,5: A173) (13,6: A174) (13,7: A175) (14,-1: A176) (14,0: A177) (14,1: A178) (14,2: A179) (14,3: A180) (14,4: A181) (14,5: A182) (14,6: A183) (14,7: A184) (15,-1: A185) (15,0: A186) (15,1: A187) (15,2: A188) (15,3: A189) (15,4: A190) (15,5: A191) (15,6: A192) (15,7: A193) (16,-1: A194) (16,0: A195) (16,1: A196) (16,2: A197) (16,3: A198) (16,4: A199) (16,5: A200) (16,6: A201) (16,7: A202)
2231
2232
2233
2234 Running Test 9: Database Information tests
2235 Database ID = 4 FB = /opt/firebird/examples/empbuild/employee.fdb SN = mint18-FB3
2236 Pages =307
2237 Base Level = 13,4,0,3,
2238 Implementation = 11,7,0,3,66,1,66,
2239 Reserved = 0
2240 ODS minor = 0
2241 ODS major = 12
2242 Page Size = 8192
2243 Version = 1: LI-V6.3.1.32609 Firebird 3.0
2244 Database is Read/Write
2245 Server Memory = 19122232
2246 Forced Writes = 1
2247 Max Memory = 19230544
2248 Num Buffers = 2048
2249 Sweep Interval = 20000
2250 Logged in Users: SYSDBA,
2251 Fetches = 541
2252 Writes = 6
2253 Reads = 53
2254 Page Writes = 3
2255 Record Version Removals Operation Counts
2256
2257 Deletes Operation Counts
2258
2259 Expunge Count Operation Counts
2260
2261 Insert Count Operation Counts
2262
2263 Purge Count Countites Operation Counts
2264
2265 Indexed Reads Count Operation Counts
2266 Table ID = 4
2267 Count = 28
2268 Table ID = 6
2269 Count = 15
2270 Table ID = 9
2271 Count = 2
2272 Table ID = 11
2273 Count = 1
2274 Table ID = 12
2275 Count = 15
2276 Table ID = 28
2277 Count = 1
2278 Table ID = 29
2279 Count = 1
2280
2281 Sequential Table Scans Operation Counts
2282 Table ID = 0
2283 Count = 94
2284 Table ID = 1
2285 Count = 2
2286
2287 Update Count Operation Counts
2288
2289
2290
2291 Running Test 10: Event Handling
2292 Call Async Wait
2293 Async Wait Called
2294 Event Signalled
2295 First Event - usually ignored
2296 Signal Event
2297 Event Signalled
2298 Event Counts: TESTEVENT, Count = 1
2299 Two more events
2300 Call Async Wait
2301 Async Wait Called
2302 Event Signalled
2303 Deferred Events Caught
2304 Event Counts: TESTEVENT, Count = 2
2305 Signal Event
2306 Event Signalled
2307 Event Counts: TESTEVENT, Count = 1
2308 Async Wait: Test Cancel
2309 Async Wait Called
2310 Event Cancelled
2311 Time Out - Cancel Worked!
2312 Sync wait
2313 Event Signalled
2314 Event Counts: TESTEVENT, Count = 1
2315
2316
2317 Running Test 11: Services API
2318 Service Manager Version = 2
2319 Server Version = LI-V3.0.1.32609 Firebird 3.0
2320 Implementation = Firebird/Linux/AMD/Intel/x64
2321
2322 Lock Directory = /tmp/firebird/
2323 Message File = /opt/firebird/
2324 Security File = /opt/firebird/security3.fdb
2325
2326 DB Attachments
2327 No. of Attachments = 0
2328 Databases In Use = 0
2329
2330 Sec. Database User
2331 User Name = SYSDBA
2332 First Name =
2333 Middle Name =
2334 Last Name =
2335 User ID = 0
2336 Group ID = 0
2337
2338
2339 Licence Info: feature is not supported
2340 feature is not supported
2341
2342 Licence Mask Info: feature is not supported
2343
2344 Capabilities = 6
2345
2346
2347 Get Limbo transactions
2348
2349 Limbo Transactions
2350
2351
2352 Local Backup
2353
2354
2355
2356 Local Backup Complete
2357
2358 Local Restore
2359
2360
2361
2362
2363
2364
2365 Local Restore Complete
2366
2367 Open Database Check
2368 Database OK
2369 Database Dropped
2370
2371
2372 Running Test 12: Character Sets
2373 SQL Params
2374 SQLType =SQL_LONG
2375 sub type = 0
2376 Field Name = ROWID
2377 Scale = 0
2378 Charset id = 0
2379 Not Null
2380 Size = 4
2381
2382 SQLType =SQL_VARYING
2383 sub type = 0
2384 Field Name = TITLE
2385 Scale = 0
2386 Charset id = 4
2387 Nullable
2388 Size = 128
2389
2390 SQLType =SQL_VARYING
2391 sub type = 0
2392 Field Name = NOTES
2393 Scale = 0
2394 Charset id = 4
2395 Nullable
2396 Size = 256
2397
2398 SQLType =SQL_BLOB
2399 sub type = 1
2400 Field Name = BLOBDATA
2401 Scale = 0
2402 Charset id = 4
2403 Nullable
2404 Size = 8
2405
2406 SQLType =SQL_BLOB
2407 sub type = 1
2408 Field Name = BLOBDATA2
2409 Scale = 0
2410 Charset id = 4
2411 Nullable
2412 Size = 8
2413
2414 SQLType =SQL_VARYING
2415 sub type = 0
2416 Field Name = INCLEAR
2417 Scale = 0
2418 Charset id = 1
2419 Nullable
2420 Size = 16
2421
2422 Connection Character Set UTF8
2423 ROWID = 1
2424 TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001)
2425 NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001)
2426 BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001)
2427 BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001)
2428 INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535)
2429
2430 Connection Character Set NONE
2431 ROWID = 1
2432 TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001)
2433 NOTES = C9 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 21 Codepage = 28591)
2434 BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 D6 C4 DC F6 E4 FC DF (Charset Id = 53 Codepage = 1252)
2435 BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001)
2436 INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535)
2437
2438 Connection Character Set WIN1252
2439 ROWID = 1
2440 TITLE = 42 6C 6F 62 20 54 65 73 74 20 A9 80 (Charset Id = 53 Codepage = 1252)
2441 NOTES = C9 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 53 Codepage = 1252)
2442 BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 D6 C4 DC F6 E4 FC DF (Charset Id = 53 Codepage = 1252)
2443 BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 D6 C4 DC F6 E4 FC DF (Charset Id = 53 Codepage = 1252)
2444 INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535)
2445
2446
2447
2448 Running Test 13: Transaction over two databases
2449 Init Database 1
2450 ROWID = 1
2451 TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001)
2452 NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001)
2453 BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001)
2454 BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001)
2455 INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535)
2456
2457 Init Database 2
2458 ROWID = 1
2459 TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001)
2460 NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001)
2461 BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001)
2462 BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001)
2463 INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535)
2464
2465 ROWID = 1
2466 TITLE = 44 61 74 61 62 61 73 65 31 (Charset Id = 4 Codepage = 65001)
2467 NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001)
2468 BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001)
2469 BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001)
2470 INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535)
2471
2472 ROWID = 1
2473 TITLE = 44 61 74 61 62 61 73 65 32 (Charset Id = 4 Codepage = 65001)
2474 NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001)
2475 BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001)
2476 BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001)
2477 INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535)
2478
2479
2480
2481 Running Test 14: Non select procedures
2482 Default Character set Name = UTF8
2483 Metadata
2484 SQLType =SQL_LONG
2485 sub type = 0
2486 Table = SHOWDATA
2487 Owner = SYSDBA
2488 Column Name = ROWID
2489 Alias Name = ROWID
2490 Field Name = ROWID
2491 Scale = 0
2492 Charset id = 0
2493 Nullable
2494 Size = 4
2495
2496 SQLType =SQL_VARYING
2497 sub type = 0
2498 Table = SHOWDATA
2499 Owner = SYSDBA
2500 Column Name = TITLE
2501 Alias Name = TITLE
2502 Field Name = TITLE
2503 Scale = 0
2504 Charset id = 4
2505 Nullable
2506 Size = 128
2507
2508 ROWID = 1
2509 TITLE = Testing (Charset Id = 4 Codepage = 65001)
2510
2511 Repeat with a different execute transaction
2512
2513 ROWID = 1
2514 TITLE = Testing (Charset Id = 4 Codepage = 65001)
2515
2516 Repeat with a original transaction
2517
2518 ROWID = 1
2519 TITLE = Testing (Charset Id = 4 Codepage = 65001)
2520
2521
2522 Running Test 15: Blob Handling and BPBs
2523
2524 Testdata
2525
2526 ROWID = 1
2527 TITLE = Blob Test (Charset Id = 4 Codepage = 65001)
2528 BLOBDATA = (blob), Length = 92514
2529
2530
2531 Testdata 2
2532
2533 ROWID = 1
2534 TITLE = Blob Test (Charset Id = 4 Codepage = 65001)
2535 BLOBDATA (Charset Id = 4 Codepage = 65001)
2536
2537 Écoute moi
2538
2539
2540
2541 Running Test 16: Error handling
2542 Invalid Database Name Test
2543 Error Handled: I/O error during "open" operation for file "Malformed Name"
2544 Error while trying to open file
2545 No such file or directory
2546 Invalid User Name Test
2547 Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
2548 Invalid password Test
2549 Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
2550 Invalid Prepare SQL Test
2551 Error Handled: Dynamic SQL Error
2552 SQL error code = -206
2553 Column unknown
2554 UNKNOWN_DATE
2555 At line 1, column 21 When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ?
2556 Invalid Open Cursor SQL Test
2557 Error Handled: Dynamic SQL Error
2558 SQL error code = -206
2559 Column unknown
2560 X
2561 At line 1, column 8 When Executing: Select X,count(*) As Counter from EMPLOYEE
2562 Transaction not started Test
2563 Error Handled: Transaction is not active
2564 Invalid Param SQL Type Test
2565 Error Handled: Field "EMP_NO" not found
2566 Invalid Server Name Test
2567 Error Handled: Unable to complete network request to host "unknown".
2568 Failed to locate host machine.
2569 The specified name was not found in the hosts file or Domain Name Services
2570 Invalid User Name Test
2571 Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
2572 Invalid password Test
2573 Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
2574
2575
2576 Test Suite Ends