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