ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/public/ibx/trunk/fbintf/testsuite/FB3reference.log
(Generate patch)

Comparing ibx/trunk/fbintf/testsuite/FB3reference.log (file contents):
Revision 333 by tony, Fri Feb 26 16:34:26 2021 UTC vs.
Revision 356 by tony, Sun Oct 24 14:00:52 2021 UTC

# Line 1 | Line 1
1   Firebird API Test Suite
2 < Copyright MWA Software 2016
2 > Copyright MWA Software 2016-2021
3  
4   Starting Tests
5   Client API Version = 3.0
6 + Firebird Environment Variable = /opt/firebird3.0.5
7 + Firebird Bin Directory = /opt/firebird3.0.5/bin
8 + Firebird Conf Directory = /opt/firebird3.0.5/
9 + Firebird Client Library Path = /opt/firebird3.0.5/lib/libfbclient.so
10   Running Test 1: Create and Drop a Database
11   Creating a Database with empty parameters
12 < Create Database fails (as expected):
9 < I/O error during "open O_CREAT" operation for file ""
12 > Create Database fails (as expected): I/O error during "open O_CREAT" operation for file ""
13   -Error while trying to create file
14   -No such file or directory
15   Creating a Database using an SQL Statement
16 < Database ID = 2 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus
16 > Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus
17   SQL Dialect = 3
18 < DB Connect String = /tmp/fbintf-testsuite/testsuite1.fdb
18 > DB Connect String = inet://localhost//tmp/fbintf-testsuite/testsuite1.fdb
19   DB Charset ID = 0
20   DB SQL Dialect = 3
21 < DB Remote Protocol =
21 > DB Remote Protocol = TCPv4
22   DB ODS Major Version = 12
23   DB ODS Minor Version = 0
24 < User Authentication Method = User name in DPB
24 > User Authentication Method = Srp
25   Firebird Library Path = /opt/firebird3.0.5/lib/libfbclient.so
26   DB Client Implementation Version = 3.0
27 < DPB
28 < Count = 3
29 < 28 = SYSDBA
30 < 29 = masterkey
31 < 65 = 3
27 > DPB: Item Count = 3
28 >  isc_dpb_user_name = SYSDBA
29 >  isc_dpb_password = masterkey
30 >  isc_dpb_set_db_sql_dialect = 3
31 >
32 > Firebird Server Version Info
33 > Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.5.33220 Firebird 3.0"
34 > Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.5.33220 Firebird 3.0/tcp (zeus)/P15:C"
35 > Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.5.33220 Firebird 3.0/tcp (zeus)/P15:C"
36 > on disk structure version 12.0
37  
38   Dropping Database
39   Creating a Database with a DPD
40 < DB Connect String = /tmp/fbintf-testsuite/testsuite1.fdb
40 > DB Connect String = inet://localhost//tmp/fbintf-testsuite/testsuite1.fdb
41   DB Charset ID = 4
42   DB SQL Dialect = 3
43 < DB Remote Protocol =
43 > DB Remote Protocol = TCPv4
44   DB ODS Major Version = 12
45   DB ODS Minor Version = 0
46 < User Authentication Method = User name in DPB
46 > User Authentication Method = Srp
47   Firebird Library Path = /opt/firebird3.0.5/lib/libfbclient.so
48   DB Client Implementation Version = 3.0
49   Dropping Database
50 < DPB
51 < Count = 4
52 < 28 = SYSDBA
53 < 29 = masterkey
54 < 48 = UTF8
47 < 65 = 3
50 > DPB: Item Count = 4
51 >  isc_dpb_user_name = SYSDBA
52 >  isc_dpb_password = masterkey
53 >  isc_dpb_lc_ctype = UTF8
54 >  isc_dpb_set_db_sql_dialect = 3
55  
56   Creating a Database with a DPD
57 < Database ID = 2 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus
57 > Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus
58   ODS major = 12
59   ODS minor = 0
60 < DB Connect String = /tmp/fbintf-testsuite/testsuite1.fdb
60 > DB Connect String = inet://localhost//tmp/fbintf-testsuite/testsuite1.fdb
61   DB Charset ID = 4
62   DB SQL Dialect = 3
63 < DB Remote Protocol =
63 > DB Remote Protocol = TCPv4
64   DB ODS Major Version = 12
65   DB ODS Minor Version = 0
66 < User Authentication Method = User name in DPB
66 > User Authentication Method = Srp
67   Firebird Library Path = /opt/firebird3.0.5/lib/libfbclient.so
68   DB Client Implementation Version = 3.0
69   RDB$DESCRIPTION =
# Line 67 | Line 74 | RDB$LINGER =
74   Dropping Database
75  
76  
77 + ------------------------------------------------------
78   Running Test 2: Open the employee database and run a query
79 + Open Database fails Your user name and password are not defined. Ask your database administrator to set up a Firebird login
80   Opening inet://localhost/employee
81   Database Open, SQL Dialect = 3
82 + TPB: Item Count = 3
83 +  isc_tpb_read
84 +  isc_tpb_nowait
85 +  isc_tpb_concurrency
86 +
87 + Metadata
88 + SQLType =SQL_SHORT
89 + sub type = 0
90 + Table = EMPLOYEE
91 + Owner = SYSDBA
92 + Column Name = EMP_NO
93 + Alias Name = EMP_NO
94 + Field Name = EMP_NO
95 + Scale = 0
96 + Charset id = 0
97 + Not Null
98 + Size = 2
99 +
100 + SQLType =SQL_VARYING
101 + sub type = 0
102 + Table = EMPLOYEE
103 + Owner = SYSDBA
104 + Column Name = FIRST_NAME
105 + Alias Name = FIRST_NAME
106 + Field Name = FIRST_NAME
107 + Scale = 0
108 + Charset id = 0
109 + Not Null
110 + Size = 15
111 +
112 + SQLType =SQL_VARYING
113 + sub type = 0
114 + Table = EMPLOYEE
115 + Owner = SYSDBA
116 + Column Name = LAST_NAME
117 + Alias Name = LAST_NAME
118 + Field Name = LAST_NAME
119 + Scale = 0
120 + Charset id = 0
121 + Not Null
122 + Size = 20
123 +
124 + SQLType =SQL_VARYING
125 + sub type = 0
126 + Table = EMPLOYEE
127 + Owner = SYSDBA
128 + Column Name = PHONE_EXT
129 + Alias Name = PHONE_EXT
130 + Field Name = PHONE_EXT
131 + Scale = 0
132 + Charset id = 0
133 + Nullable
134 + Size = 4
135 +
136 + SQLType =SQL_TIMESTAMP
137 + sub type = 0
138 + Table = EMPLOYEE
139 + Owner = SYSDBA
140 + Column Name = HIRE_DATE
141 + Alias Name = HIRE_DATE
142 + Field Name = HIRE_DATE
143 + Scale = 0
144 + Charset id = 0
145 + Not Null
146 + Size = 8
147 +
148 + SQLType =SQL_TEXT
149 + sub type = 0
150 + Table = EMPLOYEE
151 + Owner = SYSDBA
152 + Column Name = DEPT_NO
153 + Alias Name = DEPT_NO
154 + Field Name = DEPT_NO
155 + Scale = 0
156 + Charset id = 0
157 + Not Null
158 + Size = 3
159 +
160 + SQLType =SQL_VARYING
161 + sub type = 0
162 + Table = EMPLOYEE
163 + Owner = SYSDBA
164 + Column Name = JOB_CODE
165 + Alias Name = JOB_CODE
166 + Field Name = JOB_CODE
167 + Scale = 0
168 + Charset id = 0
169 + Not Null
170 + Size = 5
171 +
172 + SQLType =SQL_SHORT
173 + sub type = 0
174 + Table = EMPLOYEE
175 + Owner = SYSDBA
176 + Column Name = JOB_GRADE
177 + Alias Name = JOB_GRADE
178 + Field Name = JOB_GRADE
179 + Scale = 0
180 + Charset id = 0
181 + Not Null
182 + Size = 2
183 +
184 + SQLType =SQL_VARYING
185 + sub type = 0
186 + Table = EMPLOYEE
187 + Owner = SYSDBA
188 + Column Name = JOB_COUNTRY
189 + Alias Name = JOB_COUNTRY
190 + Field Name = JOB_COUNTRY
191 + Scale = 0
192 + Charset id = 0
193 + Not Null
194 + Size = 15
195 +
196 + SQLType =SQL_INT64
197 + sub type = 0
198 + Table = EMPLOYEE
199 + Owner = SYSDBA
200 + Column Name = SALARY
201 + Alias Name = SALARY
202 + Field Name = SALARY
203 + Scale = -2
204 + Charset id = 0
205 + Not Null
206 + Size = 8
207 +
208 + SQLType =SQL_VARYING
209 + sub type = 0
210 + Table = EMPLOYEE
211 + Owner = SYSDBA
212 + Column Name = FULL_NAME
213 + Alias Name = FULL_NAME
214 + Field Name = FULL_NAME
215 + Scale = 0
216 + Charset id = 0
217 + Nullable
218 + Size = 37
219 +
220 + Plan =
221 + Select Expression
222 +    -> First N Records
223 +        -> Table "EMPLOYEE" Full Scan
224 + -- SQL style inline comment
225 + /* this is a comment */ Select First 3 * from EMPLOYEE
226 +
227 + EMP_NO = 2
228 + FIRST_NAME = Robert
229 + LAST_NAME = Nelson
230 + PHONE_EXT = 250
231 + HIRE_DATE = 1988/12/28 00:00:00.0000
232 + DEPT_NO = 600
233 + JOB_CODE = VP
234 + JOB_GRADE = 2
235 + JOB_COUNTRY = USA
236 + SALARY = 105,900.00
237 + FULL_NAME = Nelson, Robert
238 + EMP_NO = 4
239 + FIRST_NAME = Bruce
240 + LAST_NAME = Young
241 + PHONE_EXT = 233
242 + HIRE_DATE = 1988/12/28 00:00:00.0000
243 + DEPT_NO = 621
244 + JOB_CODE = Eng
245 + JOB_GRADE = 2
246 + JOB_COUNTRY = USA
247 + SALARY = 97,500.00
248 + FULL_NAME = Young, Bruce
249 + EMP_NO = 5
250 + FIRST_NAME = Kim
251 + LAST_NAME = Lambert
252 + PHONE_EXT = 22
253 + HIRE_DATE = 1989/02/06 00:00:00.0000
254 + DEPT_NO = 130
255 + JOB_CODE = Eng
256 + JOB_GRADE = 2
257 + JOB_COUNTRY = USA
258 + SALARY = 102,750.00
259 + FULL_NAME = Lambert, Kim
260 +
261 + Select * from EMPLOYEE Where EMP_NO = ?
262 + SQL Params
263 + SQLType =SQL_SHORT
264 + sub type = 0
265 + Field Name =
266 + Scale = 0
267 + Charset id = 0
268 + Not Null
269 + Size = 2
270 + Value = 0
271 +
272 + EMP_NO = 8
273 + FIRST_NAME = Leslie
274 + LAST_NAME = Johnson
275 + PHONE_EXT = 410
276 + HIRE_DATE = 1989/04/05 00:00:00.0000
277 + DEPT_NO = 180
278 + JOB_CODE = Mktg
279 + JOB_GRADE = 3
280 + JOB_COUNTRY = USA
281 + SALARY = 64,635.00
282 + FULL_NAME = Johnson, Leslie
283 +
284 + With param names
285 + Select * from EMPLOYEE Where EMP_NO = :EMP_NO
286 + SQL Params
287 + SQLType =SQL_SHORT
288 + sub type = 0
289 + Field Name = EMP_NO
290 + Scale = 0
291 + Charset id = 0
292 + Not Null
293 + Size = 2
294 + Value = 0
295 +
296 + Results for Cursor: Test Cursor
297 + EMP_NO = 8
298 + FIRST_NAME = Leslie
299 + LAST_NAME = Johnson
300 + PHONE_EXT = 410
301 + HIRE_DATE = 1989/04/05 00:00:00.0000
302 + DEPT_NO = 180
303 + JOB_CODE = Mktg
304 + JOB_GRADE = 3
305 + JOB_COUNTRY = USA
306 + SALARY = 64,635.00
307 + FULL_NAME = Johnson, Leslie
308 +
309 + Now open the employee database as a local database
310 + TPB: Item Count = 3
311 +  isc_tpb_read
312 +  isc_tpb_nowait
313 +  isc_tpb_concurrency
314 +
315   Metadata
316   SQLType =SQL_SHORT
317   sub type = 0
# Line 214 | Line 456 | EMP_NO = 2
456   FIRST_NAME = Robert
457   LAST_NAME = Nelson
458   PHONE_EXT = 250
459 < HIRE_DATE = 28/12/1988 00:00:00.000
459 > HIRE_DATE = 1988/12/28 00:00:00.0000
460   DEPT_NO = 600
461   JOB_CODE = VP
462   JOB_GRADE = 2
# Line 225 | Line 467 | EMP_NO = 4
467   FIRST_NAME = Bruce
468   LAST_NAME = Young
469   PHONE_EXT = 233
470 < HIRE_DATE = 28/12/1988 00:00:00.000
470 > HIRE_DATE = 1988/12/28 00:00:00.0000
471   DEPT_NO = 621
472   JOB_CODE = Eng
473   JOB_GRADE = 2
# Line 236 | Line 478 | EMP_NO = 5
478   FIRST_NAME = Kim
479   LAST_NAME = Lambert
480   PHONE_EXT = 22
481 < HIRE_DATE = 6/2/1989 00:00:00.000
481 > HIRE_DATE = 1989/02/06 00:00:00.0000
482   DEPT_NO = 130
483   JOB_CODE = Eng
484   JOB_GRADE = 2
# Line 253 | Line 495 | Scale = 0
495   Charset id = 0
496   Not Null
497   Size = 2
498 + Value = 0
499  
500   EMP_NO = 8
501   FIRST_NAME = Leslie
502   LAST_NAME = Johnson
503   PHONE_EXT = 410
504 < HIRE_DATE = 5/4/1989 00:00:00.000
504 > HIRE_DATE = 1989/04/05 00:00:00.0000
505   DEPT_NO = 180
506   JOB_CODE = Mktg
507   JOB_GRADE = 3
# Line 276 | Line 519 | Scale = 0
519   Charset id = 0
520   Not Null
521   Size = 2
522 + Value = 0
523  
524 + Results for Cursor: Test Cursor
525   EMP_NO = 8
526   FIRST_NAME = Leslie
527   LAST_NAME = Johnson
528   PHONE_EXT = 410
529 < HIRE_DATE = 5/4/1989 00:00:00.000
529 > HIRE_DATE = 1989/04/05 00:00:00.0000
530   DEPT_NO = 180
531   JOB_CODE = Mktg
532   JOB_GRADE = 3
# Line 289 | Line 534 | JOB_COUNTRY = USA
534   SALARY = 64,635.00
535   FULL_NAME = Johnson, Leslie
536  
537 + Scollable Cursors
538 + DB Connect String = employee
539 + DB Charset ID = 4
540 + DB SQL Dialect = 3
541 + DB Remote Protocol =
542 + DB ODS Major Version = 12
543 + DB ODS Minor Version = 0
544 + User Authentication Method = User name in DPB
545 + Firebird Library Path = /opt/firebird3.0.5/lib/libfbclient.so
546 + DB Client Implementation Version = 3.0
547 + Do Fetch Next:
548 + EMP_NO = 2
549 + FIRST_NAME = Robert
550 + LAST_NAME = Nelson
551 + PHONE_EXT = 250
552 + HIRE_DATE = 1988/12/28 00:00:00.0000
553 + DEPT_NO = 600
554 + JOB_CODE = VP
555 + JOB_GRADE = 2
556 + JOB_COUNTRY = USA
557 + SALARY = 105,900.00
558 + FULL_NAME = Nelson, Robert
559 + Do Fetch Last:
560 + EMP_NO = 145
561 + FIRST_NAME = Mark
562 + LAST_NAME = Guckenheimer
563 + PHONE_EXT = 221
564 + HIRE_DATE = 1994/05/02 00:00:00.0000
565 + DEPT_NO = 622
566 + JOB_CODE = Eng
567 + JOB_GRADE = 5
568 + JOB_COUNTRY = USA
569 + SALARY = 32,000.00
570 + FULL_NAME = Guckenheimer, Mark
571 + Do Fetch Prior:
572 + EMP_NO = 144
573 + FIRST_NAME = John
574 + LAST_NAME = Montgomery
575 + PHONE_EXT = 820
576 + HIRE_DATE = 1994/03/30 00:00:00.0000
577 + DEPT_NO = 672
578 + JOB_CODE = Eng
579 + JOB_GRADE = 5
580 + JOB_COUNTRY = USA
581 + SALARY = 35,000.00
582 + FULL_NAME = Montgomery, John
583 + Do Fetch First:
584 + EMP_NO = 2
585 + FIRST_NAME = Robert
586 + LAST_NAME = Nelson
587 + PHONE_EXT = 250
588 + HIRE_DATE = 1988/12/28 00:00:00.0000
589 + DEPT_NO = 600
590 + JOB_CODE = VP
591 + JOB_GRADE = 2
592 + JOB_COUNTRY = USA
593 + SALARY = 105,900.00
594 + FULL_NAME = Nelson, Robert
595 + Do Fetch Abs 8 :
596 + EMP_NO = 14
597 + FIRST_NAME = Stewart
598 + LAST_NAME = Hall
599 + PHONE_EXT = 227
600 + HIRE_DATE = 1990/06/04 00:00:00.0000
601 + DEPT_NO = 900
602 + JOB_CODE = Finan
603 + JOB_GRADE = 3
604 + JOB_COUNTRY = USA
605 + SALARY = 69,482.63
606 + FULL_NAME = Hall, Stewart
607 + Do Fetch Relative -2 :
608 + EMP_NO = 11
609 + FIRST_NAME = K. J.
610 + LAST_NAME = Weston
611 + PHONE_EXT = 34
612 + HIRE_DATE = 1990/01/17 00:00:00.0000
613 + DEPT_NO = 130
614 + JOB_CODE = SRep
615 + JOB_GRADE = 4
616 + JOB_COUNTRY = USA
617 + SALARY = 86,292.94
618 + FULL_NAME = Weston, K. J.
619 + Do Fetch beyond EOF :
620 + Fetch returned false
621  
622  
623 + ------------------------------------------------------
624   Running Test 3: ad hoc queries
625   Opening inet://localhost/employee
626   Database Open
# Line 304 | Line 634 | Constrained Employee Count = 3
634   "Yanowski" Employee Count = 1
635  
636  
637 + ------------------------------------------------------
638   Running Test 4: Update, Insert and Delete Queries
639   Opening inet://localhost/employee
640   Database Open
# Line 316 | Line 647 | EMP_NO = 8
647   FIRST_NAME = Leslie
648   LAST_NAME = Johnson
649   PHONE_EXT = 410
650 < HIRE_DATE = 5/4/1989 00:00:00.000
650 > HIRE_DATE = 1989/04/05 00:00:00.0000
651   DEPT_NO = 180
652   JOB_CODE = Mktg
653   JOB_GRADE = 3
# Line 324 | Line 655 | JOB_COUNTRY = USA
655   SALARY = 64,635.00
656   FULL_NAME = Johnson, Leslie
657  
658 < Current memory = 19693296
659 < Delta memory = 4480
660 < Max memory = 19755408
661 < Elapsed time= 0.001 sec
658 > Current memory = 19,694,032
659 > Delta memory = 4,480
660 > Max memory = 19,755,888
661 > Elapsed time= 0.002 sec
662   Cpu = 0.000 sec
663   Buffers = 2048
664   Reads = 0
# Line 472 | Line 803 | EMP_NO = 150
803   FIRST_NAME = John
804   LAST_NAME = Doe
805   PHONE_EXT =
806 < HIRE_DATE = 1/4/2015 00:00:00.000
806 > HIRE_DATE = 2015/04/01 00:00:00.0000
807   DEPT_NO = 600
808   JOB_CODE = Eng
809   JOB_GRADE = 4
# Line 485 | Line 816 | EMP_NO = 151
816   FIRST_NAME = Major
817   LAST_NAME = Major
818   PHONE_EXT =
819 < HIRE_DATE = 1/4/2015 00:00:00.000
819 > HIRE_DATE = 2015/04/01 00:00:00.0000
820   DEPT_NO = 600
821   JOB_CODE = Eng
822   JOB_GRADE = 4
# Line 502 | Line 833 | EMP_NO = 150
833   FIRST_NAME = Jane
834   LAST_NAME = Doe
835   PHONE_EXT = NULL
836 < HIRE_DATE = 1/4/2015 00:00:00.000
836 > HIRE_DATE = 2015/04/01 00:00:00.0000
837   DEPT_NO = 600
838   JOB_CODE = Eng
839   JOB_GRADE = 4
# Line 519 | Line 850 | EMP_NO = 150
850   FIRST_NAME = Jayne's
851   LAST_NAME = Doe
852   PHONE_EXT = NULL
853 < HIRE_DATE = 1/4/2015 00:00:00.000
853 > HIRE_DATE = 2015/04/01 00:00:00.0000
854   DEPT_NO = 600
855   JOB_CODE = Eng
856   JOB_GRADE = 4
# Line 533 | Line 864 | EMP_NO = 8
864   FIRST_NAME = Leslie
865   LAST_NAME = Johnson
866   PHONE_EXT = 410
867 < HIRE_DATE = 5/4/1989 00:00:00.000
867 > HIRE_DATE = 1989/04/05 00:00:00.0000
868   DEPT_NO = 180
869   JOB_CODE = Mktg
870   JOB_GRADE = 3
# Line 547 | Line 878 | EMP_NO = 8
878   FIRST_NAME = Leslie
879   LAST_NAME = Johnson
880   PHONE_EXT = 410
881 < HIRE_DATE = 5/4/1989 00:00:00.000
881 > HIRE_DATE = 1989/04/05 00:00:00.0000
882   DEPT_NO = 180
883   JOB_CODE = Mktg
884   JOB_GRADE = 3
# Line 559 | Line 890 | EMP_NO = 9
890   FIRST_NAME = Phil
891   LAST_NAME = Forest
892   PHONE_EXT = 229
893 < HIRE_DATE = 17/4/1989 00:00:00.000
893 > HIRE_DATE = 1989/04/17 00:00:00.0000
894   DEPT_NO = 622
895   JOB_CODE = Mngr
896   JOB_GRADE = 3
# Line 573 | Line 904 | EMP_NO = 8
904   FIRST_NAME = Leslie
905   LAST_NAME = Johnson
906   PHONE_EXT = 410
907 < HIRE_DATE = 31/1/2015 00:00:00.000
907 > HIRE_DATE = 2015/01/31 00:00:00.0000
908   DEPT_NO = 180
909   JOB_CODE = Mktg
910   JOB_GRADE = 3
# Line 583 | Line 914 | FULL_NAME = Johnson, Leslie
914  
915  
916  
917 + ------------------------------------------------------
918   Running Test 5: Update Returning and Activity Check
919   Opening inet://localhost/employee
920   Database Open
# Line 594 | Line 926 | EMP_NO = 8
926   FIRST_NAME = Leslie
927   LAST_NAME = Johnson
928   PHONE_EXT = 410
929 < HIRE_DATE = 31/1/2016 00:00:00.000
929 > HIRE_DATE = 2016/01/31 00:00:00.0000
930   DEPT_NO = 180
931   JOB_CODE = Mktg
932   JOB_GRADE = 3
# Line 616 | Line 948 | Transaction Active
948   Transaction inactive
949  
950  
951 + ------------------------------------------------------
952   Running Test 6: Blob Handling
953   Metadata
954   SQLType =SQL_TEXT
# Line 642 | Line 975 | Charset id = 0
975   Nullable
976   Size = 2
977  
978 < RDB$CHARACTER_SET_NAME = NONE (Charset Id = 4 Codepage = 65001 Byte Length = 31)
978 > RDB$CHARACTER_SET_NAME = NONE (Charset Id = 4 Codepage = 65001)
979   RDB$CHARACTER_SET_ID = 0
980 < RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 4 Codepage = 65001 Byte Length = 31)
980 > RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 4 Codepage = 65001)
981   RDB$CHARACTER_SET_ID = 1
982 < RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 4 Codepage = 65001 Byte Length = 31)
982 > RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 4 Codepage = 65001)
983   RDB$CHARACTER_SET_ID = 2
984 < RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 4 Codepage = 65001 Byte Length = 31)
984 > RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 4 Codepage = 65001)
985   RDB$CHARACTER_SET_ID = 3
986 < RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
986 > RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 4 Codepage = 65001)
987   RDB$CHARACTER_SET_ID = 4
988 < RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
988 > RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 4 Codepage = 65001)
989   RDB$CHARACTER_SET_ID = 5
990 < RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
990 > RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 4 Codepage = 65001)
991   RDB$CHARACTER_SET_ID = 6
992 < RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
992 > RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 4 Codepage = 65001)
993   RDB$CHARACTER_SET_ID = 9
994 < RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
994 > RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 4 Codepage = 65001)
995   RDB$CHARACTER_SET_ID = 10
996 < RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
996 > RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 4 Codepage = 65001)
997   RDB$CHARACTER_SET_ID = 11
998 < RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
998 > RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 4 Codepage = 65001)
999   RDB$CHARACTER_SET_ID = 12
1000 < RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1000 > RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 4 Codepage = 65001)
1001   RDB$CHARACTER_SET_ID = 13
1002 < RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1002 > RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 4 Codepage = 65001)
1003   RDB$CHARACTER_SET_ID = 14
1004 < RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1004 > RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 4 Codepage = 65001)
1005   RDB$CHARACTER_SET_ID = 15
1006 < RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1006 > RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 4 Codepage = 65001)
1007   RDB$CHARACTER_SET_ID = 16
1008 < RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1008 > RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 4 Codepage = 65001)
1009   RDB$CHARACTER_SET_ID = 17
1010 < RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1010 > RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 4 Codepage = 65001)
1011   RDB$CHARACTER_SET_ID = 18
1012 < RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1012 > RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 4 Codepage = 65001)
1013   RDB$CHARACTER_SET_ID = 19
1014 < RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1014 > RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 4 Codepage = 65001)
1015   RDB$CHARACTER_SET_ID = 21
1016 < RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1016 > RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 4 Codepage = 65001)
1017   RDB$CHARACTER_SET_ID = 22
1018 < RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1018 > RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 4 Codepage = 65001)
1019   RDB$CHARACTER_SET_ID = 23
1020 < RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1020 > RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 4 Codepage = 65001)
1021   RDB$CHARACTER_SET_ID = 34
1022 < RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1022 > RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 4 Codepage = 65001)
1023   RDB$CHARACTER_SET_ID = 35
1024 < RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1024 > RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 4 Codepage = 65001)
1025   RDB$CHARACTER_SET_ID = 36
1026 < RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1026 > RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 4 Codepage = 65001)
1027   RDB$CHARACTER_SET_ID = 37
1028 < RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1028 > RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 4 Codepage = 65001)
1029   RDB$CHARACTER_SET_ID = 38
1030 < RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1030 > RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 4 Codepage = 65001)
1031   RDB$CHARACTER_SET_ID = 39
1032 < RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1032 > RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 4 Codepage = 65001)
1033   RDB$CHARACTER_SET_ID = 40
1034 < RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1034 > RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 4 Codepage = 65001)
1035   RDB$CHARACTER_SET_ID = 44
1036 < RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1036 > RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 4 Codepage = 65001)
1037   RDB$CHARACTER_SET_ID = 45
1038 < RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1038 > RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 4 Codepage = 65001)
1039   RDB$CHARACTER_SET_ID = 46
1040 < RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1040 > RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 4 Codepage = 65001)
1041   RDB$CHARACTER_SET_ID = 47
1042 < RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1042 > RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 4 Codepage = 65001)
1043   RDB$CHARACTER_SET_ID = 48
1044 < RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1044 > RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 4 Codepage = 65001)
1045   RDB$CHARACTER_SET_ID = 49
1046 < RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1046 > RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 4 Codepage = 65001)
1047   RDB$CHARACTER_SET_ID = 50
1048 < RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1048 > RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 4 Codepage = 65001)
1049   RDB$CHARACTER_SET_ID = 51
1050 < RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1050 > RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 4 Codepage = 65001)
1051   RDB$CHARACTER_SET_ID = 52
1052 < RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1052 > RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 4 Codepage = 65001)
1053   RDB$CHARACTER_SET_ID = 53
1054 < RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1054 > RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 4 Codepage = 65001)
1055   RDB$CHARACTER_SET_ID = 54
1056 < RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1056 > RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 4 Codepage = 65001)
1057   RDB$CHARACTER_SET_ID = 55
1058 < RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1058 > RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 4 Codepage = 65001)
1059   RDB$CHARACTER_SET_ID = 56
1060 < RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1060 > RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 4 Codepage = 65001)
1061   RDB$CHARACTER_SET_ID = 57
1062 < RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1062 > RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 4 Codepage = 65001)
1063   RDB$CHARACTER_SET_ID = 58
1064 < RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1064 > RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 4 Codepage = 65001)
1065   RDB$CHARACTER_SET_ID = 59
1066 < RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1066 > RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 4 Codepage = 65001)
1067   RDB$CHARACTER_SET_ID = 60
1068 < RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1068 > RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 4 Codepage = 65001)
1069   RDB$CHARACTER_SET_ID = 63
1070 < RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1070 > RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 4 Codepage = 65001)
1071   RDB$CHARACTER_SET_ID = 64
1072 < RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1072 > RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 4 Codepage = 65001)
1073   RDB$CHARACTER_SET_ID = 65
1074 < RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1074 > RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 4 Codepage = 65001)
1075   RDB$CHARACTER_SET_ID = 66
1076 < RDB$CHARACTER_SET_NAME = GBK (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1076 > RDB$CHARACTER_SET_NAME = GBK (Charset Id = 4 Codepage = 65001)
1077   RDB$CHARACTER_SET_ID = 67
1078 < RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1078 > RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 4 Codepage = 65001)
1079   RDB$CHARACTER_SET_ID = 68
1080 < RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1080 > RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 4 Codepage = 65001)
1081   RDB$CHARACTER_SET_ID = 69
1082  
1083   Metadata
# Line 824 | Line 1157 | Scale = 0
1157   Charset id = 0
1158   Not Null
1159   Size = 4
1160 + Value = 0
1161  
1162   SQLType =SQL_VARYING
1163   sub type = 0
# Line 852 | Line 1186 | Size = 8
1186   ROWID = 1
1187   FIXEDPOINT = 20.28
1188   FLOATINGPOINT = 3.14
1189 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
1189 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1190   BLOBDATA = NULL
1191  
1192   SQL Params
# Line 871 | Line 1205 | Scale = 0
1205   Charset id = 0
1206   Not Null
1207   Size = 4
1208 + Value = 0
1209  
1210   ROWID = 1
1211   FIXEDPOINT = 20.28
1212   FLOATINGPOINT = 3.14
1213 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
1213 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1214   BLOBDATA (Charset Id = 4 Codepage = 65001)
1215  
1216   To be or not to be-that is the question:
# Line 923 | Line 1258 | Scale = 0
1258   Charset id = 0
1259   Not Null
1260   Size = 4
1261 + Value = 0
1262  
1263   SQLType =SQL_VARYING
1264   sub type = 0
# Line 951 | Line 1287 | Size = 8
1287   ROWID = 1
1288   FIXEDPOINT = 20.28
1289   FLOATINGPOINT = 3.14
1290 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
1290 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1291   BLOBDATA (Charset Id = 4 Codepage = 65001)
1292  
1293   To be or not to be-that is the question:
# Line 993 | Line 1329 | Be all my sins remembered
1329   ROWID = 2
1330   FIXEDPOINT = NULL
1331   FLOATINGPOINT = NULL
1332 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
1332 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1333   BLOBDATA (Charset Id = 4 Codepage = 65001)
1334  
1335   To be or not to be-that is the question:
# Line 1118 | Line 1454 | Charset id = 0
1454   Nullable
1455   Size = 2
1456  
1457 < RDB$CHARACTER_SET_NAME = NONE (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1457 > RDB$CHARACTER_SET_NAME = NONE (Charset Id = 53 Codepage = 1252)
1458   RDB$CHARACTER_SET_ID = 0
1459 < RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1459 > RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 53 Codepage = 1252)
1460   RDB$CHARACTER_SET_ID = 1
1461 < RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1461 > RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 53 Codepage = 1252)
1462   RDB$CHARACTER_SET_ID = 2
1463 < RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1463 > RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 53 Codepage = 1252)
1464   RDB$CHARACTER_SET_ID = 3
1465 < RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1465 > RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 53 Codepage = 1252)
1466   RDB$CHARACTER_SET_ID = 4
1467 < RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1467 > RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 53 Codepage = 1252)
1468   RDB$CHARACTER_SET_ID = 5
1469 < RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1469 > RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 53 Codepage = 1252)
1470   RDB$CHARACTER_SET_ID = 6
1471 < RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1471 > RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 53 Codepage = 1252)
1472   RDB$CHARACTER_SET_ID = 9
1473 < RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1473 > RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 53 Codepage = 1252)
1474   RDB$CHARACTER_SET_ID = 10
1475 < RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1475 > RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 53 Codepage = 1252)
1476   RDB$CHARACTER_SET_ID = 11
1477 < RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1477 > RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 53 Codepage = 1252)
1478   RDB$CHARACTER_SET_ID = 12
1479 < RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1479 > RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 53 Codepage = 1252)
1480   RDB$CHARACTER_SET_ID = 13
1481 < RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1481 > RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 53 Codepage = 1252)
1482   RDB$CHARACTER_SET_ID = 14
1483 < RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1483 > RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 53 Codepage = 1252)
1484   RDB$CHARACTER_SET_ID = 15
1485 < RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1485 > RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 53 Codepage = 1252)
1486   RDB$CHARACTER_SET_ID = 16
1487 < RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1487 > RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 53 Codepage = 1252)
1488   RDB$CHARACTER_SET_ID = 17
1489 < RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1489 > RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 53 Codepage = 1252)
1490   RDB$CHARACTER_SET_ID = 18
1491 < RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1491 > RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 53 Codepage = 1252)
1492   RDB$CHARACTER_SET_ID = 19
1493 < RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1493 > RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 53 Codepage = 1252)
1494   RDB$CHARACTER_SET_ID = 21
1495 < RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1495 > RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 53 Codepage = 1252)
1496   RDB$CHARACTER_SET_ID = 22
1497 < RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1497 > RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 53 Codepage = 1252)
1498   RDB$CHARACTER_SET_ID = 23
1499 < RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1499 > RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 53 Codepage = 1252)
1500   RDB$CHARACTER_SET_ID = 34
1501 < RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1501 > RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 53 Codepage = 1252)
1502   RDB$CHARACTER_SET_ID = 35
1503 < RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1503 > RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 53 Codepage = 1252)
1504   RDB$CHARACTER_SET_ID = 36
1505 < RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1505 > RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 53 Codepage = 1252)
1506   RDB$CHARACTER_SET_ID = 37
1507 < RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1507 > RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 53 Codepage = 1252)
1508   RDB$CHARACTER_SET_ID = 38
1509 < RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1509 > RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 53 Codepage = 1252)
1510   RDB$CHARACTER_SET_ID = 39
1511 < RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1511 > RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 53 Codepage = 1252)
1512   RDB$CHARACTER_SET_ID = 40
1513 < RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1513 > RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 53 Codepage = 1252)
1514   RDB$CHARACTER_SET_ID = 44
1515 < RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1515 > RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 53 Codepage = 1252)
1516   RDB$CHARACTER_SET_ID = 45
1517 < RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1517 > RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 53 Codepage = 1252)
1518   RDB$CHARACTER_SET_ID = 46
1519 < RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1519 > RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 53 Codepage = 1252)
1520   RDB$CHARACTER_SET_ID = 47
1521 < RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1521 > RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 53 Codepage = 1252)
1522   RDB$CHARACTER_SET_ID = 48
1523 < RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1523 > RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 53 Codepage = 1252)
1524   RDB$CHARACTER_SET_ID = 49
1525 < RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1525 > RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 53 Codepage = 1252)
1526   RDB$CHARACTER_SET_ID = 50
1527 < RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1527 > RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 53 Codepage = 1252)
1528   RDB$CHARACTER_SET_ID = 51
1529 < RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1529 > RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 53 Codepage = 1252)
1530   RDB$CHARACTER_SET_ID = 52
1531 < RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1531 > RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 53 Codepage = 1252)
1532   RDB$CHARACTER_SET_ID = 53
1533 < RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1533 > RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 53 Codepage = 1252)
1534   RDB$CHARACTER_SET_ID = 54
1535 < RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1535 > RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 53 Codepage = 1252)
1536   RDB$CHARACTER_SET_ID = 55
1537 < RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1537 > RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 53 Codepage = 1252)
1538   RDB$CHARACTER_SET_ID = 56
1539 < RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1539 > RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 53 Codepage = 1252)
1540   RDB$CHARACTER_SET_ID = 57
1541 < RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1541 > RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 53 Codepage = 1252)
1542   RDB$CHARACTER_SET_ID = 58
1543 < RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1543 > RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 53 Codepage = 1252)
1544   RDB$CHARACTER_SET_ID = 59
1545 < RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1545 > RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 53 Codepage = 1252)
1546   RDB$CHARACTER_SET_ID = 60
1547 < RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1547 > RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 53 Codepage = 1252)
1548   RDB$CHARACTER_SET_ID = 63
1549 < RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1549 > RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 53 Codepage = 1252)
1550   RDB$CHARACTER_SET_ID = 64
1551 < RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1551 > RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 53 Codepage = 1252)
1552   RDB$CHARACTER_SET_ID = 65
1553 < RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1553 > RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 53 Codepage = 1252)
1554   RDB$CHARACTER_SET_ID = 66
1555 < RDB$CHARACTER_SET_NAME = GBK (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1555 > RDB$CHARACTER_SET_NAME = GBK (Charset Id = 53 Codepage = 1252)
1556   RDB$CHARACTER_SET_ID = 67
1557 < RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1557 > RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 53 Codepage = 1252)
1558   RDB$CHARACTER_SET_ID = 68
1559 < RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1559 > RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 53 Codepage = 1252)
1560   RDB$CHARACTER_SET_ID = 69
1561  
1562   Metadata
# Line 1300 | Line 1636 | Scale = 0
1636   Charset id = 0
1637   Not Null
1638   Size = 4
1639 + Value = 0
1640  
1641   SQLType =SQL_VARYING
1642   sub type = 0
# Line 1328 | Line 1665 | Size = 8
1665   ROWID = 1
1666   FIXEDPOINT = 20.28
1667   FLOATINGPOINT = 3.14
1668 < TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15)
1668 > TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1669   BLOBDATA = NULL
1670  
1671   SQL Params
# Line 1347 | Line 1684 | Scale = 0
1684   Charset id = 0
1685   Not Null
1686   Size = 4
1687 + Value = 0
1688  
1689   ROWID = 1
1690   FIXEDPOINT = 20.28
1691   FLOATINGPOINT = 3.14
1692 < TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15)
1692 > TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1693   BLOBDATA (Charset Id = 53 Codepage = 1252)
1694  
1695   To be or not to be-that is the question:
# Line 1399 | Line 1737 | Scale = 0
1737   Charset id = 0
1738   Not Null
1739   Size = 4
1740 + Value = 0
1741  
1742   SQLType =SQL_VARYING
1743   sub type = 0
# Line 1427 | Line 1766 | Size = 8
1766   ROWID = 1
1767   FIXEDPOINT = 20.28
1768   FLOATINGPOINT = 3.14
1769 < TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15)
1769 > TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1770   BLOBDATA (Charset Id = 53 Codepage = 1252)
1771  
1772   To be or not to be-that is the question:
# Line 1469 | Line 1808 | Be all my sins remembered
1808   ROWID = 2
1809   FIXEDPOINT = NULL
1810   FLOATINGPOINT = NULL
1811 < TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15)
1811 > TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1812   BLOBDATA (Charset Id = 53 Codepage = 1252)
1813  
1814   To be or not to be-that is the question:
# Line 1594 | Line 1933 | Charset id = 0
1933   Nullable
1934   Size = 2
1935  
1936 < RDB$CHARACTER_SET_NAME = NONE (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1936 > RDB$CHARACTER_SET_NAME = NONE (Charset Id = 3 Codepage = 65001)
1937   RDB$CHARACTER_SET_ID = 0
1938 < RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1938 > RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 3 Codepage = 65001)
1939   RDB$CHARACTER_SET_ID = 1
1940 < RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1940 > RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 3 Codepage = 65001)
1941   RDB$CHARACTER_SET_ID = 2
1942 < RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1942 > RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 3 Codepage = 65001)
1943   RDB$CHARACTER_SET_ID = 3
1944 < RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1944 > RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 3 Codepage = 65001)
1945   RDB$CHARACTER_SET_ID = 4
1946 < RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1946 > RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 3 Codepage = 65001)
1947   RDB$CHARACTER_SET_ID = 5
1948 < RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1948 > RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 3 Codepage = 65001)
1949   RDB$CHARACTER_SET_ID = 6
1950 < RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1950 > RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 3 Codepage = 65001)
1951   RDB$CHARACTER_SET_ID = 9
1952 < RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1952 > RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 3 Codepage = 65001)
1953   RDB$CHARACTER_SET_ID = 10
1954 < RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1954 > RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 3 Codepage = 65001)
1955   RDB$CHARACTER_SET_ID = 11
1956 < RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1956 > RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 3 Codepage = 65001)
1957   RDB$CHARACTER_SET_ID = 12
1958 < RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1958 > RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 3 Codepage = 65001)
1959   RDB$CHARACTER_SET_ID = 13
1960 < RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1960 > RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 3 Codepage = 65001)
1961   RDB$CHARACTER_SET_ID = 14
1962 < RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1962 > RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 3 Codepage = 65001)
1963   RDB$CHARACTER_SET_ID = 15
1964 < RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1964 > RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 3 Codepage = 65001)
1965   RDB$CHARACTER_SET_ID = 16
1966 < RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1966 > RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 3 Codepage = 65001)
1967   RDB$CHARACTER_SET_ID = 17
1968 < RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1968 > RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 3 Codepage = 65001)
1969   RDB$CHARACTER_SET_ID = 18
1970 < RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1970 > RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 3 Codepage = 65001)
1971   RDB$CHARACTER_SET_ID = 19
1972 < RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1972 > RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 3 Codepage = 65001)
1973   RDB$CHARACTER_SET_ID = 21
1974 < RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1974 > RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 3 Codepage = 65001)
1975   RDB$CHARACTER_SET_ID = 22
1976 < RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1976 > RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 3 Codepage = 65001)
1977   RDB$CHARACTER_SET_ID = 23
1978 < RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1978 > RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 3 Codepage = 65001)
1979   RDB$CHARACTER_SET_ID = 34
1980 < RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1980 > RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 3 Codepage = 65001)
1981   RDB$CHARACTER_SET_ID = 35
1982 < RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1982 > RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 3 Codepage = 65001)
1983   RDB$CHARACTER_SET_ID = 36
1984 < RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1984 > RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 3 Codepage = 65001)
1985   RDB$CHARACTER_SET_ID = 37
1986 < RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1986 > RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 3 Codepage = 65001)
1987   RDB$CHARACTER_SET_ID = 38
1988 < RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1988 > RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 3 Codepage = 65001)
1989   RDB$CHARACTER_SET_ID = 39
1990 < RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1990 > RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 3 Codepage = 65001)
1991   RDB$CHARACTER_SET_ID = 40
1992 < RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1992 > RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 3 Codepage = 65001)
1993   RDB$CHARACTER_SET_ID = 44
1994 < RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1994 > RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 3 Codepage = 65001)
1995   RDB$CHARACTER_SET_ID = 45
1996 < RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1996 > RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 3 Codepage = 65001)
1997   RDB$CHARACTER_SET_ID = 46
1998 < RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1998 > RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 3 Codepage = 65001)
1999   RDB$CHARACTER_SET_ID = 47
2000 < RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2000 > RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 3 Codepage = 65001)
2001   RDB$CHARACTER_SET_ID = 48
2002 < RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2002 > RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 3 Codepage = 65001)
2003   RDB$CHARACTER_SET_ID = 49
2004 < RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2004 > RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 3 Codepage = 65001)
2005   RDB$CHARACTER_SET_ID = 50
2006 < RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2006 > RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 3 Codepage = 65001)
2007   RDB$CHARACTER_SET_ID = 51
2008 < RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2008 > RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 3 Codepage = 65001)
2009   RDB$CHARACTER_SET_ID = 52
2010 < RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2010 > RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 3 Codepage = 65001)
2011   RDB$CHARACTER_SET_ID = 53
2012 < RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2012 > RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 3 Codepage = 65001)
2013   RDB$CHARACTER_SET_ID = 54
2014 < RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2014 > RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 3 Codepage = 65001)
2015   RDB$CHARACTER_SET_ID = 55
2016 < RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2016 > RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 3 Codepage = 65001)
2017   RDB$CHARACTER_SET_ID = 56
2018 < RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2018 > RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 3 Codepage = 65001)
2019   RDB$CHARACTER_SET_ID = 57
2020 < RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2020 > RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 3 Codepage = 65001)
2021   RDB$CHARACTER_SET_ID = 58
2022 < RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2022 > RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 3 Codepage = 65001)
2023   RDB$CHARACTER_SET_ID = 59
2024 < RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2024 > RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 3 Codepage = 65001)
2025   RDB$CHARACTER_SET_ID = 60
2026 < RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2026 > RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 3 Codepage = 65001)
2027   RDB$CHARACTER_SET_ID = 63
2028 < RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2028 > RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 3 Codepage = 65001)
2029   RDB$CHARACTER_SET_ID = 64
2030 < RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2030 > RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 3 Codepage = 65001)
2031   RDB$CHARACTER_SET_ID = 65
2032 < RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2032 > RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 3 Codepage = 65001)
2033   RDB$CHARACTER_SET_ID = 66
2034 < RDB$CHARACTER_SET_NAME = GBK (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2034 > RDB$CHARACTER_SET_NAME = GBK (Charset Id = 3 Codepage = 65001)
2035   RDB$CHARACTER_SET_ID = 67
2036 < RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2036 > RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 3 Codepage = 65001)
2037   RDB$CHARACTER_SET_ID = 68
2038 < RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2038 > RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 3 Codepage = 65001)
2039   RDB$CHARACTER_SET_ID = 69
2040  
2041   Metadata
# Line 1776 | Line 2115 | Scale = 0
2115   Charset id = 0
2116   Not Null
2117   Size = 4
2118 + Value = 0
2119  
2120   SQLType =SQL_VARYING
2121   sub type = 0
# Line 1804 | Line 2144 | Size = 8
2144   ROWID = 1
2145   FIXEDPOINT = 20.28
2146   FLOATINGPOINT = 3.14
2147 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2147 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2148   BLOBDATA = NULL
2149  
2150   SQL Params
# Line 1823 | Line 2163 | Scale = 0
2163   Charset id = 0
2164   Not Null
2165   Size = 4
2166 + Value = 0
2167  
2168   ROWID = 1
2169   FIXEDPOINT = 20.28
2170   FLOATINGPOINT = 3.14
2171 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2171 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2172   BLOBDATA (Charset Id = 4 Codepage = 65001)
2173  
2174   To be or not to be-that is the question:
# Line 1875 | Line 2216 | Scale = 0
2216   Charset id = 0
2217   Not Null
2218   Size = 4
2219 + Value = 0
2220  
2221   SQLType =SQL_VARYING
2222   sub type = 0
# Line 1903 | Line 2245 | Size = 8
2245   ROWID = 1
2246   FIXEDPOINT = 20.28
2247   FLOATINGPOINT = 3.14
2248 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2248 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2249   BLOBDATA (Charset Id = 4 Codepage = 65001)
2250  
2251   To be or not to be-that is the question:
# Line 1945 | Line 2287 | Be all my sins remembered
2287   ROWID = 2
2288   FIXEDPOINT = NULL
2289   FLOATINGPOINT = NULL
2290 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2290 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2291   BLOBDATA (Charset Id = 4 Codepage = 65001)
2292  
2293   To be or not to be-that is the question:
# Line 2047 | Line 2389 | Be all my sins remembered
2389  
2390  
2391  
2392 + ------------------------------------------------------
2393   Running Test 7: Create and read back an Array
2394   Metadata
2395   SQLType =SQL_LONG
# Line 2118 | Line 2461 | Column = MYARRAY
2461   Dimensions = 1
2462   Bounds: (0:16)
2463  
2464 + SQLType =SQL_ARRAY
2465 + sub type = 0
2466 + Table = TESTDATA
2467 + Owner = SYSDBA
2468 + Column Name = MYARRAY2
2469 + Alias Name = MYARRAY2
2470 + Field Name = MYARRAY2
2471 + Scale = 0
2472 + Charset id = 0
2473 + Nullable
2474 + Size = 8
2475 + Array Meta Data:
2476 + SQLType =SQL_TIMESTAMP
2477 + Scale = 0
2478 + Charset id = 0
2479 + Size = 8
2480 + Table = TESTDATA
2481 + Column = MYARRAY2
2482 + Dimensions = 1
2483 + Bounds: (0:16)
2484 +
2485 + SQLType =SQL_ARRAY
2486 + sub type = 0
2487 + Table = TESTDATA
2488 + Owner = SYSDBA
2489 + Column Name = MYARRAY3
2490 + Alias Name = MYARRAY3
2491 + Field Name = MYARRAY3
2492 + Scale = 0
2493 + Charset id = 0
2494 + Nullable
2495 + Size = 8
2496 + Array Meta Data:
2497 + SQLType =SQL_INT64
2498 + Scale = -2
2499 + Charset id = 0
2500 + Size = 8
2501 + Table = TESTDATA
2502 + Column = MYARRAY3
2503 + Dimensions = 1
2504 + Bounds: (0:16)
2505 +
2506   SQL Params
2507   SQLType =SQL_LONG
2508   sub type = 0
# Line 2126 | Line 2511 | Scale = 0
2511   Charset id = 0
2512   Not Null
2513   Size = 4
2514 + Value = 0
2515  
2516   SQLType =SQL_VARYING
2517   sub type = 0
# Line 2156 | Line 2542 | Param Name = TITLE
2542   Param Name = DATED
2543   Param Name = NOTES
2544   ROWID = 1
2545 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2546 < DATED = 1/4/2016 09:30:00.100
2547 < NOTES = Écoute moi (Charset Id = 4 Codepage = 65001 Byte Length = 11)
2545 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2546 > DATED = 2016/04/01 09:30:00.1000
2547 > NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
2548   MYARRAY = NULL
2549 + MYARRAY2 = NULL
2550 + MYARRAY3 = NULL
2551  
2552   SQL Params
2553   SQLType =SQL_ARRAY
# Line 2170 | Line 2558 | Charset id = 0
2558   Nullable
2559   Size = 8
2560  
2561 + SQL Params
2562 + SQLType =SQL_ARRAY
2563 + sub type = 0
2564 + Field Name = MYARRAY2
2565 + Scale = 0
2566 + Charset id = 0
2567 + Nullable
2568 + Size = 8
2569 +
2570 + SQL Params
2571 + SQLType =SQL_ARRAY
2572 + sub type = 0
2573 + Field Name = MYARRAY3
2574 + Scale = 0
2575 + Charset id = 0
2576 + Nullable
2577 + Size = 8
2578 +
2579 + Metadata
2580 + SQLType =SQL_LONG
2581 + sub type = 0
2582 + Table = TESTDATA
2583 + Owner = SYSDBA
2584 + Column Name = ROWID
2585 + Alias Name = ROWID
2586 + Field Name = ROWID
2587 + Scale = 0
2588 + Charset id = 0
2589 + Not Null
2590 + Size = 4
2591 +
2592 + SQLType =SQL_VARYING
2593 + sub type = 0
2594 + Table = TESTDATA
2595 + Owner = SYSDBA
2596 + Column Name = TITLE
2597 + Alias Name = TITLE
2598 + Field Name = TITLE
2599 + Scale = 0
2600 + Charset id = 4
2601 + Nullable
2602 + Size = 128
2603 +
2604 + SQLType =SQL_TIMESTAMP
2605 + sub type = 0
2606 + Table = TESTDATA
2607 + Owner = SYSDBA
2608 + Column Name = DATED
2609 + Alias Name = DATED
2610 + Field Name = DATED
2611 + Scale = 0
2612 + Charset id = 0
2613 + Nullable
2614 + Size = 8
2615 +
2616 + SQLType =SQL_VARYING
2617 + sub type = 0
2618 + Table = TESTDATA
2619 + Owner = SYSDBA
2620 + Column Name = NOTES
2621 + Alias Name = NOTES
2622 + Field Name = NOTES
2623 + Scale = 0
2624 + Charset id = 4
2625 + Nullable
2626 + Size = 256
2627 +
2628 + SQLType =SQL_ARRAY
2629 + sub type = 0
2630 + Table = TESTDATA
2631 + Owner = SYSDBA
2632 + Column Name = MYARRAY
2633 + Alias Name = MYARRAY
2634 + Field Name = MYARRAY
2635 + Scale = 0
2636 + Charset id = 0
2637 + Nullable
2638 + Size = 8
2639 + Array Meta Data:
2640 + SQLType =SQL_LONG
2641 + Scale = 0
2642 + Charset id = 0
2643 + Size = 4
2644 + Table = TESTDATA
2645 + Column = MYARRAY
2646 + Dimensions = 1
2647 + Bounds: (0:16)
2648 +
2649 + SQLType =SQL_ARRAY
2650 + sub type = 0
2651 + Table = TESTDATA
2652 + Owner = SYSDBA
2653 + Column Name = MYARRAY2
2654 + Alias Name = MYARRAY2
2655 + Field Name = MYARRAY2
2656 + Scale = 0
2657 + Charset id = 0
2658 + Nullable
2659 + Size = 8
2660 + Array Meta Data:
2661 + SQLType =SQL_TIMESTAMP
2662 + Scale = 0
2663 + Charset id = 0
2664 + Size = 8
2665 + Table = TESTDATA
2666 + Column = MYARRAY2
2667 + Dimensions = 1
2668 + Bounds: (0:16)
2669 +
2670 + SQLType =SQL_ARRAY
2671 + sub type = 0
2672 + Table = TESTDATA
2673 + Owner = SYSDBA
2674 + Column Name = MYARRAY3
2675 + Alias Name = MYARRAY3
2676 + Field Name = MYARRAY3
2677 + Scale = 0
2678 + Charset id = 0
2679 + Nullable
2680 + Size = 8
2681 + Array Meta Data:
2682 + SQLType =SQL_INT64
2683 + Scale = -2
2684 + Charset id = 0
2685 + Size = 8
2686 + Table = TESTDATA
2687 + Column = MYARRAY3
2688 + Dimensions = 1
2689 + Bounds: (0:16)
2690 +
2691   ROWID = 1
2692 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2693 < DATED = 1/4/2016 09:30:00.100
2694 < NOTES = Écoute moi (Charset Id = 4 Codepage = 65001 Byte Length = 11)
2695 < 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)
2692 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2693 > DATED = 2016/04/01 09:30:00.1000
2694 > NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
2695 > MYARRAY = 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)
2696 >
2697 > MYARRAY2 = Array: (0: 01/5/2020 12:00:00) (1: 01/5/2020 12:01:00) (2: 01/5/2020 12:02:00) (3: 01/5/2020 12:03:00) (4: 01/5/2020 12:04:00) (5: 01/5/2020 12:05:00) (6: 01/5/2020 12:06:00) (7: 01/5/2020 12:07:00) (8: 01/5/2020 12:08:00) (9: 01/5/2020 12:09:00) (10: 01/5/2020 12:10:00) (11: 01/5/2020 12:11:00) (12: 01/5/2020 12:12:00) (13: 01/5/2020 12:13:00) (14: 01/5/2020 12:14:00) (15: 01/5/2020 12:15:00) (16: 01/5/2020 12:16:00)
2698 >
2699 > MYARRAY3 = Array: (0: 0) (1: 1.04) (2: 2.09) (3: 3.15) (4: 4.19) (5: 5.25) (6: 6.3) (7: 7.34) (8: 8.39) (9: 9.44) (10: 10.5) (11: 11.55) (12: 12.6) (13: 13.64) (14: 0.42) (15: 42.45) (16: 4269)
2700 >
2701  
2702   Shrink to 2:10
2703   Array: (2: 98) (3: 97) (4: 96) (5: 95) (6: 94) (7: 93) (8: 92) (9: 91) (10: 90)
2704 +
2705   Write updated reduced slice
2706   Show update array
2707   ROWID = 1
2708 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2709 < DATED = 1/4/2016 09:30:00.100
2710 < NOTES = Écoute moi (Charset Id = 4 Codepage = 65001 Byte Length = 11)
2711 < 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)
2708 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2709 > DATED = 2016/04/01 09:30:00.1000
2710 > NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
2711 > MYARRAY = 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)
2712  
2713 + MYARRAY2 = Array: (0: 01/5/2020 12:00:00) (1: 01/5/2020 12:01:00) (2: 01/5/2020 12:02:00) (3: 01/5/2020 12:03:00) (4: 01/5/2020 12:04:00) (5: 01/5/2020 12:05:00) (6: 01/5/2020 12:06:00) (7: 01/5/2020 12:07:00) (8: 01/5/2020 12:08:00) (9: 01/5/2020 12:09:00) (10: 01/5/2020 12:10:00) (11: 01/5/2020 12:11:00) (12: 01/5/2020 12:12:00) (13: 01/5/2020 12:13:00) (14: 01/5/2020 12:14:00) (15: 01/5/2020 12:15:00) (16: 01/5/2020 12:16:00)
2714  
2715 + MYARRAY3 = Array: (0: 0) (1: 1.04) (2: 2.09) (3: 3.15) (4: 4.19) (5: 5.25) (6: 6.3) (7: 7.34) (8: 8.39) (9: 9.44) (10: 10.5) (11: 11.55) (12: 12.6) (13: 13.64) (14: 0.42) (15: 42.45) (16: 4269)
2716  
2717 +
2718 +
2719 +
2720 + ------------------------------------------------------
2721   Running Test 8: Create and read back an Array with 2 dimensions
2722   Metadata
2723   SQLType =SQL_LONG
# Line 2243 | Line 2773 | Scale = 0
2773   Charset id = 0
2774   Not Null
2775   Size = 4
2776 + Value = 0
2777  
2778   SQLType =SQL_VARYING
2779   sub type = 0
# Line 2253 | Line 2784 | Nullable
2784   Size = 128
2785  
2786   ROWID = 1
2787 < TITLE = 2D Array (Charset Id = 4 Codepage = 65001 Byte Length = 8)
2787 > TITLE = 2D Array (Charset Id = 4 Codepage = 65001)
2788   MYARRAY = NULL
2789  
2790   ROWID = 1
2791 < TITLE = 2D Array (Charset Id = 4 Codepage = 65001 Byte Length = 8)
2792 < 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)
2791 > TITLE = 2D Array (Charset Id = 4 Codepage = 65001)
2792 > MYARRAY = 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)
2793  
2794  
2795  
2796 +
2797 + ------------------------------------------------------
2798   Running Test 9: Database Information tests
2799   Database ID = 4 FB = /opt/firebird3.0.5/examples/empbuild/employee.fdb SN = zeus
2800   Pages =307
# Line 2273 | Line 2806 | ODS major = 12
2806   Page Size = 8192
2807   Version = 1: LI-V6.3.5.33220 Firebird 3.0
2808   Database is Read/Write
2809 < Database Created: 9/1/2020 13:13:45
2809 > Database Created: 09/1/2020 13:13:45
2810   Pages Used = 297
2811   Pages Free = 10
2812 < Server Memory = 19195648
2812 > Server Memory = 19196128
2813   Forced Writes  = 1
2814 < Max Memory  = 19316160
2814 > Max Memory  = 19316896
2815   Num Buffers  = 2048
2816   Sweep Interval  = 20000
2817   Logged in Users: SYSDBA,
# Line 2324 | Line 2857 | Update Count Operation Counts
2857   Page Size = 8192
2858  
2859  
2860 + ------------------------------------------------------
2861   Running Test 10: Event Handling
2862   Call Async Wait
2863   Async Wait Called
# Line 2350 | Line 2884 | Event Signalled
2884   Event Counts: TESTEVENT, Count = 1
2885  
2886  
2887 + ------------------------------------------------------
2888   Running Test 11: Services API
2889 + SPB: Item Count = 2
2890 +  user_name = SYSDBA
2891 +  password = masterkey
2892 +
2893   Service Manager Version = 2
2894   Server Version = LI-V3.0.5.33220 Firebird 3.0
2895   Implementation = Firebird/Linux/AMD/Intel/x64
# Line 2372 | Line 2911 | User ID = 0
2911   Group ID = 0
2912  
2913  
2914 < Licence Info:
2376 < feature is not supported
2914 > Licence Info: feature is not supported
2915   -feature is not supported
2916  
2917 < Licence Mask Info:
2380 < feature is not supported
2917 > Licence Mask Info: feature is not supported
2918  
2919   Capabilities = 6
2920  
# Line 2407 | Line 2944 | Database OK
2944   Database Dropped
2945  
2946  
2947 + ------------------------------------------------------
2948   Running Test 12: Character Sets
2949   SQL Params
2950   SQLType =SQL_LONG
# Line 2416 | Line 2954 | Scale = 0
2954   Charset id = 0
2955   Not Null
2956   Size = 4
2957 + Value = 0
2958  
2959   SQLType =SQL_VARYING
2960   sub type = 0
# Line 2465 | Line 3004 | Charset id = 4
3004   Nullable
3005   Size = 16
3006  
3007 + Show Param Values
3008 + SQL Params
3009 + SQLType =SQL_LONG
3010 + sub type = 0
3011 + Field Name = ROWID
3012 + Scale = 0
3013 + Charset id = 0
3014 + Not Null
3015 + Size = 4
3016 + Value = 1
3017 +
3018 + SQLType =SQL_VARYING
3019 + sub type = 0
3020 + Field Name = TITLE
3021 + Scale = 0
3022 + Charset id = 4
3023 + Nullable
3024 + Size = 128
3025 + Value = Blob Test ©€
3026 +
3027 + SQLType =SQL_VARYING
3028 + sub type = 0
3029 + Field Name = NOTES
3030 + Scale = 0
3031 + Charset id = 4
3032 + Nullable
3033 + Size = 256
3034 + Value = Écoute moi
3035 +
3036 + SQLType =SQL_VARYING
3037 + sub type = 1
3038 + Field Name = BLOBDATA
3039 + Scale = 0
3040 + Charset id = 4
3041 + Nullable
3042 + Size = 8192
3043 + Value = Some German Special Characters like ÖÄÜöäüß
3044 +
3045 + SQLType =SQL_BLOB
3046 + sub type = 1
3047 + Field Name = BLOBDATA2
3048 + Scale = 0
3049 + Charset id = 4
3050 + Nullable
3051 + Size = 8
3052 + Value = Some German Special Characters like ÖÄÜöäüß
3053 +
3054 + SQLType =SQL_VARYING
3055 + sub type = 0
3056 + Field Name = INCLEAR
3057 + Scale = 0
3058 + Charset id = 1
3059 + Nullable
3060 + Size = 16
3061 + Value = &Test
3062  
3063 +
3064 + SQLType =SQL_VARYING
3065 + sub type = 0
3066 + Field Name = FIXEDWIDTH
3067 + Scale = 0
3068 + Charset id = 4
3069 + Nullable
3070 + Size = 16
3071 + Value = É
3072 +
3073   Connection Character Set UTF8
3074   ROWID = 1
3075 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001 Byte Length = 15)
3076 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
3075 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
3076 > NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
3077   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)
3078   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)
3079 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3080 < FIXEDWIDTH = C3 89  (Charset Id = 4 Codepage = 65001 Byte Length = 5)
3079 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3080 > FIXEDWIDTH = C3 89  (Charset Id = 4 Codepage = 65001)
3081  
3082   Connection Character Set NONE
3083   ROWID = 1
3084 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001 Byte Length = 15)
3085 < NOTES = C9 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 21 Codepage = 28591 Byte Length = 10)
3084 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
3085 > NOTES = C9 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 21 Codepage = 28591)
3086   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)
3087   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)
3088 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3089 < FIXEDWIDTH = C3 89  (Charset Id = 4 Codepage = 65001 Byte Length = 5)
3088 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3089 > FIXEDWIDTH = C3 89  (Charset Id = 4 Codepage = 65001)
3090  
3091   Connection Character Set WIN1252
3092   ROWID = 1
3093 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 A9 80  (Charset Id = 53 Codepage = 1252 Byte Length = 12)
3094 < NOTES = C9 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 53 Codepage = 1252 Byte Length = 10)
3093 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 A9 80  (Charset Id = 53 Codepage = 1252)
3094 > NOTES = C9 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 53 Codepage = 1252)
3095   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)
3096   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)
3097 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3098 < FIXEDWIDTH = C9  (Charset Id = 53 Codepage = 1252 Byte Length = 4)
3097 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3098 > FIXEDWIDTH = C9  (Charset Id = 53 Codepage = 1252)
3099  
3100  
3101  
3102 + ------------------------------------------------------
3103   Running Test 13: Transaction over two databases
3104   Init Database 1
3105   ROWID = 1
3106 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001 Byte Length = 15)
3107 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
3106 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
3107 > NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
3108   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)
3109   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)
3110 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3110 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3111  
3112   Init Database 2
3113   ROWID = 1
3114 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001 Byte Length = 15)
3115 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
3114 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
3115 > NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
3116   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)
3117   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)
3118 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3118 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3119  
3120   ROWID = 1
3121 < TITLE = 44 61 74 61 62 61 73 65 31  (Charset Id = 4 Codepage = 65001 Byte Length = 9)
3122 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
3121 > TITLE = 44 61 74 61 62 61 73 65 31  (Charset Id = 4 Codepage = 65001)
3122 > NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
3123   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)
3124   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)
3125 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3125 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3126  
3127   ROWID = 1
3128 < TITLE = 44 61 74 61 62 61 73 65 32  (Charset Id = 4 Codepage = 65001 Byte Length = 9)
3129 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
3128 > TITLE = 44 61 74 61 62 61 73 65 32  (Charset Id = 4 Codepage = 65001)
3129 > NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
3130   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)
3131   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)
3132 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3132 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3133  
3134  
3135  
3136 + ------------------------------------------------------
3137   Running Test 14: Non select procedures
3138   Default Character set Name = UTF8
3139   Metadata
# Line 2555 | Line 3161 | Nullable
3161   Size = 128
3162  
3163   ROWID = 1
3164 < TITLE = Testing (Charset Id = 4 Codepage = 65001 Byte Length = 7)
3164 > TITLE = Testing (Charset Id = 4 Codepage = 65001)
3165  
3166   Repeat with a different execute transaction
3167  
3168   ROWID = 1
3169 < TITLE = Testing (Charset Id = 4 Codepage = 65001 Byte Length = 7)
3169 > TITLE = Testing (Charset Id = 4 Codepage = 65001)
3170  
3171   Repeat with a original transaction
3172  
3173   ROWID = 1
3174 < TITLE = Testing (Charset Id = 4 Codepage = 65001 Byte Length = 7)
3174 > TITLE = Testing (Charset Id = 4 Codepage = 65001)
3175  
3176  
3177 + ------------------------------------------------------
3178   Running Test 15: Blob Handling and BPBs
3179  
3180   Testdata
3181  
3182   ROWID = 1
3183 < TITLE = Blob Test (Charset Id = 4 Codepage = 65001 Byte Length = 9)
3183 > TITLE = Blob Test (Charset Id = 4 Codepage = 65001)
3184   BLOBDATA = (blob), Length = 92514
3185  
3186 + ROWID = 2
3187 + TITLE = Blob Test with binary string (Charset Id = 4 Codepage = 65001)
3188 + BLOBDATA = (blob), Length = 13
3189 + 0 9 A C9 63 6F 75 74 65 20 6D 6F 69
3190  
3191   Testdata 2
3192  
3193   ROWID = 1
3194 < TITLE = Blob Test (Charset Id = 4 Codepage = 65001 Byte Length = 9)
3194 > TITLE = Blob Test (Charset Id = 4 Codepage = 65001)
3195   BLOBDATA (Charset Id = 4 Codepage = 65001)
3196  
3197   Écoute moi
3198  
3199  
3200  
3201 + ------------------------------------------------------
3202   Running Test 16: Error handling
3203   Invalid Database Name Test
3204 < Error Handled:
2593 < I/O error during "open" operation for file "Malformed Name"
3204 > Error Handled: I/O error during "open" operation for file "Malformed Name"
3205   -Error while trying to open file
3206   -No such file or directory
3207   Invalid User Name Test
3208 < Error Handled:
2598 < Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3208 > Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3209   Invalid password Test
3210 < Error Handled:
2601 < Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3210 > Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3211   Invalid Prepare SQL Test
3212 < Error Handled:
2604 < Dynamic SQL Error
3212 > Error Handled: Dynamic SQL Error
3213   -SQL error code = -206
3214   -Column unknown
3215   -UNKNOWN_DATE
3216   -At line 1, column 21 When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ?
3217   Invalid Open Cursor SQL Test
3218 < Error Handled:
2611 < Dynamic SQL Error
3218 > Error Handled: Dynamic SQL Error
3219   -SQL error code = -206
3220   -Column unknown
3221   -X
# Line 2619 | Line 3226 | Invalid Param SQL Type Test
3226   Error Handled: Field "EMP_NO" not found
3227   Case sensitive Param SQL  Test
3228   Error Handled: Field "EMP_NO" not found
3229 + Stale Reference Check
3230 + First test correct usage
3231 + COUNTER = 42
3232 +
3233 + New Transaction before param set
3234 + Error Handled: This interface is no longer up-to-date
3235 + New Transaction before Open Cursor
3236 + Error Handled: This interface is no longer up-to-date
3237 + Stop Stale Reference Checks
3238 + New Transaction before param set
3239 + COUNTER = 42
3240 +
3241 + New Transaction before Open Cursor
3242 + COUNTER = 42
3243 +
3244   Invalid Server Name Test
3245 < Error Handled:
2624 < Unable to complete network request to host "unknown".
3245 > Error Handled: Unable to complete network request to host "unknown".
3246   -Failed to locate host machine.
3247   -The specified name was not found in the hosts file or Domain Name Services
3248   Invalid User Name Test
3249 < Error Handled:
2629 < Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3249 > Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3250   Invalid password Test
3251 < Error Handled:
3252 < Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3251 > Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3252 >
3253 >
3254 > ------------------------------------------------------
3255 > Running Test 17: Date/Time tests and Firebird 4 extensions
3256 > FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.5.33220 Firebird 3.0"
3257 > Has Local TZ DB = FALSE
3258 >
3259 > Testdata
3260 >
3261 > Metadata
3262 > SQLType =SQL_LONG
3263 > sub type = 0
3264 > Table = TESTDATA
3265 > Owner = SYSDBA
3266 > Column Name = ROWID
3267 > Alias Name = ROWID
3268 > Field Name = ROWID
3269 > Scale = 0
3270 > Charset id = 0
3271 > Not Null
3272 > Size = 4
3273 >
3274 > SQLType =SQL_TYPE_DATE
3275 > sub type = 0
3276 > Table = TESTDATA
3277 > Owner = SYSDBA
3278 > Column Name = DATECOL
3279 > Alias Name = DATECOL
3280 > Field Name = DATECOL
3281 > Scale = 0
3282 > Charset id = 0
3283 > Nullable
3284 > Size = 4
3285 >
3286 > SQLType =SQL_TYPE_TIME
3287 > sub type = 0
3288 > Table = TESTDATA
3289 > Owner = SYSDBA
3290 > Column Name = TIMECOL
3291 > Alias Name = TIMECOL
3292 > Field Name = TIMECOL
3293 > Scale = 0
3294 > Charset id = 0
3295 > Nullable
3296 > Size = 4
3297 >
3298 > SQLType =SQL_TIMESTAMP
3299 > sub type = 0
3300 > Table = TESTDATA
3301 > Owner = SYSDBA
3302 > Column Name = TIMESTAMPCOL
3303 > Alias Name = TIMESTAMPCOL
3304 > Field Name = TIMESTAMPCOL
3305 > Scale = 0
3306 > Charset id = 0
3307 > Nullable
3308 > Size = 8
3309 >
3310 > ROWID = 1
3311 > DATECOL = 2019/04/01
3312 > TIMECOL = 11:31:05.0001
3313 > TIMESTAMPCOL = 2016/02/29 22:02:35.0001
3314 > ROWID = 2
3315 > DATECOL = 1939/09/03
3316 > TIMECOL = 15:40:00.0002
3317 > TIMESTAMPCOL = 1918/11/11 11:11:00.0000
3318 > ROWID = 3
3319 > DATECOL = 1066/10/14
3320 > TIMECOL = 23:59:59.9994
3321 > TIMESTAMPCOL = 1918/11/11 11:11:00.0000
3322 > ROWID = 4
3323 > DATECOL = 1815/06/18
3324 > TIMECOL = 00:01:40.1115
3325 > TIMESTAMPCOL = 1945/05/08 22:10:00.0010
3326 >
3327 >
3328 > Testdata - second pass
3329 >
3330 > 1, 01/4/2019, 11:31:05, 29/2/2016 22:02:35
3331 > 2, 03/9/1939, 15:40:00.000, 11/11/1918 11:11:00
3332 > 3, 14/10/1066, 23:59:59.999, 11/11/1918 11:11:00
3333 > 4, 18/6/1815, 00:01:40.112, 08/5/1945 22:10:00
3334 > Sys Time = 1945, 5, 8, 2, 22, 10, 0, 1
3335 > Skipping Firebird 4 and later test part
3336 >
3337 >
3338 > ------------------------------------------------------
3339 > Running Test 18: Firebird 4 Decfloat extensions
3340 > FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.5.33220 Firebird 3.0"
3341 > Skipping test for Firebird 4 and later
3342 >
3343 >
3344 > ------------------------------------------------------
3345 > Running Test 19: Batch Update and Insert Queries
3346 > Opening inet://localhost/employee
3347 > Skipping test for Firebird 4 and later
3348 >
3349 >
3350 > ------------------------------------------------------
3351 > Running Test 20: Stress Test IBatch interface
3352 > FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.5.33220 Firebird 3.0"
3353 > Skipping test for Firebird 4 and later
3354 >
3355 >
3356 > ------------------------------------------------------
3357 > Running Test 21: Exercise setting and getting of numeric data types
3358 > 1234.567 parsed to 1234567 scale = -3
3359 > As Float =  1.2345670000000000E+003
3360 > -765.4321 parsed to -7654321 scale = -4
3361 > As Float = -7.6543209999999999E+002
3362 > 0.1 parsed to 1 scale = -1
3363 > As Float =  1.0000000000000001E-001
3364 > 0.01 parsed to 1 scale = -2
3365 > As Float =  1.0000000000000000E-002
3366 > +123 parsed to 123 scale = 0
3367 > As Float =  1.2300000000000000E+002
3368 > 1.23456E308 parsed to 123456 scale = 303
3369 > As Float =  1.2345600000000001E+308
3370 > -1.2e-02 parsed to -12 scale = -3
3371 > As Float = -1.2000000000000000E-002
3372 > 10. parsed to 10 scale = 0
3373 > As Float =  1.0000000000000000E+001
3374 > .12 parsed to 12 scale = -2
3375 > As Float =  1.2000000000000000E-001
3376 > 0.12 parsed to 12 scale = -2
3377 > As Float =  1.2000000000000000E-001
3378 > Parsing of 1.2E1.2 failed
3379 > Parsing of 1,000 failed
3380 > Parsing of 1e1e1 failed
3381 > Parsing of 1.2+3 failed
3382 > SQL Params
3383 > SQLType =SQL_LONG
3384 > sub type = 0
3385 > Field Name =
3386 > Scale = 0
3387 > Charset id = 0
3388 > Not Null
3389 > Size = 4
3390 > Value = 0
3391 >
3392 > SQLType =SQL_LONG
3393 > sub type = 0
3394 > Field Name =
3395 > Scale = 0
3396 > Charset id = 0
3397 > Nullable
3398 > Size = 4
3399 >
3400 > SQLType =SQL_INT64
3401 > sub type = 0
3402 > Field Name =
3403 > Scale = 0
3404 > Charset id = 0
3405 > Nullable
3406 > Size = 8
3407 >
3408 > SQLType =SQL_INT64
3409 > sub type = 0
3410 > Field Name =
3411 > Scale = -4
3412 > Charset id = 0
3413 > Nullable
3414 > Size = 8
3415 >
3416 > SQLType =SQL_DOUBLE
3417 > sub type = 0
3418 > Field Name =
3419 > Scale = 0
3420 > Charset id = 0
3421 > Nullable
3422 > Size = 8
3423 >
3424 > SQLType =SQL_INT64
3425 > sub type = 0
3426 > Field Name =
3427 > Scale = -6
3428 > Charset id = 0
3429 > Nullable
3430 > Size = 8
3431 >
3432 > Expected Error - Dynamic SQL Error
3433 > -SQL error code = -303
3434 > -conversion error from string "1,000"
3435 > Expected Error - Dynamic SQL Error
3436 > -SQL error code = -303
3437 > -conversion error from string "10.0.0"
3438 > ROWID = 1
3439 > ITYPE = 101
3440 > I64TYPE = 9223372036854775807
3441 > CURRTYPE = 10,000.12340000
3442 > DTYPE = 9,999.12345678
3443 > FIXEDPOINT = 1,234,567,890.12345700
3444 > ROWID = 2
3445 > ITYPE = -32457
3446 > I64TYPE = -9223372036854775808
3447 > CURRTYPE = 1,000,001.12000000
3448 > DTYPE = 1.7E308
3449 > FIXEDPOINT = -1,234,567,890.12345700
3450 > ROWID = 3
3451 > ITYPE = 0
3452 > I64TYPE = 0
3453 > CURRTYPE = .00000000
3454 > DTYPE = .00000000
3455 > FIXEDPOINT = .00000000
3456 > ROWID = 4
3457 > ITYPE = 1
3458 > I64TYPE = 10
3459 > CURRTYPE = .02300000
3460 > DTYPE = .00110000
3461 > FIXEDPOINT = 233.45600000
3462 >
3463  
3464  
3465 + ------------------------------------------------------
3466   Test Suite Ends

Diff Legend

– Removed lines
+ Added lines
< Changed lines
> Changed lines