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