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

File Contents

# User Rev Content
1 tony 333 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