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