ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/public/ibx/trunk/fbintf/testsuite/reference.log
Revision: 304
Committed: Fri Jul 17 22:42:02 2020 UTC (3 years, 8 months ago) by tony
File size: 69707 byte(s)
Log Message:
Fixes reversed out

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