ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/public/ibx/branches/journaling/fbintf/testsuite/FB3reference.log
Revision: 333
Committed: Fri Feb 26 16:34:26 2021 UTC (3 years, 1 month ago) by tony
Original Path: ibx/trunk/fbintf/testsuite/FB3reference.log
File size: 73429 byte(s)
Log Message:
Add missing files

File Contents

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