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 350 by tony, Wed Oct 20 14:58:56 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   Opening inet://localhost/employee
80   Database Open, SQL Dialect = 3
81 + TPB: Item Count = 3
82 +  isc_tpb_read
83 +  isc_tpb_nowait
84 +  isc_tpb_concurrency
85 +
86 + Metadata
87 + SQLType =SQL_SHORT
88 + sub type = 0
89 + Table = EMPLOYEE
90 + Owner = SYSDBA
91 + Column Name = EMP_NO
92 + Alias Name = EMP_NO
93 + Field Name = EMP_NO
94 + Scale = 0
95 + Charset id = 0
96 + Not Null
97 + Size = 2
98 +
99 + SQLType =SQL_VARYING
100 + sub type = 0
101 + Table = EMPLOYEE
102 + Owner = SYSDBA
103 + Column Name = FIRST_NAME
104 + Alias Name = FIRST_NAME
105 + Field Name = FIRST_NAME
106 + Scale = 0
107 + Charset id = 0
108 + Not Null
109 + Size = 15
110 +
111 + SQLType =SQL_VARYING
112 + sub type = 0
113 + Table = EMPLOYEE
114 + Owner = SYSDBA
115 + Column Name = LAST_NAME
116 + Alias Name = LAST_NAME
117 + Field Name = LAST_NAME
118 + Scale = 0
119 + Charset id = 0
120 + Not Null
121 + Size = 20
122 +
123 + SQLType =SQL_VARYING
124 + sub type = 0
125 + Table = EMPLOYEE
126 + Owner = SYSDBA
127 + Column Name = PHONE_EXT
128 + Alias Name = PHONE_EXT
129 + Field Name = PHONE_EXT
130 + Scale = 0
131 + Charset id = 0
132 + Nullable
133 + Size = 4
134 +
135 + SQLType =SQL_TIMESTAMP
136 + sub type = 0
137 + Table = EMPLOYEE
138 + Owner = SYSDBA
139 + Column Name = HIRE_DATE
140 + Alias Name = HIRE_DATE
141 + Field Name = HIRE_DATE
142 + Scale = 0
143 + Charset id = 0
144 + Not Null
145 + Size = 8
146 +
147 + SQLType =SQL_TEXT
148 + sub type = 0
149 + Table = EMPLOYEE
150 + Owner = SYSDBA
151 + Column Name = DEPT_NO
152 + Alias Name = DEPT_NO
153 + Field Name = DEPT_NO
154 + Scale = 0
155 + Charset id = 0
156 + Not Null
157 + Size = 3
158 +
159 + SQLType =SQL_VARYING
160 + sub type = 0
161 + Table = EMPLOYEE
162 + Owner = SYSDBA
163 + Column Name = JOB_CODE
164 + Alias Name = JOB_CODE
165 + Field Name = JOB_CODE
166 + Scale = 0
167 + Charset id = 0
168 + Not Null
169 + Size = 5
170 +
171 + SQLType =SQL_SHORT
172 + sub type = 0
173 + Table = EMPLOYEE
174 + Owner = SYSDBA
175 + Column Name = JOB_GRADE
176 + Alias Name = JOB_GRADE
177 + Field Name = JOB_GRADE
178 + Scale = 0
179 + Charset id = 0
180 + Not Null
181 + Size = 2
182 +
183 + SQLType =SQL_VARYING
184 + sub type = 0
185 + Table = EMPLOYEE
186 + Owner = SYSDBA
187 + Column Name = JOB_COUNTRY
188 + Alias Name = JOB_COUNTRY
189 + Field Name = JOB_COUNTRY
190 + Scale = 0
191 + Charset id = 0
192 + Not Null
193 + Size = 15
194 +
195 + SQLType =SQL_INT64
196 + sub type = 0
197 + Table = EMPLOYEE
198 + Owner = SYSDBA
199 + Column Name = SALARY
200 + Alias Name = SALARY
201 + Field Name = SALARY
202 + Scale = -2
203 + Charset id = 0
204 + Not Null
205 + Size = 8
206 +
207 + SQLType =SQL_VARYING
208 + sub type = 0
209 + Table = EMPLOYEE
210 + Owner = SYSDBA
211 + Column Name = FULL_NAME
212 + Alias Name = FULL_NAME
213 + Field Name = FULL_NAME
214 + Scale = 0
215 + Charset id = 0
216 + Nullable
217 + Size = 37
218 +
219 + Plan =
220 + Select Expression
221 +    -> First N Records
222 +        -> Table "EMPLOYEE" Full Scan
223 + -- SQL style inline comment
224 + /* this is a comment */ Select First 3 * from EMPLOYEE
225 +
226 + EMP_NO = 2
227 + FIRST_NAME = Robert
228 + LAST_NAME = Nelson
229 + PHONE_EXT = 250
230 + HIRE_DATE = 1988/12/28 00:00:00.0000
231 + DEPT_NO = 600
232 + JOB_CODE = VP
233 + JOB_GRADE = 2
234 + JOB_COUNTRY = USA
235 + SALARY = 105,900.00
236 + FULL_NAME = Nelson, Robert
237 + EMP_NO = 4
238 + FIRST_NAME = Bruce
239 + LAST_NAME = Young
240 + PHONE_EXT = 233
241 + HIRE_DATE = 1988/12/28 00:00:00.0000
242 + DEPT_NO = 621
243 + JOB_CODE = Eng
244 + JOB_GRADE = 2
245 + JOB_COUNTRY = USA
246 + SALARY = 97,500.00
247 + FULL_NAME = Young, Bruce
248 + EMP_NO = 5
249 + FIRST_NAME = Kim
250 + LAST_NAME = Lambert
251 + PHONE_EXT = 22
252 + HIRE_DATE = 1989/02/06 00:00:00.0000
253 + DEPT_NO = 130
254 + JOB_CODE = Eng
255 + JOB_GRADE = 2
256 + JOB_COUNTRY = USA
257 + SALARY = 102,750.00
258 + FULL_NAME = Lambert, Kim
259 +
260 + Select * from EMPLOYEE Where EMP_NO = ?
261 + SQL Params
262 + SQLType =SQL_SHORT
263 + sub type = 0
264 + Field Name =
265 + Scale = 0
266 + Charset id = 0
267 + Not Null
268 + Size = 2
269 + Value = 0
270 +
271 + EMP_NO = 8
272 + FIRST_NAME = Leslie
273 + LAST_NAME = Johnson
274 + PHONE_EXT = 410
275 + HIRE_DATE = 1989/04/05 00:00:00.0000
276 + DEPT_NO = 180
277 + JOB_CODE = Mktg
278 + JOB_GRADE = 3
279 + JOB_COUNTRY = USA
280 + SALARY = 64,635.00
281 + FULL_NAME = Johnson, Leslie
282 +
283 + With param names
284 + Select * from EMPLOYEE Where EMP_NO = :EMP_NO
285 + SQL Params
286 + SQLType =SQL_SHORT
287 + sub type = 0
288 + Field Name = EMP_NO
289 + Scale = 0
290 + Charset id = 0
291 + Not Null
292 + Size = 2
293 + Value = 0
294 +
295 + Results for Cursor: Test Cursor
296 + EMP_NO = 8
297 + FIRST_NAME = Leslie
298 + LAST_NAME = Johnson
299 + PHONE_EXT = 410
300 + HIRE_DATE = 1989/04/05 00:00:00.0000
301 + DEPT_NO = 180
302 + JOB_CODE = Mktg
303 + JOB_GRADE = 3
304 + JOB_COUNTRY = USA
305 + SALARY = 64,635.00
306 + FULL_NAME = Johnson, Leslie
307 +
308 + Now open the employee database as a local database
309 + TPB: Item Count = 3
310 +  isc_tpb_read
311 +  isc_tpb_nowait
312 +  isc_tpb_concurrency
313 +
314   Metadata
315   SQLType =SQL_SHORT
316   sub type = 0
# Line 214 | Line 455 | EMP_NO = 2
455   FIRST_NAME = Robert
456   LAST_NAME = Nelson
457   PHONE_EXT = 250
458 < HIRE_DATE = 28/12/1988 00:00:00.000
458 > HIRE_DATE = 1988/12/28 00:00:00.0000
459   DEPT_NO = 600
460   JOB_CODE = VP
461   JOB_GRADE = 2
# Line 225 | Line 466 | EMP_NO = 4
466   FIRST_NAME = Bruce
467   LAST_NAME = Young
468   PHONE_EXT = 233
469 < HIRE_DATE = 28/12/1988 00:00:00.000
469 > HIRE_DATE = 1988/12/28 00:00:00.0000
470   DEPT_NO = 621
471   JOB_CODE = Eng
472   JOB_GRADE = 2
# Line 236 | Line 477 | EMP_NO = 5
477   FIRST_NAME = Kim
478   LAST_NAME = Lambert
479   PHONE_EXT = 22
480 < HIRE_DATE = 6/2/1989 00:00:00.000
480 > HIRE_DATE = 1989/02/06 00:00:00.0000
481   DEPT_NO = 130
482   JOB_CODE = Eng
483   JOB_GRADE = 2
# Line 253 | Line 494 | Scale = 0
494   Charset id = 0
495   Not Null
496   Size = 2
497 + Value = 0
498  
499   EMP_NO = 8
500   FIRST_NAME = Leslie
501   LAST_NAME = Johnson
502   PHONE_EXT = 410
503 < HIRE_DATE = 5/4/1989 00:00:00.000
503 > HIRE_DATE = 1989/04/05 00:00:00.0000
504   DEPT_NO = 180
505   JOB_CODE = Mktg
506   JOB_GRADE = 3
# Line 276 | Line 518 | Scale = 0
518   Charset id = 0
519   Not Null
520   Size = 2
521 + Value = 0
522  
523 + Results for Cursor: Test Cursor
524   EMP_NO = 8
525   FIRST_NAME = Leslie
526   LAST_NAME = Johnson
527   PHONE_EXT = 410
528 < HIRE_DATE = 5/4/1989 00:00:00.000
528 > HIRE_DATE = 1989/04/05 00:00:00.0000
529   DEPT_NO = 180
530   JOB_CODE = Mktg
531   JOB_GRADE = 3
# Line 289 | Line 533 | JOB_COUNTRY = USA
533   SALARY = 64,635.00
534   FULL_NAME = Johnson, Leslie
535  
536 + Scollable Cursors
537 + Do Fetch Next:
538 + EMP_NO = 2
539 + FIRST_NAME = Robert
540 + LAST_NAME = Nelson
541 + PHONE_EXT = 250
542 + HIRE_DATE = 1988/12/28 00:00:00.0000
543 + DEPT_NO = 600
544 + JOB_CODE = VP
545 + JOB_GRADE = 2
546 + JOB_COUNTRY = USA
547 + SALARY = 105,900.00
548 + FULL_NAME = Nelson, Robert
549 + Do Fetch Last:
550 + EMP_NO = 145
551 + FIRST_NAME = Mark
552 + LAST_NAME = Guckenheimer
553 + PHONE_EXT = 221
554 + HIRE_DATE = 1994/05/02 00:00:00.0000
555 + DEPT_NO = 622
556 + JOB_CODE = Eng
557 + JOB_GRADE = 5
558 + JOB_COUNTRY = USA
559 + SALARY = 32,000.00
560 + FULL_NAME = Guckenheimer, Mark
561 + Do Fetch Prior:
562 + EMP_NO = 144
563 + FIRST_NAME = John
564 + LAST_NAME = Montgomery
565 + PHONE_EXT = 820
566 + HIRE_DATE = 1994/03/30 00:00:00.0000
567 + DEPT_NO = 672
568 + JOB_CODE = Eng
569 + JOB_GRADE = 5
570 + JOB_COUNTRY = USA
571 + SALARY = 35,000.00
572 + FULL_NAME = Montgomery, John
573 + Do Fetch First:
574 + EMP_NO = 2
575 + FIRST_NAME = Robert
576 + LAST_NAME = Nelson
577 + PHONE_EXT = 250
578 + HIRE_DATE = 1988/12/28 00:00:00.0000
579 + DEPT_NO = 600
580 + JOB_CODE = VP
581 + JOB_GRADE = 2
582 + JOB_COUNTRY = USA
583 + SALARY = 105,900.00
584 + FULL_NAME = Nelson, Robert
585 + Do Fetch Abs 8 :
586 + EMP_NO = 14
587 + FIRST_NAME = Stewart
588 + LAST_NAME = Hall
589 + PHONE_EXT = 227
590 + HIRE_DATE = 1990/06/04 00:00:00.0000
591 + DEPT_NO = 900
592 + JOB_CODE = Finan
593 + JOB_GRADE = 3
594 + JOB_COUNTRY = USA
595 + SALARY = 69,482.63
596 + FULL_NAME = Hall, Stewart
597 + Do Fetch Relative -2 :
598 + EMP_NO = 11
599 + FIRST_NAME = K. J.
600 + LAST_NAME = Weston
601 + PHONE_EXT = 34
602 + HIRE_DATE = 1990/01/17 00:00:00.0000
603 + DEPT_NO = 130
604 + JOB_CODE = SRep
605 + JOB_GRADE = 4
606 + JOB_COUNTRY = USA
607 + SALARY = 86,292.94
608 + FULL_NAME = Weston, K. J.
609 + Do Fetch beyond EOF :
610 + Fetch returned false
611  
612  
613 + ------------------------------------------------------
614   Running Test 3: ad hoc queries
615   Opening inet://localhost/employee
616   Database Open
# Line 304 | Line 624 | Constrained Employee Count = 3
624   "Yanowski" Employee Count = 1
625  
626  
627 + ------------------------------------------------------
628   Running Test 4: Update, Insert and Delete Queries
629   Opening inet://localhost/employee
630   Database Open
# Line 316 | Line 637 | EMP_NO = 8
637   FIRST_NAME = Leslie
638   LAST_NAME = Johnson
639   PHONE_EXT = 410
640 < HIRE_DATE = 5/4/1989 00:00:00.000
640 > HIRE_DATE = 1989/04/05 00:00:00.0000
641   DEPT_NO = 180
642   JOB_CODE = Mktg
643   JOB_GRADE = 3
# Line 324 | Line 645 | JOB_COUNTRY = USA
645   SALARY = 64,635.00
646   FULL_NAME = Johnson, Leslie
647  
648 < Current memory = 19693296
649 < Delta memory = 4480
650 < Max memory = 19755408
648 > Current memory = 19,694,032
649 > Delta memory = 4,480
650 > Max memory = 19,755,888
651   Elapsed time= 0.001 sec
652   Cpu = 0.000 sec
653   Buffers = 2048
# Line 472 | Line 793 | EMP_NO = 150
793   FIRST_NAME = John
794   LAST_NAME = Doe
795   PHONE_EXT =
796 < HIRE_DATE = 1/4/2015 00:00:00.000
796 > HIRE_DATE = 2015/04/01 00:00:00.0000
797   DEPT_NO = 600
798   JOB_CODE = Eng
799   JOB_GRADE = 4
# Line 485 | Line 806 | EMP_NO = 151
806   FIRST_NAME = Major
807   LAST_NAME = Major
808   PHONE_EXT =
809 < HIRE_DATE = 1/4/2015 00:00:00.000
809 > HIRE_DATE = 2015/04/01 00:00:00.0000
810   DEPT_NO = 600
811   JOB_CODE = Eng
812   JOB_GRADE = 4
# Line 502 | Line 823 | EMP_NO = 150
823   FIRST_NAME = Jane
824   LAST_NAME = Doe
825   PHONE_EXT = NULL
826 < HIRE_DATE = 1/4/2015 00:00:00.000
826 > HIRE_DATE = 2015/04/01 00:00:00.0000
827   DEPT_NO = 600
828   JOB_CODE = Eng
829   JOB_GRADE = 4
# Line 519 | Line 840 | EMP_NO = 150
840   FIRST_NAME = Jayne's
841   LAST_NAME = Doe
842   PHONE_EXT = NULL
843 < HIRE_DATE = 1/4/2015 00:00:00.000
843 > HIRE_DATE = 2015/04/01 00:00:00.0000
844   DEPT_NO = 600
845   JOB_CODE = Eng
846   JOB_GRADE = 4
# Line 533 | Line 854 | EMP_NO = 8
854   FIRST_NAME = Leslie
855   LAST_NAME = Johnson
856   PHONE_EXT = 410
857 < HIRE_DATE = 5/4/1989 00:00:00.000
857 > HIRE_DATE = 1989/04/05 00:00:00.0000
858   DEPT_NO = 180
859   JOB_CODE = Mktg
860   JOB_GRADE = 3
# Line 547 | Line 868 | EMP_NO = 8
868   FIRST_NAME = Leslie
869   LAST_NAME = Johnson
870   PHONE_EXT = 410
871 < HIRE_DATE = 5/4/1989 00:00:00.000
871 > HIRE_DATE = 1989/04/05 00:00:00.0000
872   DEPT_NO = 180
873   JOB_CODE = Mktg
874   JOB_GRADE = 3
# Line 559 | Line 880 | EMP_NO = 9
880   FIRST_NAME = Phil
881   LAST_NAME = Forest
882   PHONE_EXT = 229
883 < HIRE_DATE = 17/4/1989 00:00:00.000
883 > HIRE_DATE = 1989/04/17 00:00:00.0000
884   DEPT_NO = 622
885   JOB_CODE = Mngr
886   JOB_GRADE = 3
# Line 573 | Line 894 | EMP_NO = 8
894   FIRST_NAME = Leslie
895   LAST_NAME = Johnson
896   PHONE_EXT = 410
897 < HIRE_DATE = 31/1/2015 00:00:00.000
897 > HIRE_DATE = 2015/01/31 00:00:00.0000
898   DEPT_NO = 180
899   JOB_CODE = Mktg
900   JOB_GRADE = 3
# Line 583 | Line 904 | FULL_NAME = Johnson, Leslie
904  
905  
906  
907 + ------------------------------------------------------
908   Running Test 5: Update Returning and Activity Check
909   Opening inet://localhost/employee
910   Database Open
# Line 594 | Line 916 | EMP_NO = 8
916   FIRST_NAME = Leslie
917   LAST_NAME = Johnson
918   PHONE_EXT = 410
919 < HIRE_DATE = 31/1/2016 00:00:00.000
919 > HIRE_DATE = 2016/01/31 00:00:00.0000
920   DEPT_NO = 180
921   JOB_CODE = Mktg
922   JOB_GRADE = 3
# Line 616 | Line 938 | Transaction Active
938   Transaction inactive
939  
940  
941 + ------------------------------------------------------
942   Running Test 6: Blob Handling
943   Metadata
944   SQLType =SQL_TEXT
# Line 642 | Line 965 | Charset id = 0
965   Nullable
966   Size = 2
967  
968 < RDB$CHARACTER_SET_NAME = NONE (Charset Id = 4 Codepage = 65001 Byte Length = 31)
968 > RDB$CHARACTER_SET_NAME = NONE (Charset Id = 4 Codepage = 65001)
969   RDB$CHARACTER_SET_ID = 0
970 < RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 4 Codepage = 65001 Byte Length = 31)
970 > RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 4 Codepage = 65001)
971   RDB$CHARACTER_SET_ID = 1
972 < RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 4 Codepage = 65001 Byte Length = 31)
972 > RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 4 Codepage = 65001)
973   RDB$CHARACTER_SET_ID = 2
974 < RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 4 Codepage = 65001 Byte Length = 31)
974 > RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 4 Codepage = 65001)
975   RDB$CHARACTER_SET_ID = 3
976 < RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
976 > RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 4 Codepage = 65001)
977   RDB$CHARACTER_SET_ID = 4
978 < RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
978 > RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 4 Codepage = 65001)
979   RDB$CHARACTER_SET_ID = 5
980 < RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
980 > RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 4 Codepage = 65001)
981   RDB$CHARACTER_SET_ID = 6
982 < RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
982 > RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 4 Codepage = 65001)
983   RDB$CHARACTER_SET_ID = 9
984 < RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
984 > RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 4 Codepage = 65001)
985   RDB$CHARACTER_SET_ID = 10
986 < RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
986 > RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 4 Codepage = 65001)
987   RDB$CHARACTER_SET_ID = 11
988 < RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
988 > RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 4 Codepage = 65001)
989   RDB$CHARACTER_SET_ID = 12
990 < RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
990 > RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 4 Codepage = 65001)
991   RDB$CHARACTER_SET_ID = 13
992 < RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
992 > RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 4 Codepage = 65001)
993   RDB$CHARACTER_SET_ID = 14
994 < RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
994 > RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 4 Codepage = 65001)
995   RDB$CHARACTER_SET_ID = 15
996 < RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
996 > RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 4 Codepage = 65001)
997   RDB$CHARACTER_SET_ID = 16
998 < RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
998 > RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 4 Codepage = 65001)
999   RDB$CHARACTER_SET_ID = 17
1000 < RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1000 > RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 4 Codepage = 65001)
1001   RDB$CHARACTER_SET_ID = 18
1002 < RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1002 > RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 4 Codepage = 65001)
1003   RDB$CHARACTER_SET_ID = 19
1004 < RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1004 > RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 4 Codepage = 65001)
1005   RDB$CHARACTER_SET_ID = 21
1006 < RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1006 > RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 4 Codepage = 65001)
1007   RDB$CHARACTER_SET_ID = 22
1008 < RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1008 > RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 4 Codepage = 65001)
1009   RDB$CHARACTER_SET_ID = 23
1010 < RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1010 > RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 4 Codepage = 65001)
1011   RDB$CHARACTER_SET_ID = 34
1012 < RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1012 > RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 4 Codepage = 65001)
1013   RDB$CHARACTER_SET_ID = 35
1014 < RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1014 > RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 4 Codepage = 65001)
1015   RDB$CHARACTER_SET_ID = 36
1016 < RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1016 > RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 4 Codepage = 65001)
1017   RDB$CHARACTER_SET_ID = 37
1018 < RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1018 > RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 4 Codepage = 65001)
1019   RDB$CHARACTER_SET_ID = 38
1020 < RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1020 > RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 4 Codepage = 65001)
1021   RDB$CHARACTER_SET_ID = 39
1022 < RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1022 > RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 4 Codepage = 65001)
1023   RDB$CHARACTER_SET_ID = 40
1024 < RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1024 > RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 4 Codepage = 65001)
1025   RDB$CHARACTER_SET_ID = 44
1026 < RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1026 > RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 4 Codepage = 65001)
1027   RDB$CHARACTER_SET_ID = 45
1028 < RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1028 > RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 4 Codepage = 65001)
1029   RDB$CHARACTER_SET_ID = 46
1030 < RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1030 > RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 4 Codepage = 65001)
1031   RDB$CHARACTER_SET_ID = 47
1032 < RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1032 > RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 4 Codepage = 65001)
1033   RDB$CHARACTER_SET_ID = 48
1034 < RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1034 > RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 4 Codepage = 65001)
1035   RDB$CHARACTER_SET_ID = 49
1036 < RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1036 > RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 4 Codepage = 65001)
1037   RDB$CHARACTER_SET_ID = 50
1038 < RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1038 > RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 4 Codepage = 65001)
1039   RDB$CHARACTER_SET_ID = 51
1040 < RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1040 > RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 4 Codepage = 65001)
1041   RDB$CHARACTER_SET_ID = 52
1042 < RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1042 > RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 4 Codepage = 65001)
1043   RDB$CHARACTER_SET_ID = 53
1044 < RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1044 > RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 4 Codepage = 65001)
1045   RDB$CHARACTER_SET_ID = 54
1046 < RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1046 > RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 4 Codepage = 65001)
1047   RDB$CHARACTER_SET_ID = 55
1048 < RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1048 > RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 4 Codepage = 65001)
1049   RDB$CHARACTER_SET_ID = 56
1050 < RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1050 > RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 4 Codepage = 65001)
1051   RDB$CHARACTER_SET_ID = 57
1052 < RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1052 > RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 4 Codepage = 65001)
1053   RDB$CHARACTER_SET_ID = 58
1054 < RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1054 > RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 4 Codepage = 65001)
1055   RDB$CHARACTER_SET_ID = 59
1056 < RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1056 > RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 4 Codepage = 65001)
1057   RDB$CHARACTER_SET_ID = 60
1058 < RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1058 > RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 4 Codepage = 65001)
1059   RDB$CHARACTER_SET_ID = 63
1060 < RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1060 > RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 4 Codepage = 65001)
1061   RDB$CHARACTER_SET_ID = 64
1062 < RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1062 > RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 4 Codepage = 65001)
1063   RDB$CHARACTER_SET_ID = 65
1064 < RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1064 > RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 4 Codepage = 65001)
1065   RDB$CHARACTER_SET_ID = 66
1066 < RDB$CHARACTER_SET_NAME = GBK (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1066 > RDB$CHARACTER_SET_NAME = GBK (Charset Id = 4 Codepage = 65001)
1067   RDB$CHARACTER_SET_ID = 67
1068 < RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1068 > RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 4 Codepage = 65001)
1069   RDB$CHARACTER_SET_ID = 68
1070 < RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1070 > RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 4 Codepage = 65001)
1071   RDB$CHARACTER_SET_ID = 69
1072  
1073   Metadata
# Line 824 | Line 1147 | Scale = 0
1147   Charset id = 0
1148   Not Null
1149   Size = 4
1150 + Value = 0
1151  
1152   SQLType =SQL_VARYING
1153   sub type = 0
# Line 852 | Line 1176 | Size = 8
1176   ROWID = 1
1177   FIXEDPOINT = 20.28
1178   FLOATINGPOINT = 3.14
1179 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
1179 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1180   BLOBDATA = NULL
1181  
1182   SQL Params
# Line 871 | Line 1195 | Scale = 0
1195   Charset id = 0
1196   Not Null
1197   Size = 4
1198 + Value = 0
1199  
1200   ROWID = 1
1201   FIXEDPOINT = 20.28
1202   FLOATINGPOINT = 3.14
1203 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
1203 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1204   BLOBDATA (Charset Id = 4 Codepage = 65001)
1205  
1206   To be or not to be-that is the question:
# Line 923 | Line 1248 | Scale = 0
1248   Charset id = 0
1249   Not Null
1250   Size = 4
1251 + Value = 0
1252  
1253   SQLType =SQL_VARYING
1254   sub type = 0
# Line 951 | Line 1277 | Size = 8
1277   ROWID = 1
1278   FIXEDPOINT = 20.28
1279   FLOATINGPOINT = 3.14
1280 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
1280 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1281   BLOBDATA (Charset Id = 4 Codepage = 65001)
1282  
1283   To be or not to be-that is the question:
# Line 993 | Line 1319 | Be all my sins remembered
1319   ROWID = 2
1320   FIXEDPOINT = NULL
1321   FLOATINGPOINT = NULL
1322 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
1322 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1323   BLOBDATA (Charset Id = 4 Codepage = 65001)
1324  
1325   To be or not to be-that is the question:
# Line 1118 | Line 1444 | Charset id = 0
1444   Nullable
1445   Size = 2
1446  
1447 < RDB$CHARACTER_SET_NAME = NONE (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1447 > RDB$CHARACTER_SET_NAME = NONE (Charset Id = 53 Codepage = 1252)
1448   RDB$CHARACTER_SET_ID = 0
1449 < RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1449 > RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 53 Codepage = 1252)
1450   RDB$CHARACTER_SET_ID = 1
1451 < RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1451 > RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 53 Codepage = 1252)
1452   RDB$CHARACTER_SET_ID = 2
1453 < RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1453 > RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 53 Codepage = 1252)
1454   RDB$CHARACTER_SET_ID = 3
1455 < RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1455 > RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 53 Codepage = 1252)
1456   RDB$CHARACTER_SET_ID = 4
1457 < RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1457 > RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 53 Codepage = 1252)
1458   RDB$CHARACTER_SET_ID = 5
1459 < RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1459 > RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 53 Codepage = 1252)
1460   RDB$CHARACTER_SET_ID = 6
1461 < RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1461 > RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 53 Codepage = 1252)
1462   RDB$CHARACTER_SET_ID = 9
1463 < RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1463 > RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 53 Codepage = 1252)
1464   RDB$CHARACTER_SET_ID = 10
1465 < RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1465 > RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 53 Codepage = 1252)
1466   RDB$CHARACTER_SET_ID = 11
1467 < RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1467 > RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 53 Codepage = 1252)
1468   RDB$CHARACTER_SET_ID = 12
1469 < RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1469 > RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 53 Codepage = 1252)
1470   RDB$CHARACTER_SET_ID = 13
1471 < RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1471 > RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 53 Codepage = 1252)
1472   RDB$CHARACTER_SET_ID = 14
1473 < RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1473 > RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 53 Codepage = 1252)
1474   RDB$CHARACTER_SET_ID = 15
1475 < RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1475 > RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 53 Codepage = 1252)
1476   RDB$CHARACTER_SET_ID = 16
1477 < RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1477 > RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 53 Codepage = 1252)
1478   RDB$CHARACTER_SET_ID = 17
1479 < RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1479 > RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 53 Codepage = 1252)
1480   RDB$CHARACTER_SET_ID = 18
1481 < RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1481 > RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 53 Codepage = 1252)
1482   RDB$CHARACTER_SET_ID = 19
1483 < RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1483 > RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 53 Codepage = 1252)
1484   RDB$CHARACTER_SET_ID = 21
1485 < RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1485 > RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 53 Codepage = 1252)
1486   RDB$CHARACTER_SET_ID = 22
1487 < RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1487 > RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 53 Codepage = 1252)
1488   RDB$CHARACTER_SET_ID = 23
1489 < RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1489 > RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 53 Codepage = 1252)
1490   RDB$CHARACTER_SET_ID = 34
1491 < RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1491 > RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 53 Codepage = 1252)
1492   RDB$CHARACTER_SET_ID = 35
1493 < RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1493 > RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 53 Codepage = 1252)
1494   RDB$CHARACTER_SET_ID = 36
1495 < RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1495 > RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 53 Codepage = 1252)
1496   RDB$CHARACTER_SET_ID = 37
1497 < RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1497 > RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 53 Codepage = 1252)
1498   RDB$CHARACTER_SET_ID = 38
1499 < RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1499 > RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 53 Codepage = 1252)
1500   RDB$CHARACTER_SET_ID = 39
1501 < RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1501 > RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 53 Codepage = 1252)
1502   RDB$CHARACTER_SET_ID = 40
1503 < RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1503 > RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 53 Codepage = 1252)
1504   RDB$CHARACTER_SET_ID = 44
1505 < RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1505 > RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 53 Codepage = 1252)
1506   RDB$CHARACTER_SET_ID = 45
1507 < RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1507 > RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 53 Codepage = 1252)
1508   RDB$CHARACTER_SET_ID = 46
1509 < RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1509 > RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 53 Codepage = 1252)
1510   RDB$CHARACTER_SET_ID = 47
1511 < RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1511 > RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 53 Codepage = 1252)
1512   RDB$CHARACTER_SET_ID = 48
1513 < RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1513 > RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 53 Codepage = 1252)
1514   RDB$CHARACTER_SET_ID = 49
1515 < RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1515 > RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 53 Codepage = 1252)
1516   RDB$CHARACTER_SET_ID = 50
1517 < RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1517 > RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 53 Codepage = 1252)
1518   RDB$CHARACTER_SET_ID = 51
1519 < RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1519 > RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 53 Codepage = 1252)
1520   RDB$CHARACTER_SET_ID = 52
1521 < RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1521 > RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 53 Codepage = 1252)
1522   RDB$CHARACTER_SET_ID = 53
1523 < RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1523 > RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 53 Codepage = 1252)
1524   RDB$CHARACTER_SET_ID = 54
1525 < RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1525 > RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 53 Codepage = 1252)
1526   RDB$CHARACTER_SET_ID = 55
1527 < RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1527 > RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 53 Codepage = 1252)
1528   RDB$CHARACTER_SET_ID = 56
1529 < RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1529 > RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 53 Codepage = 1252)
1530   RDB$CHARACTER_SET_ID = 57
1531 < RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1531 > RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 53 Codepage = 1252)
1532   RDB$CHARACTER_SET_ID = 58
1533 < RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1533 > RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 53 Codepage = 1252)
1534   RDB$CHARACTER_SET_ID = 59
1535 < RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1535 > RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 53 Codepage = 1252)
1536   RDB$CHARACTER_SET_ID = 60
1537 < RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1537 > RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 53 Codepage = 1252)
1538   RDB$CHARACTER_SET_ID = 63
1539 < RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1539 > RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 53 Codepage = 1252)
1540   RDB$CHARACTER_SET_ID = 64
1541 < RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1541 > RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 53 Codepage = 1252)
1542   RDB$CHARACTER_SET_ID = 65
1543 < RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1543 > RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 53 Codepage = 1252)
1544   RDB$CHARACTER_SET_ID = 66
1545 < RDB$CHARACTER_SET_NAME = GBK (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1545 > RDB$CHARACTER_SET_NAME = GBK (Charset Id = 53 Codepage = 1252)
1546   RDB$CHARACTER_SET_ID = 67
1547 < RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1547 > RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 53 Codepage = 1252)
1548   RDB$CHARACTER_SET_ID = 68
1549 < RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1549 > RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 53 Codepage = 1252)
1550   RDB$CHARACTER_SET_ID = 69
1551  
1552   Metadata
# Line 1300 | Line 1626 | Scale = 0
1626   Charset id = 0
1627   Not Null
1628   Size = 4
1629 + Value = 0
1630  
1631   SQLType =SQL_VARYING
1632   sub type = 0
# Line 1328 | Line 1655 | Size = 8
1655   ROWID = 1
1656   FIXEDPOINT = 20.28
1657   FLOATINGPOINT = 3.14
1658 < TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15)
1658 > TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1659   BLOBDATA = NULL
1660  
1661   SQL Params
# Line 1347 | Line 1674 | Scale = 0
1674   Charset id = 0
1675   Not Null
1676   Size = 4
1677 + Value = 0
1678  
1679   ROWID = 1
1680   FIXEDPOINT = 20.28
1681   FLOATINGPOINT = 3.14
1682 < TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15)
1682 > TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1683   BLOBDATA (Charset Id = 53 Codepage = 1252)
1684  
1685   To be or not to be-that is the question:
# Line 1399 | Line 1727 | Scale = 0
1727   Charset id = 0
1728   Not Null
1729   Size = 4
1730 + Value = 0
1731  
1732   SQLType =SQL_VARYING
1733   sub type = 0
# Line 1427 | Line 1756 | Size = 8
1756   ROWID = 1
1757   FIXEDPOINT = 20.28
1758   FLOATINGPOINT = 3.14
1759 < TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15)
1759 > TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1760   BLOBDATA (Charset Id = 53 Codepage = 1252)
1761  
1762   To be or not to be-that is the question:
# Line 1469 | Line 1798 | Be all my sins remembered
1798   ROWID = 2
1799   FIXEDPOINT = NULL
1800   FLOATINGPOINT = NULL
1801 < TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15)
1801 > TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1802   BLOBDATA (Charset Id = 53 Codepage = 1252)
1803  
1804   To be or not to be-that is the question:
# Line 1594 | Line 1923 | Charset id = 0
1923   Nullable
1924   Size = 2
1925  
1926 < RDB$CHARACTER_SET_NAME = NONE (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1926 > RDB$CHARACTER_SET_NAME = NONE (Charset Id = 3 Codepage = 65001)
1927   RDB$CHARACTER_SET_ID = 0
1928 < RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1928 > RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 3 Codepage = 65001)
1929   RDB$CHARACTER_SET_ID = 1
1930 < RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1930 > RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 3 Codepage = 65001)
1931   RDB$CHARACTER_SET_ID = 2
1932 < RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1932 > RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 3 Codepage = 65001)
1933   RDB$CHARACTER_SET_ID = 3
1934 < RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1934 > RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 3 Codepage = 65001)
1935   RDB$CHARACTER_SET_ID = 4
1936 < RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1936 > RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 3 Codepage = 65001)
1937   RDB$CHARACTER_SET_ID = 5
1938 < RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1938 > RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 3 Codepage = 65001)
1939   RDB$CHARACTER_SET_ID = 6
1940 < RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1940 > RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 3 Codepage = 65001)
1941   RDB$CHARACTER_SET_ID = 9
1942 < RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1942 > RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 3 Codepage = 65001)
1943   RDB$CHARACTER_SET_ID = 10
1944 < RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1944 > RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 3 Codepage = 65001)
1945   RDB$CHARACTER_SET_ID = 11
1946 < RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1946 > RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 3 Codepage = 65001)
1947   RDB$CHARACTER_SET_ID = 12
1948 < RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1948 > RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 3 Codepage = 65001)
1949   RDB$CHARACTER_SET_ID = 13
1950 < RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1950 > RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 3 Codepage = 65001)
1951   RDB$CHARACTER_SET_ID = 14
1952 < RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1952 > RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 3 Codepage = 65001)
1953   RDB$CHARACTER_SET_ID = 15
1954 < RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1954 > RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 3 Codepage = 65001)
1955   RDB$CHARACTER_SET_ID = 16
1956 < RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1956 > RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 3 Codepage = 65001)
1957   RDB$CHARACTER_SET_ID = 17
1958 < RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1958 > RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 3 Codepage = 65001)
1959   RDB$CHARACTER_SET_ID = 18
1960 < RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1960 > RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 3 Codepage = 65001)
1961   RDB$CHARACTER_SET_ID = 19
1962 < RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1962 > RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 3 Codepage = 65001)
1963   RDB$CHARACTER_SET_ID = 21
1964 < RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1964 > RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 3 Codepage = 65001)
1965   RDB$CHARACTER_SET_ID = 22
1966 < RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1966 > RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 3 Codepage = 65001)
1967   RDB$CHARACTER_SET_ID = 23
1968 < RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1968 > RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 3 Codepage = 65001)
1969   RDB$CHARACTER_SET_ID = 34
1970 < RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1970 > RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 3 Codepage = 65001)
1971   RDB$CHARACTER_SET_ID = 35
1972 < RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1972 > RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 3 Codepage = 65001)
1973   RDB$CHARACTER_SET_ID = 36
1974 < RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1974 > RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 3 Codepage = 65001)
1975   RDB$CHARACTER_SET_ID = 37
1976 < RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1976 > RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 3 Codepage = 65001)
1977   RDB$CHARACTER_SET_ID = 38
1978 < RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1978 > RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 3 Codepage = 65001)
1979   RDB$CHARACTER_SET_ID = 39
1980 < RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1980 > RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 3 Codepage = 65001)
1981   RDB$CHARACTER_SET_ID = 40
1982 < RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1982 > RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 3 Codepage = 65001)
1983   RDB$CHARACTER_SET_ID = 44
1984 < RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1984 > RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 3 Codepage = 65001)
1985   RDB$CHARACTER_SET_ID = 45
1986 < RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1986 > RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 3 Codepage = 65001)
1987   RDB$CHARACTER_SET_ID = 46
1988 < RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1988 > RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 3 Codepage = 65001)
1989   RDB$CHARACTER_SET_ID = 47
1990 < RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1990 > RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 3 Codepage = 65001)
1991   RDB$CHARACTER_SET_ID = 48
1992 < RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1992 > RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 3 Codepage = 65001)
1993   RDB$CHARACTER_SET_ID = 49
1994 < RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1994 > RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 3 Codepage = 65001)
1995   RDB$CHARACTER_SET_ID = 50
1996 < RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1996 > RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 3 Codepage = 65001)
1997   RDB$CHARACTER_SET_ID = 51
1998 < RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1998 > RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 3 Codepage = 65001)
1999   RDB$CHARACTER_SET_ID = 52
2000 < RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2000 > RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 3 Codepage = 65001)
2001   RDB$CHARACTER_SET_ID = 53
2002 < RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2002 > RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 3 Codepage = 65001)
2003   RDB$CHARACTER_SET_ID = 54
2004 < RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2004 > RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 3 Codepage = 65001)
2005   RDB$CHARACTER_SET_ID = 55
2006 < RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2006 > RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 3 Codepage = 65001)
2007   RDB$CHARACTER_SET_ID = 56
2008 < RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2008 > RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 3 Codepage = 65001)
2009   RDB$CHARACTER_SET_ID = 57
2010 < RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2010 > RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 3 Codepage = 65001)
2011   RDB$CHARACTER_SET_ID = 58
2012 < RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2012 > RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 3 Codepage = 65001)
2013   RDB$CHARACTER_SET_ID = 59
2014 < RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2014 > RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 3 Codepage = 65001)
2015   RDB$CHARACTER_SET_ID = 60
2016 < RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2016 > RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 3 Codepage = 65001)
2017   RDB$CHARACTER_SET_ID = 63
2018 < RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2018 > RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 3 Codepage = 65001)
2019   RDB$CHARACTER_SET_ID = 64
2020 < RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2020 > RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 3 Codepage = 65001)
2021   RDB$CHARACTER_SET_ID = 65
2022 < RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2022 > RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 3 Codepage = 65001)
2023   RDB$CHARACTER_SET_ID = 66
2024 < RDB$CHARACTER_SET_NAME = GBK (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2024 > RDB$CHARACTER_SET_NAME = GBK (Charset Id = 3 Codepage = 65001)
2025   RDB$CHARACTER_SET_ID = 67
2026 < RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2026 > RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 3 Codepage = 65001)
2027   RDB$CHARACTER_SET_ID = 68
2028 < RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2028 > RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 3 Codepage = 65001)
2029   RDB$CHARACTER_SET_ID = 69
2030  
2031   Metadata
# Line 1776 | Line 2105 | Scale = 0
2105   Charset id = 0
2106   Not Null
2107   Size = 4
2108 + Value = 0
2109  
2110   SQLType =SQL_VARYING
2111   sub type = 0
# Line 1804 | Line 2134 | Size = 8
2134   ROWID = 1
2135   FIXEDPOINT = 20.28
2136   FLOATINGPOINT = 3.14
2137 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2137 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2138   BLOBDATA = NULL
2139  
2140   SQL Params
# Line 1823 | Line 2153 | Scale = 0
2153   Charset id = 0
2154   Not Null
2155   Size = 4
2156 + Value = 0
2157  
2158   ROWID = 1
2159   FIXEDPOINT = 20.28
2160   FLOATINGPOINT = 3.14
2161 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2161 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2162   BLOBDATA (Charset Id = 4 Codepage = 65001)
2163  
2164   To be or not to be-that is the question:
# Line 1875 | Line 2206 | Scale = 0
2206   Charset id = 0
2207   Not Null
2208   Size = 4
2209 + Value = 0
2210  
2211   SQLType =SQL_VARYING
2212   sub type = 0
# Line 1903 | Line 2235 | Size = 8
2235   ROWID = 1
2236   FIXEDPOINT = 20.28
2237   FLOATINGPOINT = 3.14
2238 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2238 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2239   BLOBDATA (Charset Id = 4 Codepage = 65001)
2240  
2241   To be or not to be-that is the question:
# Line 1945 | Line 2277 | Be all my sins remembered
2277   ROWID = 2
2278   FIXEDPOINT = NULL
2279   FLOATINGPOINT = NULL
2280 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2280 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2281   BLOBDATA (Charset Id = 4 Codepage = 65001)
2282  
2283   To be or not to be-that is the question:
# Line 2047 | Line 2379 | Be all my sins remembered
2379  
2380  
2381  
2382 + ------------------------------------------------------
2383   Running Test 7: Create and read back an Array
2384   Metadata
2385   SQLType =SQL_LONG
# Line 2118 | Line 2451 | Column = MYARRAY
2451   Dimensions = 1
2452   Bounds: (0:16)
2453  
2454 + SQLType =SQL_ARRAY
2455 + sub type = 0
2456 + Table = TESTDATA
2457 + Owner = SYSDBA
2458 + Column Name = MYARRAY2
2459 + Alias Name = MYARRAY2
2460 + Field Name = MYARRAY2
2461 + Scale = 0
2462 + Charset id = 0
2463 + Nullable
2464 + Size = 8
2465 + Array Meta Data:
2466 + SQLType =SQL_TIMESTAMP
2467 + Scale = 0
2468 + Charset id = 0
2469 + Size = 8
2470 + Table = TESTDATA
2471 + Column = MYARRAY2
2472 + Dimensions = 1
2473 + Bounds: (0:16)
2474 +
2475 + SQLType =SQL_ARRAY
2476 + sub type = 0
2477 + Table = TESTDATA
2478 + Owner = SYSDBA
2479 + Column Name = MYARRAY3
2480 + Alias Name = MYARRAY3
2481 + Field Name = MYARRAY3
2482 + Scale = 0
2483 + Charset id = 0
2484 + Nullable
2485 + Size = 8
2486 + Array Meta Data:
2487 + SQLType =SQL_INT64
2488 + Scale = -2
2489 + Charset id = 0
2490 + Size = 8
2491 + Table = TESTDATA
2492 + Column = MYARRAY3
2493 + Dimensions = 1
2494 + Bounds: (0:16)
2495 +
2496   SQL Params
2497   SQLType =SQL_LONG
2498   sub type = 0
# Line 2126 | Line 2501 | Scale = 0
2501   Charset id = 0
2502   Not Null
2503   Size = 4
2504 + Value = 0
2505  
2506   SQLType =SQL_VARYING
2507   sub type = 0
# Line 2156 | Line 2532 | Param Name = TITLE
2532   Param Name = DATED
2533   Param Name = NOTES
2534   ROWID = 1
2535 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2536 < DATED = 1/4/2016 09:30:00.100
2537 < NOTES = Écoute moi (Charset Id = 4 Codepage = 65001 Byte Length = 11)
2535 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2536 > DATED = 2016/04/01 09:30:00.1000
2537 > NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
2538   MYARRAY = NULL
2539 + MYARRAY2 = NULL
2540 + MYARRAY3 = NULL
2541  
2542   SQL Params
2543   SQLType =SQL_ARRAY
# Line 2170 | Line 2548 | Charset id = 0
2548   Nullable
2549   Size = 8
2550  
2551 + SQL Params
2552 + SQLType =SQL_ARRAY
2553 + sub type = 0
2554 + Field Name = MYARRAY2
2555 + Scale = 0
2556 + Charset id = 0
2557 + Nullable
2558 + Size = 8
2559 +
2560 + SQL Params
2561 + SQLType =SQL_ARRAY
2562 + sub type = 0
2563 + Field Name = MYARRAY3
2564 + Scale = 0
2565 + Charset id = 0
2566 + Nullable
2567 + Size = 8
2568 +
2569 + Metadata
2570 + SQLType =SQL_LONG
2571 + sub type = 0
2572 + Table = TESTDATA
2573 + Owner = SYSDBA
2574 + Column Name = ROWID
2575 + Alias Name = ROWID
2576 + Field Name = ROWID
2577 + Scale = 0
2578 + Charset id = 0
2579 + Not Null
2580 + Size = 4
2581 +
2582 + SQLType =SQL_VARYING
2583 + sub type = 0
2584 + Table = TESTDATA
2585 + Owner = SYSDBA
2586 + Column Name = TITLE
2587 + Alias Name = TITLE
2588 + Field Name = TITLE
2589 + Scale = 0
2590 + Charset id = 4
2591 + Nullable
2592 + Size = 128
2593 +
2594 + SQLType =SQL_TIMESTAMP
2595 + sub type = 0
2596 + Table = TESTDATA
2597 + Owner = SYSDBA
2598 + Column Name = DATED
2599 + Alias Name = DATED
2600 + Field Name = DATED
2601 + Scale = 0
2602 + Charset id = 0
2603 + Nullable
2604 + Size = 8
2605 +
2606 + SQLType =SQL_VARYING
2607 + sub type = 0
2608 + Table = TESTDATA
2609 + Owner = SYSDBA
2610 + Column Name = NOTES
2611 + Alias Name = NOTES
2612 + Field Name = NOTES
2613 + Scale = 0
2614 + Charset id = 4
2615 + Nullable
2616 + Size = 256
2617 +
2618 + SQLType =SQL_ARRAY
2619 + sub type = 0
2620 + Table = TESTDATA
2621 + Owner = SYSDBA
2622 + Column Name = MYARRAY
2623 + Alias Name = MYARRAY
2624 + Field Name = MYARRAY
2625 + Scale = 0
2626 + Charset id = 0
2627 + Nullable
2628 + Size = 8
2629 + Array Meta Data:
2630 + SQLType =SQL_LONG
2631 + Scale = 0
2632 + Charset id = 0
2633 + Size = 4
2634 + Table = TESTDATA
2635 + Column = MYARRAY
2636 + Dimensions = 1
2637 + Bounds: (0:16)
2638 +
2639 + SQLType =SQL_ARRAY
2640 + sub type = 0
2641 + Table = TESTDATA
2642 + Owner = SYSDBA
2643 + Column Name = MYARRAY2
2644 + Alias Name = MYARRAY2
2645 + Field Name = MYARRAY2
2646 + Scale = 0
2647 + Charset id = 0
2648 + Nullable
2649 + Size = 8
2650 + Array Meta Data:
2651 + SQLType =SQL_TIMESTAMP
2652 + Scale = 0
2653 + Charset id = 0
2654 + Size = 8
2655 + Table = TESTDATA
2656 + Column = MYARRAY2
2657 + Dimensions = 1
2658 + Bounds: (0:16)
2659 +
2660 + SQLType =SQL_ARRAY
2661 + sub type = 0
2662 + Table = TESTDATA
2663 + Owner = SYSDBA
2664 + Column Name = MYARRAY3
2665 + Alias Name = MYARRAY3
2666 + Field Name = MYARRAY3
2667 + Scale = 0
2668 + Charset id = 0
2669 + Nullable
2670 + Size = 8
2671 + Array Meta Data:
2672 + SQLType =SQL_INT64
2673 + Scale = -2
2674 + Charset id = 0
2675 + Size = 8
2676 + Table = TESTDATA
2677 + Column = MYARRAY3
2678 + Dimensions = 1
2679 + Bounds: (0:16)
2680 +
2681   ROWID = 1
2682 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2683 < DATED = 1/4/2016 09:30:00.100
2684 < NOTES = Écoute moi (Charset Id = 4 Codepage = 65001 Byte Length = 11)
2685 < 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)
2682 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2683 > DATED = 2016/04/01 09:30:00.1000
2684 > NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
2685 > 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)
2686 >
2687 > 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)
2688 >
2689 > 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: 14.69) (15: 15.75) (16: 16.79)
2690 >
2691  
2692   Shrink to 2:10
2693   Array: (2: 98) (3: 97) (4: 96) (5: 95) (6: 94) (7: 93) (8: 92) (9: 91) (10: 90)
2694 +
2695   Write updated reduced slice
2696   Show update array
2697   ROWID = 1
2698 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2699 < DATED = 1/4/2016 09:30:00.100
2700 < NOTES = Écoute moi (Charset Id = 4 Codepage = 65001 Byte Length = 11)
2701 < 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)
2698 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2699 > DATED = 2016/04/01 09:30:00.1000
2700 > NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
2701 > 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)
2702 >
2703 > 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)
2704  
2705 + 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: 14.69) (15: 15.75) (16: 16.79)
2706  
2707  
2708 +
2709 +
2710 + ------------------------------------------------------
2711   Running Test 8: Create and read back an Array with 2 dimensions
2712   Metadata
2713   SQLType =SQL_LONG
# Line 2243 | Line 2763 | Scale = 0
2763   Charset id = 0
2764   Not Null
2765   Size = 4
2766 + Value = 0
2767  
2768   SQLType =SQL_VARYING
2769   sub type = 0
# Line 2253 | Line 2774 | Nullable
2774   Size = 128
2775  
2776   ROWID = 1
2777 < TITLE = 2D Array (Charset Id = 4 Codepage = 65001 Byte Length = 8)
2777 > TITLE = 2D Array (Charset Id = 4 Codepage = 65001)
2778   MYARRAY = NULL
2779  
2780   ROWID = 1
2781 < TITLE = 2D Array (Charset Id = 4 Codepage = 65001 Byte Length = 8)
2782 < 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)
2781 > TITLE = 2D Array (Charset Id = 4 Codepage = 65001)
2782 > 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)
2783  
2784  
2785  
2786 +
2787 + ------------------------------------------------------
2788   Running Test 9: Database Information tests
2789   Database ID = 4 FB = /opt/firebird3.0.5/examples/empbuild/employee.fdb SN = zeus
2790   Pages =307
# Line 2273 | Line 2796 | ODS major = 12
2796   Page Size = 8192
2797   Version = 1: LI-V6.3.5.33220 Firebird 3.0
2798   Database is Read/Write
2799 < Database Created: 9/1/2020 13:13:45
2799 > Database Created: 09/1/2020 13:13:45
2800   Pages Used = 297
2801   Pages Free = 10
2802 < Server Memory = 19195648
2802 > Server Memory = 19196128
2803   Forced Writes  = 1
2804 < Max Memory  = 19316160
2804 > Max Memory  = 19316896
2805   Num Buffers  = 2048
2806   Sweep Interval  = 20000
2807   Logged in Users: SYSDBA,
# Line 2324 | Line 2847 | Update Count Operation Counts
2847   Page Size = 8192
2848  
2849  
2850 + ------------------------------------------------------
2851   Running Test 10: Event Handling
2852   Call Async Wait
2853   Async Wait Called
# Line 2350 | Line 2874 | Event Signalled
2874   Event Counts: TESTEVENT, Count = 1
2875  
2876  
2877 + ------------------------------------------------------
2878   Running Test 11: Services API
2879 + SPB: Item Count = 2
2880 +  user_name = SYSDBA
2881 +  password = masterkey
2882 +
2883   Service Manager Version = 2
2884   Server Version = LI-V3.0.5.33220 Firebird 3.0
2885   Implementation = Firebird/Linux/AMD/Intel/x64
# Line 2372 | Line 2901 | User ID = 0
2901   Group ID = 0
2902  
2903  
2904 < Licence Info:
2376 < feature is not supported
2904 > Licence Info: feature is not supported
2905   -feature is not supported
2906  
2907 < Licence Mask Info:
2380 < feature is not supported
2907 > Licence Mask Info: feature is not supported
2908  
2909   Capabilities = 6
2910  
# Line 2407 | Line 2934 | Database OK
2934   Database Dropped
2935  
2936  
2937 + ------------------------------------------------------
2938   Running Test 12: Character Sets
2939   SQL Params
2940   SQLType =SQL_LONG
# Line 2416 | Line 2944 | Scale = 0
2944   Charset id = 0
2945   Not Null
2946   Size = 4
2947 + Value = 0
2948  
2949   SQLType =SQL_VARYING
2950   sub type = 0
# Line 2465 | Line 2994 | Charset id = 4
2994   Nullable
2995   Size = 16
2996  
2997 + Show Param Values
2998 + SQL Params
2999 + SQLType =SQL_LONG
3000 + sub type = 0
3001 + Field Name = ROWID
3002 + Scale = 0
3003 + Charset id = 0
3004 + Not Null
3005 + Size = 4
3006 + Value = 1
3007 +
3008 + SQLType =SQL_VARYING
3009 + sub type = 0
3010 + Field Name = TITLE
3011 + Scale = 0
3012 + Charset id = 4
3013 + Nullable
3014 + Size = 128
3015 + Value = Blob Test ©€
3016 +
3017 + SQLType =SQL_VARYING
3018 + sub type = 0
3019 + Field Name = NOTES
3020 + Scale = 0
3021 + Charset id = 4
3022 + Nullable
3023 + Size = 256
3024 + Value = Écoute moi
3025 +
3026 + SQLType =SQL_VARYING
3027 + sub type = 1
3028 + Field Name = BLOBDATA
3029 + Scale = 0
3030 + Charset id = 4
3031 + Nullable
3032 + Size = 8192
3033 + Value = Some German Special Characters like ÖÄÜöäüß
3034 +
3035 + SQLType =SQL_BLOB
3036 + sub type = 1
3037 + Field Name = BLOBDATA2
3038 + Scale = 0
3039 + Charset id = 4
3040 + Nullable
3041 + Size = 8
3042 + Value = Some German Special Characters like ÖÄÜöäüß
3043 +
3044 + SQLType =SQL_VARYING
3045 + sub type = 0
3046 + Field Name = INCLEAR
3047 + Scale = 0
3048 + Charset id = 1
3049 + Nullable
3050 + Size = 16
3051 + Value = &Test
3052  
3053 +
3054 + SQLType =SQL_VARYING
3055 + sub type = 0
3056 + Field Name = FIXEDWIDTH
3057 + Scale = 0
3058 + Charset id = 4
3059 + Nullable
3060 + Size = 16
3061 + Value = É
3062 +
3063   Connection Character Set UTF8
3064   ROWID = 1
3065 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001 Byte Length = 15)
3066 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
3065 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
3066 > NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
3067   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)
3068   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)
3069 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3070 < FIXEDWIDTH = C3 89  (Charset Id = 4 Codepage = 65001 Byte Length = 5)
3069 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3070 > FIXEDWIDTH = C3 89  (Charset Id = 4 Codepage = 65001)
3071  
3072   Connection Character Set NONE
3073   ROWID = 1
3074 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001 Byte Length = 15)
3075 < NOTES = C9 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 21 Codepage = 28591 Byte Length = 10)
3074 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
3075 > NOTES = C9 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 21 Codepage = 28591)
3076   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)
3077   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)
3078 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3079 < FIXEDWIDTH = C3 89  (Charset Id = 4 Codepage = 65001 Byte Length = 5)
3078 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3079 > FIXEDWIDTH = C3 89  (Charset Id = 4 Codepage = 65001)
3080  
3081   Connection Character Set WIN1252
3082   ROWID = 1
3083 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 A9 80  (Charset Id = 53 Codepage = 1252 Byte Length = 12)
3084 < NOTES = C9 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 53 Codepage = 1252 Byte Length = 10)
3083 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 A9 80  (Charset Id = 53 Codepage = 1252)
3084 > NOTES = C9 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 53 Codepage = 1252)
3085   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)
3086   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)
3087 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3088 < FIXEDWIDTH = C9  (Charset Id = 53 Codepage = 1252 Byte Length = 4)
3087 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3088 > FIXEDWIDTH = C9  (Charset Id = 53 Codepage = 1252)
3089  
3090  
3091  
3092 + ------------------------------------------------------
3093   Running Test 13: Transaction over two databases
3094   Init Database 1
3095   ROWID = 1
3096 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001 Byte Length = 15)
3097 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
3096 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
3097 > NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
3098   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)
3099   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)
3100 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3100 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3101  
3102   Init Database 2
3103   ROWID = 1
3104 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001 Byte Length = 15)
3105 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
3104 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
3105 > NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
3106   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)
3107   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)
3108 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3108 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3109  
3110   ROWID = 1
3111 < TITLE = 44 61 74 61 62 61 73 65 31  (Charset Id = 4 Codepage = 65001 Byte Length = 9)
3112 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
3111 > TITLE = 44 61 74 61 62 61 73 65 31  (Charset Id = 4 Codepage = 65001)
3112 > NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
3113   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)
3114   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)
3115 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3115 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3116  
3117   ROWID = 1
3118 < TITLE = 44 61 74 61 62 61 73 65 32  (Charset Id = 4 Codepage = 65001 Byte Length = 9)
3119 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
3118 > TITLE = 44 61 74 61 62 61 73 65 32  (Charset Id = 4 Codepage = 65001)
3119 > NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
3120   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)
3121   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)
3122 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3122 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3123  
3124  
3125  
3126 + ------------------------------------------------------
3127   Running Test 14: Non select procedures
3128   Default Character set Name = UTF8
3129   Metadata
# Line 2555 | Line 3151 | Nullable
3151   Size = 128
3152  
3153   ROWID = 1
3154 < TITLE = Testing (Charset Id = 4 Codepage = 65001 Byte Length = 7)
3154 > TITLE = Testing (Charset Id = 4 Codepage = 65001)
3155  
3156   Repeat with a different execute transaction
3157  
3158   ROWID = 1
3159 < TITLE = Testing (Charset Id = 4 Codepage = 65001 Byte Length = 7)
3159 > TITLE = Testing (Charset Id = 4 Codepage = 65001)
3160  
3161   Repeat with a original transaction
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  
3167 + ------------------------------------------------------
3168   Running Test 15: Blob Handling and BPBs
3169  
3170   Testdata
3171  
3172   ROWID = 1
3173 < TITLE = Blob Test (Charset Id = 4 Codepage = 65001 Byte Length = 9)
3173 > TITLE = Blob Test (Charset Id = 4 Codepage = 65001)
3174   BLOBDATA = (blob), Length = 92514
3175  
3176 + ROWID = 2
3177 + TITLE = Blob Test with binary string (Charset Id = 4 Codepage = 65001)
3178 + BLOBDATA = (blob), Length = 13
3179 + 0 9 A C9 63 6F 75 74 65 20 6D 6F 69
3180  
3181   Testdata 2
3182  
3183   ROWID = 1
3184 < TITLE = Blob Test (Charset Id = 4 Codepage = 65001 Byte Length = 9)
3184 > TITLE = Blob Test (Charset Id = 4 Codepage = 65001)
3185   BLOBDATA (Charset Id = 4 Codepage = 65001)
3186  
3187   Écoute moi
3188  
3189  
3190  
3191 + ------------------------------------------------------
3192   Running Test 16: Error handling
3193   Invalid Database Name Test
3194 < Error Handled:
2593 < I/O error during "open" operation for file "Malformed Name"
3194 > Error Handled: I/O error during "open" operation for file "Malformed Name"
3195   -Error while trying to open file
3196   -No such file or directory
3197   Invalid User Name Test
3198 < Error Handled:
2598 < Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3198 > Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3199   Invalid password Test
3200 < Error Handled:
2601 < Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3200 > Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3201   Invalid Prepare SQL Test
3202 < Error Handled:
2604 < Dynamic SQL Error
3202 > Error Handled: Dynamic SQL Error
3203   -SQL error code = -206
3204   -Column unknown
3205   -UNKNOWN_DATE
3206   -At line 1, column 21 When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ?
3207   Invalid Open Cursor SQL Test
3208 < Error Handled:
2611 < Dynamic SQL Error
3208 > Error Handled: Dynamic SQL Error
3209   -SQL error code = -206
3210   -Column unknown
3211   -X
# Line 2619 | Line 3216 | Invalid Param SQL Type Test
3216   Error Handled: Field "EMP_NO" not found
3217   Case sensitive Param SQL  Test
3218   Error Handled: Field "EMP_NO" not found
3219 + Stale Reference Check
3220 + First test correct usage
3221 + COUNTER = 42
3222 +
3223 + New Transaction before param set
3224 + Error Handled: This interface is no longer up-to-date
3225 + New Transaction before Open Cursor
3226 + Error Handled: This interface is no longer up-to-date
3227 + Stop Stale Reference Checks
3228 + New Transaction before param set
3229 + COUNTER = 42
3230 +
3231 + New Transaction before Open Cursor
3232 + COUNTER = 42
3233 +
3234   Invalid Server Name Test
3235 < Error Handled:
2624 < Unable to complete network request to host "unknown".
3235 > Error Handled: Unable to complete network request to host "unknown".
3236   -Failed to locate host machine.
3237   -The specified name was not found in the hosts file or Domain Name Services
3238   Invalid User Name Test
3239 < Error Handled:
2629 < Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3239 > Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3240   Invalid password Test
3241 < Error Handled:
3242 < Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3241 > Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3242 >
3243 >
3244 > ------------------------------------------------------
3245 > Running Test 17: Date/Time tests and Firebird 4 extensions
3246 > FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.5.33220 Firebird 3.0"
3247 > Has Local TZ DB = FALSE
3248 >
3249 > Testdata
3250 >
3251 > Metadata
3252 > SQLType =SQL_LONG
3253 > sub type = 0
3254 > Table = TESTDATA
3255 > Owner = SYSDBA
3256 > Column Name = ROWID
3257 > Alias Name = ROWID
3258 > Field Name = ROWID
3259 > Scale = 0
3260 > Charset id = 0
3261 > Not Null
3262 > Size = 4
3263 >
3264 > SQLType =SQL_TYPE_DATE
3265 > sub type = 0
3266 > Table = TESTDATA
3267 > Owner = SYSDBA
3268 > Column Name = DATECOL
3269 > Alias Name = DATECOL
3270 > Field Name = DATECOL
3271 > Scale = 0
3272 > Charset id = 0
3273 > Nullable
3274 > Size = 4
3275 >
3276 > SQLType =SQL_TYPE_TIME
3277 > sub type = 0
3278 > Table = TESTDATA
3279 > Owner = SYSDBA
3280 > Column Name = TIMECOL
3281 > Alias Name = TIMECOL
3282 > Field Name = TIMECOL
3283 > Scale = 0
3284 > Charset id = 0
3285 > Nullable
3286 > Size = 4
3287 >
3288 > SQLType =SQL_TIMESTAMP
3289 > sub type = 0
3290 > Table = TESTDATA
3291 > Owner = SYSDBA
3292 > Column Name = TIMESTAMPCOL
3293 > Alias Name = TIMESTAMPCOL
3294 > Field Name = TIMESTAMPCOL
3295 > Scale = 0
3296 > Charset id = 0
3297 > Nullable
3298 > Size = 8
3299 >
3300 > ROWID = 1
3301 > DATECOL = 2019/04/01
3302 > TIMECOL = 11:31:05.0001
3303 > TIMESTAMPCOL = 2016/02/29 22:02:35.0001
3304 > ROWID = 2
3305 > DATECOL = 1939/09/03
3306 > TIMECOL = 15:40:00.0002
3307 > TIMESTAMPCOL = 1918/11/11 11:11:00.0000
3308 > ROWID = 3
3309 > DATECOL = 1066/10/14
3310 > TIMECOL = 23:59:59.9994
3311 > TIMESTAMPCOL = 1918/11/11 11:11:00.0000
3312 > ROWID = 4
3313 > DATECOL = 1815/06/18
3314 > TIMECOL = 00:01:40.1115
3315 > TIMESTAMPCOL = 1945/05/08 22:10:00.0010
3316 >
3317 >
3318 > Testdata - second pass
3319 >
3320 > 1, 01/4/2019, 11:31:05, 29/2/2016 22:02:35
3321 > 2, 03/9/1939, 15:40:00.000, 11/11/1918 11:11:00
3322 > 3, 14/10/1066, 23:59:59.999, 11/11/1918 11:11:00
3323 > 4, 18/6/1815, 00:01:40.112, 08/5/1945 22:10:00
3324 > Sys Time = 1945, 5, 8, 2, 22, 10, 0, 1
3325 > Skipping Firebird 4 and later test part
3326 >
3327 >
3328 > ------------------------------------------------------
3329 > Running Test 18: Firebird 4 Decfloat extensions
3330 > FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.5.33220 Firebird 3.0"
3331 > Skipping test for Firebird 4 and later
3332 >
3333 >
3334 > ------------------------------------------------------
3335 > Running Test 19: Batch Update and Insert Queries
3336 > Opening inet://localhost/employee
3337 > Skipping test for Firebird 4 and later
3338 >
3339 >
3340 > ------------------------------------------------------
3341 > Running Test 20: Stress Test IBatch interface
3342 > FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.5.33220 Firebird 3.0"
3343 > Skipping test for Firebird 4 and later
3344 >
3345 >
3346 > ------------------------------------------------------
3347 > Running Test 21: Exercise setting and getting of numeric data types
3348 > SQL Params
3349 > SQLType =SQL_LONG
3350 > sub type = 0
3351 > Field Name =
3352 > Scale = 0
3353 > Charset id = 0
3354 > Not Null
3355 > Size = 4
3356 > Value = 0
3357 >
3358 > SQLType =SQL_LONG
3359 > sub type = 0
3360 > Field Name =
3361 > Scale = 0
3362 > Charset id = 0
3363 > Nullable
3364 > Size = 4
3365 >
3366 > SQLType =SQL_INT64
3367 > sub type = 0
3368 > Field Name =
3369 > Scale = 0
3370 > Charset id = 0
3371 > Nullable
3372 > Size = 8
3373 >
3374 > SQLType =SQL_INT64
3375 > sub type = 0
3376 > Field Name =
3377 > Scale = -4
3378 > Charset id = 0
3379 > Nullable
3380 > Size = 8
3381 >
3382 > SQLType =SQL_DOUBLE
3383 > sub type = 0
3384 > Field Name =
3385 > Scale = 0
3386 > Charset id = 0
3387 > Nullable
3388 > Size = 8
3389 >
3390 > SQLType =SQL_INT64
3391 > sub type = 0
3392 > Field Name =
3393 > Scale = -6
3394 > Charset id = 0
3395 > Nullable
3396 > Size = 8
3397 >
3398 > Expected Error - Dynamic SQL Error
3399 > -SQL error code = -303
3400 > -conversion error from string "1,000"
3401 > Expected Error - Dynamic SQL Error
3402 > -SQL error code = -303
3403 > -conversion error from string "10.0.0"
3404 > ROWID = 1
3405 > ITYPE = 101
3406 > I64TYPE = 9223372036854775807
3407 > CURRTYPE = 10,000.12340000
3408 > DTYPE = 9,999.12345678
3409 > FIXEDPOINT = 1,234,567,890.12345700
3410 > ROWID = 2
3411 > ITYPE = -32457
3412 > I64TYPE = -9223372036854775808
3413 > CURRTYPE = 1,000,001.12000000
3414 > DTYPE = 1.7E308
3415 > FIXEDPOINT = -1,234,567,890.12345700
3416 > ROWID = 3
3417 > ITYPE = 0
3418 > I64TYPE = 0
3419 > CURRTYPE = .00000000
3420 > DTYPE = .00000000
3421 > FIXEDPOINT = .00000000
3422 > ROWID = 4
3423 > ITYPE = 1
3424 > I64TYPE = 10
3425 > CURRTYPE = .02300000
3426 > DTYPE = .00000000
3427 > FIXEDPOINT = 233.45600000
3428 >
3429  
3430  
3431 + ------------------------------------------------------
3432   Test Suite Ends

Diff Legend

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