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

Comparing:
ibx/trunk/fbintf/testsuite/FB2reference.log (file contents), Revision 333 by tony, Fri Feb 26 16:34:26 2021 UTC vs.
ibx/branches/udr/testsuite/FB2reference.log (file contents), Revision 371 by tony, Wed Jan 5 15:21:22 2022 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 = 2.5
6 + Firebird Environment Variable = /opt/firebird2.5.9
7 + Firebird Client Library Path = /opt/firebird2.5.9/lib/libfbembed.so
8   Running Test 1: Create and Drop a Database
9   Creating a Database with empty parameters
10 < Create Database fails (as expected):
9 < unavailable database
10 > Create Database fails (as expected): Engine Code: 335544344 I/O error during "open O_CREAT" operation for file ""
11   Creating a Database using an SQL Statement
12   Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus
13   SQL Dialect = 3
14 < DB Connect String = /tmp/fbintf-testsuite/testsuite1.fdb
14 > DB Connect String = localhost:/tmp/fbintf-testsuite/testsuite1.fdb
15   DB Charset ID = 0
16   DB SQL Dialect = 3
17   DB Remote Protocol = TCPv4
18   DB ODS Major Version = 11
19   DB ODS Minor Version = 2
20   User Authentication Method = Legacy_Auth
21 < Firebird Library Path = /opt/firebird2.5.9/lib/libfbclient.so
21 > Firebird Library Path = /opt/firebird2.5.9/lib/libfbembed.so
22   DB Client Implementation Version = 2.5
23 < DPB
24 < Count = 3
25 < 28 = SYSDBA
26 < 29 = masterkey
27 < 65 = 3
23 > DPB: Item Count = 3
24 >  isc_dpb_user_name = SYSDBA
25 >  isc_dpb_password = masterkey
26 >  isc_dpb_set_db_sql_dialect = 3
27 >
28 > Firebird Server Version Info
29 > Firebird/linux AMD64 (access method), version "LI-V2.5.9.27139 Firebird 2.5"
30 > Firebird/linux AMD64 (remote server), version "LI-V2.5.9.27139 Firebird 2.5/tcp (zeus)/P12"
31 > Firebird/linux AMD64 (remote interface), version "LI-V2.5.9.27139 Firebird 2.5/tcp (zeus)/P12"
32 > on disk structure version 11.2
33  
34   Dropping Database
35   Creating a Database with a DPD
36 < DB Connect String = /tmp/fbintf-testsuite/testsuite1.fdb
36 > DB Connect String = localhost:/tmp/fbintf-testsuite/testsuite1.fdb
37   DB Charset ID = 4
38   DB SQL Dialect = 3
39   DB Remote Protocol = TCPv4
40   DB ODS Major Version = 11
41   DB ODS Minor Version = 2
42   User Authentication Method = Legacy_Auth
43 < Firebird Library Path = /opt/firebird2.5.9/lib/libfbclient.so
43 > Firebird Library Path = /opt/firebird2.5.9/lib/libfbembed.so
44   DB Client Implementation Version = 2.5
45   Dropping Database
46 < DPB
47 < Count = 4
48 < 28 = SYSDBA
49 < 29 = masterkey
50 < 48 = UTF8
45 < 65 = 3
46 > DPB: Item Count = 4
47 >  isc_dpb_user_name = SYSDBA
48 >  isc_dpb_password = masterkey
49 >  isc_dpb_lc_ctype = UTF8
50 >  isc_dpb_set_db_sql_dialect = 3
51  
52   Creating a Database with a DPD
53   Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus
54   ODS major = 11
55   ODS minor = 2
56 < DB Connect String = /tmp/fbintf-testsuite/testsuite1.fdb
56 > Attachment ID = 2
57 > DB Connect String = localhost:/tmp/fbintf-testsuite/testsuite1.fdb
58   DB Charset ID = 4
59   DB SQL Dialect = 3
60   DB Remote Protocol = TCPv4
61   DB ODS Major Version = 11
62   DB ODS Minor Version = 2
63   User Authentication Method = Legacy_Auth
64 < Firebird Library Path = /opt/firebird2.5.9/lib/libfbclient.so
64 > Firebird Library Path = /opt/firebird2.5.9/lib/libfbembed.so
65   DB Client Implementation Version = 2.5
66   RDB$DESCRIPTION =
67   RDB$RELATION_ID = 128
# Line 64 | Line 70 | RDB$CHARACTER_SET_NAME = UTF8
70   Dropping Database
71  
72  
73 + ------------------------------------------------------
74   Running Test 2: Open the employee database and run a query
75 + Open Database fails Engine Code: 335544472 Your user name and password are not defined. Ask your database administrator to set up a Firebird login
76   Opening localhost:employee
77   Database Open, SQL Dialect = 3
78 + TPB: Item Count = 3
79 +  isc_tpb_read
80 +  isc_tpb_nowait
81 +  isc_tpb_concurrency
82 +
83 + Metadata
84 + SQLType =SQL_SHORT
85 + sub type = 0
86 + Table = EMPLOYEE
87 + Owner = SYSDBA
88 + Column Name = EMP_NO
89 + Alias Name = EMP_NO
90 + Field Name = EMP_NO
91 + Scale = 0
92 + Charset id = 0
93 + Not Null
94 + Size = 2
95 +
96 + SQLType =SQL_VARYING
97 + sub type = 0
98 + Table = EMPLOYEE
99 + Owner = SYSDBA
100 + Column Name = FIRST_NAME
101 + Alias Name = FIRST_NAME
102 + Field Name = FIRST_NAME
103 + Scale = 0
104 + Charset id = 0
105 + Not Null
106 + Size = 15
107 +
108 + SQLType =SQL_VARYING
109 + sub type = 0
110 + Table = EMPLOYEE
111 + Owner = SYSDBA
112 + Column Name = LAST_NAME
113 + Alias Name = LAST_NAME
114 + Field Name = LAST_NAME
115 + Scale = 0
116 + Charset id = 0
117 + Not Null
118 + Size = 20
119 +
120 + SQLType =SQL_VARYING
121 + sub type = 0
122 + Table = EMPLOYEE
123 + Owner = SYSDBA
124 + Column Name = PHONE_EXT
125 + Alias Name = PHONE_EXT
126 + Field Name = PHONE_EXT
127 + Scale = 0
128 + Charset id = 0
129 + Nullable
130 + Size = 4
131 +
132 + SQLType =SQL_TIMESTAMP
133 + sub type = 0
134 + Table = EMPLOYEE
135 + Owner = SYSDBA
136 + Column Name = HIRE_DATE
137 + Alias Name = HIRE_DATE
138 + Field Name = HIRE_DATE
139 + Scale = 0
140 + Charset id = 0
141 + Not Null
142 + Size = 8
143 +
144 + SQLType =SQL_TEXT
145 + sub type = 0
146 + Table = EMPLOYEE
147 + Owner = SYSDBA
148 + Column Name = DEPT_NO
149 + Alias Name = DEPT_NO
150 + Field Name = DEPT_NO
151 + Scale = 0
152 + Charset id = 0
153 + Not Null
154 + Size = 3
155 +
156 + SQLType =SQL_VARYING
157 + sub type = 0
158 + Table = EMPLOYEE
159 + Owner = SYSDBA
160 + Column Name = JOB_CODE
161 + Alias Name = JOB_CODE
162 + Field Name = JOB_CODE
163 + Scale = 0
164 + Charset id = 0
165 + Not Null
166 + Size = 5
167 +
168 + SQLType =SQL_SHORT
169 + sub type = 0
170 + Table = EMPLOYEE
171 + Owner = SYSDBA
172 + Column Name = JOB_GRADE
173 + Alias Name = JOB_GRADE
174 + Field Name = JOB_GRADE
175 + Scale = 0
176 + Charset id = 0
177 + Not Null
178 + Size = 2
179 +
180 + SQLType =SQL_VARYING
181 + sub type = 0
182 + Table = EMPLOYEE
183 + Owner = SYSDBA
184 + Column Name = JOB_COUNTRY
185 + Alias Name = JOB_COUNTRY
186 + Field Name = JOB_COUNTRY
187 + Scale = 0
188 + Charset id = 0
189 + Not Null
190 + Size = 15
191 +
192 + SQLType =SQL_INT64
193 + sub type = 0
194 + Table = EMPLOYEE
195 + Owner = SYSDBA
196 + Column Name = SALARY
197 + Alias Name = SALARY
198 + Field Name = SALARY
199 + Scale = -2
200 + Charset id = 0
201 + Not Null
202 + Size = 8
203 +
204 + SQLType =SQL_VARYING
205 + sub type = 0
206 + Table = EMPLOYEE
207 + Owner = SYSDBA
208 + Column Name = FULL_NAME
209 + Alias Name = FULL_NAME
210 + Field Name = FULL_NAME
211 + Scale = 0
212 + Charset id = 0
213 + Nullable
214 + Size = 37
215 +
216 + Plan =
217 + PLAN (EMPLOYEE NATURAL)
218 + -- SQL style inline comment
219 + /* this is a comment */ Select First 3 * from EMPLOYEE
220 +
221 + EMP_NO = 2
222 + FIRST_NAME = Robert
223 + LAST_NAME = Nelson
224 + PHONE_EXT = 250
225 + HIRE_DATE = 1988/12/28 00:00:00.0000
226 + DEPT_NO = 600
227 + JOB_CODE = VP
228 + JOB_GRADE = 2
229 + JOB_COUNTRY = USA
230 + SALARY = 105,900.00
231 + FULL_NAME = Nelson, Robert
232 + EMP_NO = 4
233 + FIRST_NAME = Bruce
234 + LAST_NAME = Young
235 + PHONE_EXT = 233
236 + HIRE_DATE = 1988/12/28 00:00:00.0000
237 + DEPT_NO = 621
238 + JOB_CODE = Eng
239 + JOB_GRADE = 2
240 + JOB_COUNTRY = USA
241 + SALARY = 97,500.00
242 + FULL_NAME = Young, Bruce
243 + EMP_NO = 5
244 + FIRST_NAME = Kim
245 + LAST_NAME = Lambert
246 + PHONE_EXT = 22
247 + HIRE_DATE = 1989/02/06 00:00:00.0000
248 + DEPT_NO = 130
249 + JOB_CODE = Eng
250 + JOB_GRADE = 2
251 + JOB_COUNTRY = USA
252 + SALARY = 102,750.00
253 + FULL_NAME = Lambert, Kim
254 +
255 + Select * from EMPLOYEE Where EMP_NO = ?
256 + SQL Params
257 + SQLType =SQL_SHORT
258 + sub type = 0
259 + Field Name =
260 + Scale = 0
261 + Charset id = 0
262 + Not Null
263 + Size = 2
264 + Value = 0
265 +
266 + EMP_NO = 8
267 + FIRST_NAME = Leslie
268 + LAST_NAME = Johnson
269 + PHONE_EXT = 410
270 + HIRE_DATE = 1989/04/05 00:00:00.0000
271 + DEPT_NO = 180
272 + JOB_CODE = Mktg
273 + JOB_GRADE = 3
274 + JOB_COUNTRY = USA
275 + SALARY = 64,635.00
276 + FULL_NAME = Johnson, Leslie
277 +
278 + With param names
279 + Select * from EMPLOYEE Where EMP_NO = :EMP_NO
280 + SQL Params
281 + SQLType =SQL_SHORT
282 + sub type = 0
283 + Field Name = EMP_NO
284 + Scale = 0
285 + Charset id = 0
286 + Not Null
287 + Size = 2
288 + Value = 0
289 +
290 + Results for Cursor: Test Cursor
291 + EMP_NO = 8
292 + FIRST_NAME = Leslie
293 + LAST_NAME = Johnson
294 + PHONE_EXT = 410
295 + HIRE_DATE = 1989/04/05 00:00:00.0000
296 + DEPT_NO = 180
297 + JOB_CODE = Mktg
298 + JOB_GRADE = 3
299 + JOB_COUNTRY = USA
300 + SALARY = 64,635.00
301 + FULL_NAME = Johnson, Leslie
302 +
303 + Now open the employee database as a local database
304 + TPB: Item Count = 3
305 +  isc_tpb_read
306 +  isc_tpb_nowait
307 +  isc_tpb_concurrency
308 +
309   Metadata
310   SQLType =SQL_SHORT
311   sub type = 0
# Line 209 | Line 448 | EMP_NO = 2
448   FIRST_NAME = Robert
449   LAST_NAME = Nelson
450   PHONE_EXT = 250
451 < HIRE_DATE = 28/12/1988 00:00:00.000
451 > HIRE_DATE = 1988/12/28 00:00:00.0000
452   DEPT_NO = 600
453   JOB_CODE = VP
454   JOB_GRADE = 2
# Line 220 | Line 459 | EMP_NO = 4
459   FIRST_NAME = Bruce
460   LAST_NAME = Young
461   PHONE_EXT = 233
462 < HIRE_DATE = 28/12/1988 00:00:00.000
462 > HIRE_DATE = 1988/12/28 00:00:00.0000
463   DEPT_NO = 621
464   JOB_CODE = Eng
465   JOB_GRADE = 2
# Line 231 | Line 470 | EMP_NO = 5
470   FIRST_NAME = Kim
471   LAST_NAME = Lambert
472   PHONE_EXT = 22
473 < HIRE_DATE = 6/2/1989 00:00:00.000
473 > HIRE_DATE = 1989/02/06 00:00:00.0000
474   DEPT_NO = 130
475   JOB_CODE = Eng
476   JOB_GRADE = 2
# Line 248 | Line 487 | Scale = 0
487   Charset id = 0
488   Not Null
489   Size = 2
490 + Value = 0
491  
492   EMP_NO = 8
493   FIRST_NAME = Leslie
494   LAST_NAME = Johnson
495   PHONE_EXT = 410
496 < HIRE_DATE = 5/4/1989 00:00:00.000
496 > HIRE_DATE = 1989/04/05 00:00:00.0000
497   DEPT_NO = 180
498   JOB_CODE = Mktg
499   JOB_GRADE = 3
# Line 271 | Line 511 | Scale = 0
511   Charset id = 0
512   Not Null
513   Size = 2
514 + Value = 0
515  
516 + Results for Cursor: Test Cursor
517   EMP_NO = 8
518   FIRST_NAME = Leslie
519   LAST_NAME = Johnson
520   PHONE_EXT = 410
521 < HIRE_DATE = 5/4/1989 00:00:00.000
521 > HIRE_DATE = 1989/04/05 00:00:00.0000
522   DEPT_NO = 180
523   JOB_CODE = Mktg
524   JOB_GRADE = 3
# Line 286 | Line 528 | FULL_NAME = Johnson, Leslie
528  
529  
530  
531 + ------------------------------------------------------
532   Running Test 3: ad hoc queries
533   Opening localhost:employee
534   Database Open
535   Employee Count = 42
536 + Transaction ID = 5972
537 + Transaction is Read/Write
538 + Transaction ID = 5972
539 + Oldest Interesting = 5461
540 + Oldest Action = 5971
541 + Oldest Snapshot = 5971
542 + Oldest Interesting = 0
543   Employee Count = 41
544   Employee Count = 42
545   Employee Count = 41
# Line 299 | Line 549 | Constrained Employee Count = 3
549   "Yanowski" Employee Count = 1
550  
551  
552 + ------------------------------------------------------
553   Running Test 4: Update, Insert and Delete Queries
554   Opening localhost:employee
555   Database Open
# Line 311 | Line 562 | EMP_NO = 8
562   FIRST_NAME = Leslie
563   LAST_NAME = Johnson
564   PHONE_EXT = 410
565 < HIRE_DATE = 5/4/1989 00:00:00.000
565 > HIRE_DATE = 1989/04/05 00:00:00.0000
566   DEPT_NO = 180
567   JOB_CODE = Mktg
568   JOB_GRADE = 3
# Line 319 | Line 570 | JOB_COUNTRY = USA
570   SALARY = 64,635.00
571   FULL_NAME = Johnson, Leslie
572  
573 < Current memory = 948664
574 < Delta memory = 1400
575 < Max memory = 992600
576 < Elapsed time= 0.002 sec
573 > Current memory = 948,640
574 > Delta memory = 1,304
575 > Max memory = 992,560
576 > Elapsed time= 0.003 sec
577   Cpu = 0.000 sec
578   Buffers = 75
579   Reads = 0
# Line 467 | Line 718 | EMP_NO = 150
718   FIRST_NAME = John
719   LAST_NAME = Doe
720   PHONE_EXT =
721 < HIRE_DATE = 1/4/2015 00:00:00.000
721 > HIRE_DATE = 2015/04/01 00:00:00.0000
722   DEPT_NO = 600
723   JOB_CODE = Eng
724   JOB_GRADE = 4
# Line 480 | Line 731 | EMP_NO = 151
731   FIRST_NAME = Major
732   LAST_NAME = Major
733   PHONE_EXT =
734 < HIRE_DATE = 1/4/2015 00:00:00.000
734 > HIRE_DATE = 2015/04/01 00:00:00.0000
735   DEPT_NO = 600
736   JOB_CODE = Eng
737   JOB_GRADE = 4
# Line 497 | Line 748 | EMP_NO = 150
748   FIRST_NAME = Jane
749   LAST_NAME = Doe
750   PHONE_EXT = NULL
751 < HIRE_DATE = 1/4/2015 00:00:00.000
751 > HIRE_DATE = 2015/04/01 00:00:00.0000
752   DEPT_NO = 600
753   JOB_CODE = Eng
754   JOB_GRADE = 4
# Line 514 | Line 765 | EMP_NO = 150
765   FIRST_NAME = Jayne's
766   LAST_NAME = Doe
767   PHONE_EXT = NULL
768 < HIRE_DATE = 1/4/2015 00:00:00.000
768 > HIRE_DATE = 2015/04/01 00:00:00.0000
769   DEPT_NO = 600
770   JOB_CODE = Eng
771   JOB_GRADE = 4
# Line 528 | Line 779 | EMP_NO = 8
779   FIRST_NAME = Leslie
780   LAST_NAME = Johnson
781   PHONE_EXT = 410
782 < HIRE_DATE = 5/4/1989 00:00:00.000
782 > HIRE_DATE = 1989/04/05 00:00:00.0000
783   DEPT_NO = 180
784   JOB_CODE = Mktg
785   JOB_GRADE = 3
# Line 542 | Line 793 | EMP_NO = 8
793   FIRST_NAME = Leslie
794   LAST_NAME = Johnson
795   PHONE_EXT = 410
796 < HIRE_DATE = 5/4/1989 00:00:00.000
796 > HIRE_DATE = 1989/04/05 00:00:00.0000
797   DEPT_NO = 180
798   JOB_CODE = Mktg
799   JOB_GRADE = 3
# Line 554 | Line 805 | EMP_NO = 9
805   FIRST_NAME = Phil
806   LAST_NAME = Forest
807   PHONE_EXT = 229
808 < HIRE_DATE = 17/4/1989 00:00:00.000
808 > HIRE_DATE = 1989/04/17 00:00:00.0000
809   DEPT_NO = 622
810   JOB_CODE = Mngr
811   JOB_GRADE = 3
# Line 568 | Line 819 | EMP_NO = 8
819   FIRST_NAME = Leslie
820   LAST_NAME = Johnson
821   PHONE_EXT = 410
822 < HIRE_DATE = 31/1/2015 00:00:00.000
822 > HIRE_DATE = 2015/01/31 00:00:00.0000
823   DEPT_NO = 180
824   JOB_CODE = Mktg
825   JOB_GRADE = 3
# Line 578 | Line 829 | FULL_NAME = Johnson, Leslie
829  
830  
831  
832 + ------------------------------------------------------
833   Running Test 5: Update Returning and Activity Check
834   Opening localhost:employee
835   Database Open
# Line 589 | Line 841 | EMP_NO = 8
841   FIRST_NAME = Leslie
842   LAST_NAME = Johnson
843   PHONE_EXT = 410
844 < HIRE_DATE = 31/1/2016 00:00:00.000
844 > HIRE_DATE = 2016/01/31 00:00:00.0000
845   DEPT_NO = 180
846   JOB_CODE = Mktg
847   JOB_GRADE = 3
# Line 611 | Line 863 | Transaction Active
863   Transaction inactive
864  
865  
866 + ------------------------------------------------------
867   Running Test 6: Blob Handling
868   Metadata
869   SQLType =SQL_TEXT
# Line 637 | Line 890 | Charset id = 0
890   Nullable
891   Size = 2
892  
893 < RDB$CHARACTER_SET_NAME = NONE (Charset Id = 4 Codepage = 65001 Byte Length = 31)
893 > RDB$CHARACTER_SET_NAME = NONE (Charset Id = 4 Codepage = 65001)
894   RDB$CHARACTER_SET_ID = 0
895 < RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 4 Codepage = 65001 Byte Length = 31)
895 > RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 4 Codepage = 65001)
896   RDB$CHARACTER_SET_ID = 1
897 < RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 4 Codepage = 65001 Byte Length = 31)
897 > RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 4 Codepage = 65001)
898   RDB$CHARACTER_SET_ID = 2
899 < RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 4 Codepage = 65001 Byte Length = 31)
899 > RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 4 Codepage = 65001)
900   RDB$CHARACTER_SET_ID = 3
901 < RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
901 > RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 4 Codepage = 65001)
902   RDB$CHARACTER_SET_ID = 4
903 < RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
903 > RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 4 Codepage = 65001)
904   RDB$CHARACTER_SET_ID = 5
905 < RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
905 > RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 4 Codepage = 65001)
906   RDB$CHARACTER_SET_ID = 6
907 < RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
907 > RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 4 Codepage = 65001)
908   RDB$CHARACTER_SET_ID = 9
909 < RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
909 > RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 4 Codepage = 65001)
910   RDB$CHARACTER_SET_ID = 10
911 < RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
911 > RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 4 Codepage = 65001)
912   RDB$CHARACTER_SET_ID = 11
913 < RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
913 > RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 4 Codepage = 65001)
914   RDB$CHARACTER_SET_ID = 12
915 < RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
915 > RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 4 Codepage = 65001)
916   RDB$CHARACTER_SET_ID = 13
917 < RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
917 > RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 4 Codepage = 65001)
918   RDB$CHARACTER_SET_ID = 14
919 < RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
919 > RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 4 Codepage = 65001)
920   RDB$CHARACTER_SET_ID = 15
921 < RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
921 > RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 4 Codepage = 65001)
922   RDB$CHARACTER_SET_ID = 16
923 < RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
923 > RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 4 Codepage = 65001)
924   RDB$CHARACTER_SET_ID = 17
925 < RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
925 > RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 4 Codepage = 65001)
926   RDB$CHARACTER_SET_ID = 18
927 < RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 4 Codepage = 65001 Byte Length = 31)
927 > RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 4 Codepage = 65001)
928   RDB$CHARACTER_SET_ID = 19
929 < RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
929 > RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 4 Codepage = 65001)
930   RDB$CHARACTER_SET_ID = 21
931 < RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
931 > RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 4 Codepage = 65001)
932   RDB$CHARACTER_SET_ID = 22
933 < RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
933 > RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 4 Codepage = 65001)
934   RDB$CHARACTER_SET_ID = 23
935 < RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
935 > RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 4 Codepage = 65001)
936   RDB$CHARACTER_SET_ID = 34
937 < RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
937 > RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 4 Codepage = 65001)
938   RDB$CHARACTER_SET_ID = 35
939 < RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
939 > RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 4 Codepage = 65001)
940   RDB$CHARACTER_SET_ID = 36
941 < RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
941 > RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 4 Codepage = 65001)
942   RDB$CHARACTER_SET_ID = 37
943 < RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
943 > RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 4 Codepage = 65001)
944   RDB$CHARACTER_SET_ID = 38
945 < RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
945 > RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 4 Codepage = 65001)
946   RDB$CHARACTER_SET_ID = 39
947 < RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
947 > RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 4 Codepage = 65001)
948   RDB$CHARACTER_SET_ID = 40
949 < RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
949 > RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 4 Codepage = 65001)
950   RDB$CHARACTER_SET_ID = 44
951 < RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
951 > RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 4 Codepage = 65001)
952   RDB$CHARACTER_SET_ID = 45
953 < RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
953 > RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 4 Codepage = 65001)
954   RDB$CHARACTER_SET_ID = 46
955 < RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
955 > RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 4 Codepage = 65001)
956   RDB$CHARACTER_SET_ID = 47
957 < RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
957 > RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 4 Codepage = 65001)
958   RDB$CHARACTER_SET_ID = 48
959 < RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
959 > RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 4 Codepage = 65001)
960   RDB$CHARACTER_SET_ID = 49
961 < RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 4 Codepage = 65001 Byte Length = 31)
961 > RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 4 Codepage = 65001)
962   RDB$CHARACTER_SET_ID = 50
963 < RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
963 > RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 4 Codepage = 65001)
964   RDB$CHARACTER_SET_ID = 51
965 < RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
965 > RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 4 Codepage = 65001)
966   RDB$CHARACTER_SET_ID = 52
967 < RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
967 > RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 4 Codepage = 65001)
968   RDB$CHARACTER_SET_ID = 53
969 < RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
969 > RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 4 Codepage = 65001)
970   RDB$CHARACTER_SET_ID = 54
971 < RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
971 > RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 4 Codepage = 65001)
972   RDB$CHARACTER_SET_ID = 55
973 < RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
973 > RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 4 Codepage = 65001)
974   RDB$CHARACTER_SET_ID = 56
975 < RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
975 > RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 4 Codepage = 65001)
976   RDB$CHARACTER_SET_ID = 57
977 < RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
977 > RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 4 Codepage = 65001)
978   RDB$CHARACTER_SET_ID = 58
979 < RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
979 > RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 4 Codepage = 65001)
980   RDB$CHARACTER_SET_ID = 59
981 < RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
981 > RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 4 Codepage = 65001)
982   RDB$CHARACTER_SET_ID = 60
983 < RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 4 Codepage = 65001 Byte Length = 31)
983 > RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 4 Codepage = 65001)
984   RDB$CHARACTER_SET_ID = 63
985 < RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 4 Codepage = 65001 Byte Length = 31)
985 > RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 4 Codepage = 65001)
986   RDB$CHARACTER_SET_ID = 64
987 < RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
987 > RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 4 Codepage = 65001)
988   RDB$CHARACTER_SET_ID = 65
989 < RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
989 > RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 4 Codepage = 65001)
990   RDB$CHARACTER_SET_ID = 66
991 < RDB$CHARACTER_SET_NAME = GBK (Charset Id = 4 Codepage = 65001 Byte Length = 31)
991 > RDB$CHARACTER_SET_NAME = GBK (Charset Id = 4 Codepage = 65001)
992   RDB$CHARACTER_SET_ID = 67
993 < RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 4 Codepage = 65001 Byte Length = 31)
993 > RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 4 Codepage = 65001)
994   RDB$CHARACTER_SET_ID = 68
995 < RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
995 > RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 4 Codepage = 65001)
996   RDB$CHARACTER_SET_ID = 69
997  
998   Metadata
# Line 819 | Line 1072 | Scale = 0
1072   Charset id = 0
1073   Not Null
1074   Size = 4
1075 + Value = 0
1076  
1077   SQLType =SQL_VARYING
1078   sub type = 0
# Line 847 | Line 1101 | Size = 8
1101   ROWID = 1
1102   FIXEDPOINT = 20.28
1103   FLOATINGPOINT = 3.14
1104 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
1104 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1105   BLOBDATA = NULL
1106  
1107   SQL Params
# Line 866 | Line 1120 | Scale = 0
1120   Charset id = 0
1121   Not Null
1122   Size = 4
1123 + Value = 0
1124  
1125   ROWID = 1
1126   FIXEDPOINT = 20.28
1127   FLOATINGPOINT = 3.14
1128 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
1128 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1129   BLOBDATA (Charset Id = 4 Codepage = 65001)
1130  
1131   To be or not to be-that is the question:
# Line 918 | Line 1173 | Scale = 0
1173   Charset id = 0
1174   Not Null
1175   Size = 4
1176 + Value = 0
1177  
1178   SQLType =SQL_VARYING
1179   sub type = 0
# Line 946 | Line 1202 | Size = 8
1202   ROWID = 1
1203   FIXEDPOINT = 20.28
1204   FLOATINGPOINT = 3.14
1205 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
1205 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1206   BLOBDATA (Charset Id = 4 Codepage = 65001)
1207  
1208   To be or not to be-that is the question:
# Line 988 | Line 1244 | Be all my sins remembered
1244   ROWID = 2
1245   FIXEDPOINT = NULL
1246   FLOATINGPOINT = NULL
1247 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
1247 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1248   BLOBDATA (Charset Id = 4 Codepage = 65001)
1249  
1250   To be or not to be-that is the question:
# Line 1113 | Line 1369 | Charset id = 0
1369   Nullable
1370   Size = 2
1371  
1372 < RDB$CHARACTER_SET_NAME = NONE (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1372 > RDB$CHARACTER_SET_NAME = NONE (Charset Id = 53 Codepage = 1252)
1373   RDB$CHARACTER_SET_ID = 0
1374 < RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1374 > RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 53 Codepage = 1252)
1375   RDB$CHARACTER_SET_ID = 1
1376 < RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1376 > RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 53 Codepage = 1252)
1377   RDB$CHARACTER_SET_ID = 2
1378 < RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1378 > RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 53 Codepage = 1252)
1379   RDB$CHARACTER_SET_ID = 3
1380 < RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1380 > RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 53 Codepage = 1252)
1381   RDB$CHARACTER_SET_ID = 4
1382 < RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1382 > RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 53 Codepage = 1252)
1383   RDB$CHARACTER_SET_ID = 5
1384 < RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1384 > RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 53 Codepage = 1252)
1385   RDB$CHARACTER_SET_ID = 6
1386 < RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1386 > RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 53 Codepage = 1252)
1387   RDB$CHARACTER_SET_ID = 9
1388 < RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1388 > RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 53 Codepage = 1252)
1389   RDB$CHARACTER_SET_ID = 10
1390 < RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1390 > RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 53 Codepage = 1252)
1391   RDB$CHARACTER_SET_ID = 11
1392 < RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1392 > RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 53 Codepage = 1252)
1393   RDB$CHARACTER_SET_ID = 12
1394 < RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1394 > RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 53 Codepage = 1252)
1395   RDB$CHARACTER_SET_ID = 13
1396 < RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1396 > RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 53 Codepage = 1252)
1397   RDB$CHARACTER_SET_ID = 14
1398 < RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1398 > RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 53 Codepage = 1252)
1399   RDB$CHARACTER_SET_ID = 15
1400 < RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1400 > RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 53 Codepage = 1252)
1401   RDB$CHARACTER_SET_ID = 16
1402 < RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1402 > RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 53 Codepage = 1252)
1403   RDB$CHARACTER_SET_ID = 17
1404 < RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1404 > RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 53 Codepage = 1252)
1405   RDB$CHARACTER_SET_ID = 18
1406 < RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1406 > RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 53 Codepage = 1252)
1407   RDB$CHARACTER_SET_ID = 19
1408 < RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1408 > RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 53 Codepage = 1252)
1409   RDB$CHARACTER_SET_ID = 21
1410 < RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1410 > RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 53 Codepage = 1252)
1411   RDB$CHARACTER_SET_ID = 22
1412 < RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1412 > RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 53 Codepage = 1252)
1413   RDB$CHARACTER_SET_ID = 23
1414 < RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1414 > RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 53 Codepage = 1252)
1415   RDB$CHARACTER_SET_ID = 34
1416 < RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1416 > RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 53 Codepage = 1252)
1417   RDB$CHARACTER_SET_ID = 35
1418 < RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1418 > RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 53 Codepage = 1252)
1419   RDB$CHARACTER_SET_ID = 36
1420 < RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1420 > RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 53 Codepage = 1252)
1421   RDB$CHARACTER_SET_ID = 37
1422 < RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1422 > RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 53 Codepage = 1252)
1423   RDB$CHARACTER_SET_ID = 38
1424 < RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1424 > RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 53 Codepage = 1252)
1425   RDB$CHARACTER_SET_ID = 39
1426 < RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1426 > RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 53 Codepage = 1252)
1427   RDB$CHARACTER_SET_ID = 40
1428 < RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1428 > RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 53 Codepage = 1252)
1429   RDB$CHARACTER_SET_ID = 44
1430 < RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1430 > RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 53 Codepage = 1252)
1431   RDB$CHARACTER_SET_ID = 45
1432 < RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1432 > RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 53 Codepage = 1252)
1433   RDB$CHARACTER_SET_ID = 46
1434 < RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1434 > RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 53 Codepage = 1252)
1435   RDB$CHARACTER_SET_ID = 47
1436 < RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1436 > RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 53 Codepage = 1252)
1437   RDB$CHARACTER_SET_ID = 48
1438 < RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1438 > RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 53 Codepage = 1252)
1439   RDB$CHARACTER_SET_ID = 49
1440 < RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1440 > RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 53 Codepage = 1252)
1441   RDB$CHARACTER_SET_ID = 50
1442 < RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1442 > RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 53 Codepage = 1252)
1443   RDB$CHARACTER_SET_ID = 51
1444 < RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1444 > RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 53 Codepage = 1252)
1445   RDB$CHARACTER_SET_ID = 52
1446 < RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1446 > RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 53 Codepage = 1252)
1447   RDB$CHARACTER_SET_ID = 53
1448 < RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1448 > RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 53 Codepage = 1252)
1449   RDB$CHARACTER_SET_ID = 54
1450 < RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1450 > RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 53 Codepage = 1252)
1451   RDB$CHARACTER_SET_ID = 55
1452 < RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1452 > RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 53 Codepage = 1252)
1453   RDB$CHARACTER_SET_ID = 56
1454 < RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1454 > RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 53 Codepage = 1252)
1455   RDB$CHARACTER_SET_ID = 57
1456 < RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1456 > RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 53 Codepage = 1252)
1457   RDB$CHARACTER_SET_ID = 58
1458 < RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1458 > RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 53 Codepage = 1252)
1459   RDB$CHARACTER_SET_ID = 59
1460 < RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1460 > RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 53 Codepage = 1252)
1461   RDB$CHARACTER_SET_ID = 60
1462 < RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1462 > RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 53 Codepage = 1252)
1463   RDB$CHARACTER_SET_ID = 63
1464 < RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1464 > RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 53 Codepage = 1252)
1465   RDB$CHARACTER_SET_ID = 64
1466 < RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1466 > RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 53 Codepage = 1252)
1467   RDB$CHARACTER_SET_ID = 65
1468 < RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1468 > RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 53 Codepage = 1252)
1469   RDB$CHARACTER_SET_ID = 66
1470 < RDB$CHARACTER_SET_NAME = GBK (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1470 > RDB$CHARACTER_SET_NAME = GBK (Charset Id = 53 Codepage = 1252)
1471   RDB$CHARACTER_SET_ID = 67
1472 < RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1472 > RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 53 Codepage = 1252)
1473   RDB$CHARACTER_SET_ID = 68
1474 < RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1474 > RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 53 Codepage = 1252)
1475   RDB$CHARACTER_SET_ID = 69
1476  
1477   Metadata
# Line 1295 | Line 1551 | Scale = 0
1551   Charset id = 0
1552   Not Null
1553   Size = 4
1554 + Value = 0
1555  
1556   SQLType =SQL_VARYING
1557   sub type = 0
# Line 1323 | Line 1580 | Size = 8
1580   ROWID = 1
1581   FIXEDPOINT = 20.28
1582   FLOATINGPOINT = 3.14
1583 < TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15)
1583 > TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1584   BLOBDATA = NULL
1585  
1586   SQL Params
# Line 1342 | Line 1599 | Scale = 0
1599   Charset id = 0
1600   Not Null
1601   Size = 4
1602 + Value = 0
1603  
1604   ROWID = 1
1605   FIXEDPOINT = 20.28
1606   FLOATINGPOINT = 3.14
1607 < TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15)
1607 > TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1608   BLOBDATA (Charset Id = 53 Codepage = 1252)
1609  
1610   To be or not to be-that is the question:
# Line 1394 | Line 1652 | Scale = 0
1652   Charset id = 0
1653   Not Null
1654   Size = 4
1655 + Value = 0
1656  
1657   SQLType =SQL_VARYING
1658   sub type = 0
# Line 1422 | Line 1681 | Size = 8
1681   ROWID = 1
1682   FIXEDPOINT = 20.28
1683   FLOATINGPOINT = 3.14
1684 < TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15)
1684 > TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1685   BLOBDATA (Charset Id = 53 Codepage = 1252)
1686  
1687   To be or not to be-that is the question:
# Line 1464 | Line 1723 | Be all my sins remembered
1723   ROWID = 2
1724   FIXEDPOINT = NULL
1725   FLOATINGPOINT = NULL
1726 < TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15)
1726 > TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1727   BLOBDATA (Charset Id = 53 Codepage = 1252)
1728  
1729   To be or not to be-that is the question:
# Line 1589 | Line 1848 | Charset id = 0
1848   Nullable
1849   Size = 2
1850  
1851 < RDB$CHARACTER_SET_NAME = NONE (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1851 > RDB$CHARACTER_SET_NAME = NONE (Charset Id = 3 Codepage = 65001)
1852   RDB$CHARACTER_SET_ID = 0
1853 < RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1853 > RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 3 Codepage = 65001)
1854   RDB$CHARACTER_SET_ID = 1
1855 < RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1855 > RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 3 Codepage = 65001)
1856   RDB$CHARACTER_SET_ID = 2
1857 < RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1857 > RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 3 Codepage = 65001)
1858   RDB$CHARACTER_SET_ID = 3
1859 < RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1859 > RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 3 Codepage = 65001)
1860   RDB$CHARACTER_SET_ID = 4
1861 < RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1861 > RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 3 Codepage = 65001)
1862   RDB$CHARACTER_SET_ID = 5
1863 < RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1863 > RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 3 Codepage = 65001)
1864   RDB$CHARACTER_SET_ID = 6
1865 < RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1865 > RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 3 Codepage = 65001)
1866   RDB$CHARACTER_SET_ID = 9
1867 < RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1867 > RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 3 Codepage = 65001)
1868   RDB$CHARACTER_SET_ID = 10
1869 < RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1869 > RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 3 Codepage = 65001)
1870   RDB$CHARACTER_SET_ID = 11
1871 < RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1871 > RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 3 Codepage = 65001)
1872   RDB$CHARACTER_SET_ID = 12
1873 < RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1873 > RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 3 Codepage = 65001)
1874   RDB$CHARACTER_SET_ID = 13
1875 < RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1875 > RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 3 Codepage = 65001)
1876   RDB$CHARACTER_SET_ID = 14
1877 < RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1877 > RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 3 Codepage = 65001)
1878   RDB$CHARACTER_SET_ID = 15
1879 < RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1879 > RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 3 Codepage = 65001)
1880   RDB$CHARACTER_SET_ID = 16
1881 < RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1881 > RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 3 Codepage = 65001)
1882   RDB$CHARACTER_SET_ID = 17
1883 < RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1883 > RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 3 Codepage = 65001)
1884   RDB$CHARACTER_SET_ID = 18
1885 < RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1885 > RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 3 Codepage = 65001)
1886   RDB$CHARACTER_SET_ID = 19
1887 < RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1887 > RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 3 Codepage = 65001)
1888   RDB$CHARACTER_SET_ID = 21
1889 < RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1889 > RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 3 Codepage = 65001)
1890   RDB$CHARACTER_SET_ID = 22
1891 < RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1891 > RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 3 Codepage = 65001)
1892   RDB$CHARACTER_SET_ID = 23
1893 < RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1893 > RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 3 Codepage = 65001)
1894   RDB$CHARACTER_SET_ID = 34
1895 < RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1895 > RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 3 Codepage = 65001)
1896   RDB$CHARACTER_SET_ID = 35
1897 < RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1897 > RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 3 Codepage = 65001)
1898   RDB$CHARACTER_SET_ID = 36
1899 < RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1899 > RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 3 Codepage = 65001)
1900   RDB$CHARACTER_SET_ID = 37
1901 < RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1901 > RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 3 Codepage = 65001)
1902   RDB$CHARACTER_SET_ID = 38
1903 < RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1903 > RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 3 Codepage = 65001)
1904   RDB$CHARACTER_SET_ID = 39
1905 < RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1905 > RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 3 Codepage = 65001)
1906   RDB$CHARACTER_SET_ID = 40
1907 < RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1907 > RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 3 Codepage = 65001)
1908   RDB$CHARACTER_SET_ID = 44
1909 < RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1909 > RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 3 Codepage = 65001)
1910   RDB$CHARACTER_SET_ID = 45
1911 < RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1911 > RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 3 Codepage = 65001)
1912   RDB$CHARACTER_SET_ID = 46
1913 < RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1913 > RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 3 Codepage = 65001)
1914   RDB$CHARACTER_SET_ID = 47
1915 < RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1915 > RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 3 Codepage = 65001)
1916   RDB$CHARACTER_SET_ID = 48
1917 < RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1917 > RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 3 Codepage = 65001)
1918   RDB$CHARACTER_SET_ID = 49
1919 < RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1919 > RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 3 Codepage = 65001)
1920   RDB$CHARACTER_SET_ID = 50
1921 < RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1921 > RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 3 Codepage = 65001)
1922   RDB$CHARACTER_SET_ID = 51
1923 < RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1923 > RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 3 Codepage = 65001)
1924   RDB$CHARACTER_SET_ID = 52
1925 < RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1925 > RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 3 Codepage = 65001)
1926   RDB$CHARACTER_SET_ID = 53
1927 < RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1927 > RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 3 Codepage = 65001)
1928   RDB$CHARACTER_SET_ID = 54
1929 < RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1929 > RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 3 Codepage = 65001)
1930   RDB$CHARACTER_SET_ID = 55
1931 < RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1931 > RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 3 Codepage = 65001)
1932   RDB$CHARACTER_SET_ID = 56
1933 < RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1933 > RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 3 Codepage = 65001)
1934   RDB$CHARACTER_SET_ID = 57
1935 < RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1935 > RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 3 Codepage = 65001)
1936   RDB$CHARACTER_SET_ID = 58
1937 < RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1937 > RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 3 Codepage = 65001)
1938   RDB$CHARACTER_SET_ID = 59
1939 < RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1939 > RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 3 Codepage = 65001)
1940   RDB$CHARACTER_SET_ID = 60
1941 < RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1941 > RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 3 Codepage = 65001)
1942   RDB$CHARACTER_SET_ID = 63
1943 < RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1943 > RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 3 Codepage = 65001)
1944   RDB$CHARACTER_SET_ID = 64
1945 < RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1945 > RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 3 Codepage = 65001)
1946   RDB$CHARACTER_SET_ID = 65
1947 < RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1947 > RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 3 Codepage = 65001)
1948   RDB$CHARACTER_SET_ID = 66
1949 < RDB$CHARACTER_SET_NAME = GBK (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1949 > RDB$CHARACTER_SET_NAME = GBK (Charset Id = 3 Codepage = 65001)
1950   RDB$CHARACTER_SET_ID = 67
1951 < RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1951 > RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 3 Codepage = 65001)
1952   RDB$CHARACTER_SET_ID = 68
1953 < RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1953 > RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 3 Codepage = 65001)
1954   RDB$CHARACTER_SET_ID = 69
1955  
1956   Metadata
# Line 1771 | Line 2030 | Scale = 0
2030   Charset id = 0
2031   Not Null
2032   Size = 4
2033 + Value = 0
2034  
2035   SQLType =SQL_VARYING
2036   sub type = 0
# Line 1799 | Line 2059 | Size = 8
2059   ROWID = 1
2060   FIXEDPOINT = 20.28
2061   FLOATINGPOINT = 3.14
2062 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2062 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2063   BLOBDATA = NULL
2064  
2065   SQL Params
# Line 1818 | Line 2078 | Scale = 0
2078   Charset id = 0
2079   Not Null
2080   Size = 4
2081 + Value = 0
2082  
2083   ROWID = 1
2084   FIXEDPOINT = 20.28
2085   FLOATINGPOINT = 3.14
2086 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2086 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2087   BLOBDATA (Charset Id = 4 Codepage = 65001)
2088  
2089   To be or not to be-that is the question:
# Line 1870 | Line 2131 | Scale = 0
2131   Charset id = 0
2132   Not Null
2133   Size = 4
2134 + Value = 0
2135  
2136   SQLType =SQL_VARYING
2137   sub type = 0
# Line 1898 | Line 2160 | Size = 8
2160   ROWID = 1
2161   FIXEDPOINT = 20.28
2162   FLOATINGPOINT = 3.14
2163 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2163 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2164   BLOBDATA (Charset Id = 4 Codepage = 65001)
2165  
2166   To be or not to be-that is the question:
# Line 1940 | Line 2202 | Be all my sins remembered
2202   ROWID = 2
2203   FIXEDPOINT = NULL
2204   FLOATINGPOINT = NULL
2205 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2205 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2206   BLOBDATA (Charset Id = 4 Codepage = 65001)
2207  
2208   To be or not to be-that is the question:
# Line 2042 | Line 2304 | Be all my sins remembered
2304  
2305  
2306  
2307 + ------------------------------------------------------
2308   Running Test 7: Create and read back an Array
2309   Metadata
2310   SQLType =SQL_LONG
# Line 2113 | Line 2376 | Column = MYARRAY
2376   Dimensions = 1
2377   Bounds: (0:16)
2378  
2379 + SQLType =SQL_ARRAY
2380 + sub type = 0
2381 + Table = TESTDATA
2382 + Owner = SYSDBA
2383 + Column Name = MYARRAY2
2384 + Alias Name = MYARRAY2
2385 + Field Name = MYARRAY2
2386 + Scale = 0
2387 + Charset id = 0
2388 + Nullable
2389 + Size = 8
2390 + Array Meta Data:
2391 + SQLType =SQL_TIMESTAMP
2392 + Scale = 0
2393 + Charset id = 0
2394 + Size = 8
2395 + Table = TESTDATA
2396 + Column = MYARRAY2
2397 + Dimensions = 1
2398 + Bounds: (0:16)
2399 +
2400 + SQLType =SQL_ARRAY
2401 + sub type = 0
2402 + Table = TESTDATA
2403 + Owner = SYSDBA
2404 + Column Name = MYARRAY3
2405 + Alias Name = MYARRAY3
2406 + Field Name = MYARRAY3
2407 + Scale = 0
2408 + Charset id = 0
2409 + Nullable
2410 + Size = 8
2411 + Array Meta Data:
2412 + SQLType =SQL_INT64
2413 + Scale = -2
2414 + Charset id = 0
2415 + Size = 8
2416 + Table = TESTDATA
2417 + Column = MYARRAY3
2418 + Dimensions = 1
2419 + Bounds: (0:16)
2420 +
2421   SQL Params
2422   SQLType =SQL_LONG
2423   sub type = 0
# Line 2121 | Line 2426 | Scale = 0
2426   Charset id = 0
2427   Not Null
2428   Size = 4
2429 + Value = 0
2430  
2431   SQLType =SQL_VARYING
2432   sub type = 0
# Line 2151 | Line 2457 | Param Name = TITLE
2457   Param Name = DATED
2458   Param Name = NOTES
2459   ROWID = 1
2460 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2461 < DATED = 1/4/2016 09:30:00.100
2462 < NOTES = Écoute moi (Charset Id = 4 Codepage = 65001 Byte Length = 11)
2460 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2461 > DATED = 2016/04/01 09:30:00.1000
2462 > NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
2463   MYARRAY = NULL
2464 + MYARRAY2 = NULL
2465 + MYARRAY3 = NULL
2466  
2467   SQL Params
2468   SQLType =SQL_ARRAY
# Line 2165 | Line 2473 | Charset id = 0
2473   Nullable
2474   Size = 8
2475  
2476 + SQL Params
2477 + SQLType =SQL_ARRAY
2478 + sub type = 0
2479 + Field Name = MYARRAY2
2480 + Scale = 0
2481 + Charset id = 0
2482 + Nullable
2483 + Size = 8
2484 +
2485 + SQL Params
2486 + SQLType =SQL_ARRAY
2487 + sub type = 0
2488 + Field Name = MYARRAY3
2489 + Scale = 0
2490 + Charset id = 0
2491 + Nullable
2492 + Size = 8
2493 +
2494 + Metadata
2495 + SQLType =SQL_LONG
2496 + sub type = 0
2497 + Table = TESTDATA
2498 + Owner = SYSDBA
2499 + Column Name = ROWID
2500 + Alias Name = ROWID
2501 + Field Name = ROWID
2502 + Scale = 0
2503 + Charset id = 0
2504 + Not Null
2505 + Size = 4
2506 +
2507 + SQLType =SQL_VARYING
2508 + sub type = 0
2509 + Table = TESTDATA
2510 + Owner = SYSDBA
2511 + Column Name = TITLE
2512 + Alias Name = TITLE
2513 + Field Name = TITLE
2514 + Scale = 0
2515 + Charset id = 4
2516 + Nullable
2517 + Size = 128
2518 +
2519 + SQLType =SQL_TIMESTAMP
2520 + sub type = 0
2521 + Table = TESTDATA
2522 + Owner = SYSDBA
2523 + Column Name = DATED
2524 + Alias Name = DATED
2525 + Field Name = DATED
2526 + Scale = 0
2527 + Charset id = 0
2528 + Nullable
2529 + Size = 8
2530 +
2531 + SQLType =SQL_VARYING
2532 + sub type = 0
2533 + Table = TESTDATA
2534 + Owner = SYSDBA
2535 + Column Name = NOTES
2536 + Alias Name = NOTES
2537 + Field Name = NOTES
2538 + Scale = 0
2539 + Charset id = 4
2540 + Nullable
2541 + Size = 256
2542 +
2543 + SQLType =SQL_ARRAY
2544 + sub type = 0
2545 + Table = TESTDATA
2546 + Owner = SYSDBA
2547 + Column Name = MYARRAY
2548 + Alias Name = MYARRAY
2549 + Field Name = MYARRAY
2550 + Scale = 0
2551 + Charset id = 0
2552 + Nullable
2553 + Size = 8
2554 + Array Meta Data:
2555 + SQLType =SQL_LONG
2556 + Scale = 0
2557 + Charset id = 0
2558 + Size = 4
2559 + Table = TESTDATA
2560 + Column = MYARRAY
2561 + Dimensions = 1
2562 + Bounds: (0:16)
2563 +
2564 + SQLType =SQL_ARRAY
2565 + sub type = 0
2566 + Table = TESTDATA
2567 + Owner = SYSDBA
2568 + Column Name = MYARRAY2
2569 + Alias Name = MYARRAY2
2570 + Field Name = MYARRAY2
2571 + Scale = 0
2572 + Charset id = 0
2573 + Nullable
2574 + Size = 8
2575 + Array Meta Data:
2576 + SQLType =SQL_TIMESTAMP
2577 + Scale = 0
2578 + Charset id = 0
2579 + Size = 8
2580 + Table = TESTDATA
2581 + Column = MYARRAY2
2582 + Dimensions = 1
2583 + Bounds: (0:16)
2584 +
2585 + SQLType =SQL_ARRAY
2586 + sub type = 0
2587 + Table = TESTDATA
2588 + Owner = SYSDBA
2589 + Column Name = MYARRAY3
2590 + Alias Name = MYARRAY3
2591 + Field Name = MYARRAY3
2592 + Scale = 0
2593 + Charset id = 0
2594 + Nullable
2595 + Size = 8
2596 + Array Meta Data:
2597 + SQLType =SQL_INT64
2598 + Scale = -2
2599 + Charset id = 0
2600 + Size = 8
2601 + Table = TESTDATA
2602 + Column = MYARRAY3
2603 + Dimensions = 1
2604 + Bounds: (0:16)
2605 +
2606   ROWID = 1
2607 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2608 < DATED = 1/4/2016 09:30:00.100
2609 < NOTES = Écoute moi (Charset Id = 4 Codepage = 65001 Byte Length = 11)
2610 < 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)
2607 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2608 > DATED = 2016/04/01 09:30:00.1000
2609 > NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
2610 > 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)
2611 >
2612 > 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)
2613 >
2614 > 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.46) (16: 4269)
2615 >
2616  
2617   Shrink to 2:10
2618   Array: (2: 98) (3: 97) (4: 96) (5: 95) (6: 94) (7: 93) (8: 92) (9: 91) (10: 90)
2619 +
2620   Write updated reduced slice
2621   Show update array
2622   ROWID = 1
2623 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2624 < DATED = 1/4/2016 09:30:00.100
2625 < NOTES = Écoute moi (Charset Id = 4 Codepage = 65001 Byte Length = 11)
2626 < 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)
2623 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2624 > DATED = 2016/04/01 09:30:00.1000
2625 > NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
2626 > 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)
2627 >
2628 > 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)
2629 >
2630 > 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.46) (16: 4269)
2631 >
2632  
2633  
2634  
2635 + ------------------------------------------------------
2636   Running Test 8: Create and read back an Array with 2 dimensions
2637   Metadata
2638   SQLType =SQL_LONG
# Line 2238 | Line 2688 | Scale = 0
2688   Charset id = 0
2689   Not Null
2690   Size = 4
2691 + Value = 0
2692  
2693   SQLType =SQL_VARYING
2694   sub type = 0
# Line 2248 | Line 2699 | Nullable
2699   Size = 128
2700  
2701   ROWID = 1
2702 < TITLE = 2D Array (Charset Id = 4 Codepage = 65001 Byte Length = 8)
2702 > TITLE = 2D Array (Charset Id = 4 Codepage = 65001)
2703   MYARRAY = NULL
2704  
2705   ROWID = 1
2706 < TITLE = 2D Array (Charset Id = 4 Codepage = 65001 Byte Length = 8)
2707 < 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)
2706 > TITLE = 2D Array (Charset Id = 4 Codepage = 65001)
2707 > 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)
2708  
2709  
2710  
2711 +
2712 + ------------------------------------------------------
2713   Running Test 9: Database Information tests
2714   Database ID = 4 FB = /opt/firebird2.5.9/examples/empbuild/employee.fdb SN = zeus
2715   Pages =272
# Line 2273 | Line 2726 | Unknown Response 3
2726   Unknown Response 3
2727   Server Memory = 841392
2728   Forced Writes  = 1
2729 < Max Memory  = 879352
2729 > Max Memory  = 879440
2730   Num Buffers  = 75
2731   Sweep Interval  = 20000
2732   Logged in Users: SYSDBA,
# Line 2319 | Line 2772 | Update Count Operation Counts
2772   Page Size = 4096
2773  
2774  
2775 + ------------------------------------------------------
2776   Running Test 10: Event Handling
2777   Call Async Wait
2778   Async Wait Called
# Line 2342 | Line 2796 | Event Signalled
2796   Event Counts: TESTEVENT, Count = 2
2797  
2798  
2799 + ------------------------------------------------------
2800   Running Test 11: Services API
2801 + SPB: Item Count = 2
2802 +  user_name = SYSDBA
2803 +  password = masterkey
2804 +
2805   Service Manager Version = 2
2806   Server Version = LI-V2.5.9.27139 Firebird 2.5
2807   Implementation = Firebird/linux AMD64
# Line 2364 | Line 2823 | User ID = 0
2823   Group ID = 0
2824  
2825  
2826 < Licence Info:
2368 < feature is not supported
2369 < -feature is not supported
2826 > Licence Info: Engine Code: 335544378 feature is not supported
2827  
2828 < Licence Mask Info:
2372 < feature is not supported
2828 > Licence Mask Info: Engine Code: 335544378 feature is not supported
2829  
2830   Capabilities = 260
2831  
# Line 2399 | Line 2855 | Database OK
2855   Database Dropped
2856  
2857  
2858 + ------------------------------------------------------
2859   Running Test 12: Character Sets
2860   SQL Params
2861   SQLType =SQL_LONG
# Line 2408 | Line 2865 | Scale = 0
2865   Charset id = 0
2866   Not Null
2867   Size = 4
2868 + Value = 0
2869  
2870   SQLType =SQL_VARYING
2871   sub type = 0
# Line 2457 | Line 2915 | Charset id = 4
2915   Nullable
2916   Size = 16
2917  
2918 + Show Param Values
2919 + SQL Params
2920 + SQLType =SQL_LONG
2921 + sub type = 0
2922 + Field Name = ROWID
2923 + Scale = 0
2924 + Charset id = 0
2925 + Not Null
2926 + Size = 4
2927 + Value = 1
2928 +
2929 + SQLType =SQL_TEXT
2930 + sub type = 0
2931 + Field Name = TITLE
2932 + Scale = 0
2933 + Charset id = 4
2934 + Nullable
2935 + Size = 128
2936 + Value = Blob Test ©€
2937 +
2938 + SQLType =SQL_TEXT
2939 + sub type = 0
2940 + Field Name = NOTES
2941 + Scale = 0
2942 + Charset id = 4
2943 + Nullable
2944 + Size = 256
2945 + Value = Écoute moi
2946 +
2947 + SQLType =SQL_TEXT
2948 + sub type = 0
2949 + Field Name = BLOBDATA
2950 + Scale = 0
2951 + Charset id = 1
2952 + Nullable
2953 + Size = 8
2954 + Value = Some German Special Characters like ÖÄÜöäüß
2955 +
2956 + SQLType =SQL_BLOB
2957 + sub type = 1
2958 + Field Name = BLOBDATA2
2959 + Scale = 0
2960 + Charset id = 4
2961 + Nullable
2962 + Size = 8
2963 + Value = Some German Special Characters like ÖÄÜöäüß
2964 +
2965 + SQLType =SQL_TEXT
2966 + sub type = 0
2967 + Field Name = INCLEAR
2968 + Scale = 0
2969 + Charset id = 1
2970 + Nullable
2971 + Size = 16
2972 + Value = &Test
2973  
2974 +
2975 + SQLType =SQL_TEXT
2976 + sub type = 0
2977 + Field Name = FIXEDWIDTH
2978 + Scale = 0
2979 + Charset id = 4
2980 + Nullable
2981 + Size = 16
2982 + Value = É
2983 +
2984   Connection Character Set UTF8
2985   ROWID = 1
2986 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2987 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
2986 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
2987 > NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
2988   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)
2989   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)
2990 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
2991 < FIXEDWIDTH = C3 89  (Charset Id = 4 Codepage = 65001 Byte Length = 5)
2990 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
2991 > FIXEDWIDTH = C3 89  (Charset Id = 4 Codepage = 65001)
2992  
2993   Connection Character Set NONE
2994   ROWID = 1
2995 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2996 < NOTES = C9 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 21 Codepage = 28591 Byte Length = 10)
2995 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
2996 > NOTES = C9 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 21 Codepage = 28591)
2997   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)
2998   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)
2999 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3000 < FIXEDWIDTH = C3 89  (Charset Id = 4 Codepage = 65001 Byte Length = 5)
2999 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3000 > FIXEDWIDTH = C3 89  (Charset Id = 4 Codepage = 65001)
3001  
3002   Connection Character Set WIN1252
3003   ROWID = 1
3004 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 A9 80  (Charset Id = 53 Codepage = 1252 Byte Length = 12)
3005 < NOTES = C9 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 53 Codepage = 1252 Byte Length = 10)
3004 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 A9 80  (Charset Id = 53 Codepage = 1252)
3005 > NOTES = C9 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 53 Codepage = 1252)
3006   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)
3007   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)
3008 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3009 < FIXEDWIDTH = C9  (Charset Id = 53 Codepage = 1252 Byte Length = 4)
3008 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3009 > FIXEDWIDTH = C9  (Charset Id = 53 Codepage = 1252)
3010  
3011  
3012  
3013 + ------------------------------------------------------
3014   Running Test 13: Transaction over two databases
3015   Init Database 1
3016   ROWID = 1
3017 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001 Byte Length = 15)
3018 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
3017 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
3018 > NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
3019   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)
3020   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)
3021 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3021 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3022  
3023   Init Database 2
3024   ROWID = 1
3025 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001 Byte Length = 15)
3026 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
3025 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
3026 > NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
3027   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)
3028   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)
3029 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3029 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3030  
3031   ROWID = 1
3032 < TITLE = 44 61 74 61 62 61 73 65 31  (Charset Id = 4 Codepage = 65001 Byte Length = 9)
3033 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
3032 > TITLE = 44 61 74 61 62 61 73 65 31  (Charset Id = 4 Codepage = 65001)
3033 > NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
3034   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)
3035   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)
3036 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3036 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3037  
3038   ROWID = 1
3039 < TITLE = 44 61 74 61 62 61 73 65 32  (Charset Id = 4 Codepage = 65001 Byte Length = 9)
3040 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
3039 > TITLE = 44 61 74 61 62 61 73 65 32  (Charset Id = 4 Codepage = 65001)
3040 > NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
3041   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)
3042   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)
3043 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3043 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3044  
3045  
3046  
3047 + ------------------------------------------------------
3048   Running Test 14: Non select procedures
3049   Default Character set Name = UTF8
3050   Metadata
# Line 2547 | Line 3072 | Nullable
3072   Size = 128
3073  
3074   ROWID = 1
3075 < TITLE = Testing (Charset Id = 4 Codepage = 65001 Byte Length = 7)
3075 > TITLE = Testing (Charset Id = 4 Codepage = 65001)
3076  
3077   Repeat with a different execute transaction
3078  
3079   ROWID = 1
3080 < TITLE = Testing (Charset Id = 4 Codepage = 65001 Byte Length = 7)
3080 > TITLE = Testing (Charset Id = 4 Codepage = 65001)
3081  
3082   Repeat with a original transaction
3083  
3084   ROWID = 1
3085 < TITLE = Testing (Charset Id = 4 Codepage = 65001 Byte Length = 7)
3085 > TITLE = Testing (Charset Id = 4 Codepage = 65001)
3086  
3087  
3088 + ------------------------------------------------------
3089   Running Test 15: Blob Handling and BPBs
3090  
3091   Testdata
3092  
3093   ROWID = 1
3094 < TITLE = Blob Test (Charset Id = 4 Codepage = 65001 Byte Length = 9)
3094 > TITLE = Blob Test (Charset Id = 4 Codepage = 65001)
3095   BLOBDATA = (blob), Length = 92514
3096  
3097 + ROWID = 2
3098 + TITLE = Blob Test with binary string (Charset Id = 4 Codepage = 65001)
3099 + BLOBDATA = (blob), Length = 13
3100 + 0 9 A C9 63 6F 75 74 65 20 6D 6F 69
3101  
3102   Testdata 2
3103  
3104   ROWID = 1
3105 < TITLE = Blob Test (Charset Id = 4 Codepage = 65001 Byte Length = 9)
3105 > TITLE = Blob Test (Charset Id = 4 Codepage = 65001)
3106   BLOBDATA (Charset Id = 4 Codepage = 65001)
3107  
3108   Écoute moi
3109  
3110  
3111  
3112 + ------------------------------------------------------
3113   Running Test 16: Error handling
3114   Invalid Database Name Test
3115 < Error Handled:
3115 > Error Handled: SQLCODE: -902
3116 > Engine Code: 335544344 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3117   I/O error during "open" operation for file "Malformed Name"
2586 – -Error while trying to open file
2587 – -No such file or directory
3118   Invalid User Name Test
3119 < Error Handled:
3119 > Error Handled: SQLCODE: -902
3120 > Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3121   Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3122   Invalid password Test
3123 < Error Handled:
3123 > Error Handled: SQLCODE: -902
3124 > Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3125   Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3126   Invalid Prepare SQL Test
3127 < Error Handled:
3128 < Dynamic SQL Error
3129 < -SQL error code = -206
2598 < -Column unknown
2599 < -UNKNOWN_DATE
2600 < -At line 1, column 21 When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ?
3127 > Error Handled: SQLCODE: -206
3128 > Engine Code: 335544569 Column does not belong to referenced table
3129 > Dynamic SQL Error When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ?
3130   Invalid Open Cursor SQL Test
3131 < Error Handled:
3132 < Dynamic SQL Error
3133 < -SQL error code = -206
2605 < -Column unknown
2606 < -X
2607 < -At line 1, column 8 When Executing: Select X,count(*) As Counter from EMPLOYEE
3131 > Error Handled: SQLCODE: -206
3132 > Engine Code: 335544569 Column does not belong to referenced table
3133 > Dynamic SQL Error When Executing: Select X,count(*) As Counter from EMPLOYEE
3134   Transaction not started Test
3135   Error Handled: Transaction is not active
3136   Invalid Param SQL Type Test
3137   Error Handled: Field "EMP_NO" not found
3138   Case sensitive Param SQL  Test
3139   Error Handled: Field "EMP_NO" not found
3140 + Stale Reference Check
3141 + First test correct usage
3142 + COUNTER = 42
3143 +
3144 + New Transaction before param set
3145 + Error Handled: This interface is no longer up-to-date
3146 + New Transaction before Open Cursor
3147 + Error Handled: This interface is no longer up-to-date
3148 + Stop Stale Reference Checks
3149 + New Transaction before param set
3150 + COUNTER = 42
3151 +
3152 + New Transaction before Open Cursor
3153 + COUNTER = 42
3154 +
3155   Invalid Server Name Test
3156 < Error Handled:
3157 < Unable to complete network request to host "unknown".
3158 < -Failed to locate host machine
3156 > Error Handled: SQLCODE: -902
3157 > Engine Code: 335544721 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3158 > Unable to complete network request to host "unknown"
3159   Invalid User Name Test
3160 < Error Handled:
3160 > Error Handled: SQLCODE: -902
3161 > Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3162   Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3163   Invalid password Test
3164 < Error Handled:
3164 > Error Handled: SQLCODE: -902
3165 > Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3166   Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3167  
3168  
3169 + ------------------------------------------------------
3170 + Running Test 17: Date/Time tests and Firebird 4 extensions
3171 + FBVersion = Firebird/linux AMD64 (access method), version "LI-V2.5.9.27139 Firebird 2.5"
3172 + Has Local TZ DB = FALSE
3173 +
3174 + Testdata
3175 +
3176 + Metadata
3177 + SQLType =SQL_LONG
3178 + sub type = 0
3179 + Table = TESTDATA
3180 + Owner = SYSDBA
3181 + Column Name = ROWID
3182 + Alias Name = ROWID
3183 + Field Name = ROWID
3184 + Scale = 0
3185 + Charset id = 0
3186 + Not Null
3187 + Size = 4
3188 +
3189 + SQLType =SQL_TYPE_DATE
3190 + sub type = 0
3191 + Table = TESTDATA
3192 + Owner = SYSDBA
3193 + Column Name = DATECOL
3194 + Alias Name = DATECOL
3195 + Field Name = DATECOL
3196 + Scale = 0
3197 + Charset id = 0
3198 + Nullable
3199 + Size = 4
3200 +
3201 + SQLType =SQL_TYPE_TIME
3202 + sub type = 0
3203 + Table = TESTDATA
3204 + Owner = SYSDBA
3205 + Column Name = TIMECOL
3206 + Alias Name = TIMECOL
3207 + Field Name = TIMECOL
3208 + Scale = 0
3209 + Charset id = 0
3210 + Nullable
3211 + Size = 4
3212 +
3213 + SQLType =SQL_TIMESTAMP
3214 + sub type = 0
3215 + Table = TESTDATA
3216 + Owner = SYSDBA
3217 + Column Name = TIMESTAMPCOL
3218 + Alias Name = TIMESTAMPCOL
3219 + Field Name = TIMESTAMPCOL
3220 + Scale = 0
3221 + Charset id = 0
3222 + Nullable
3223 + Size = 8
3224 +
3225 + ROWID = 1
3226 + DATECOL = 2019/04/01
3227 + TIMECOL = 11:31:05.0001
3228 + TIMESTAMPCOL = 2016/02/29 22:02:35.0001
3229 + ROWID = 2
3230 + DATECOL = 1939/09/03
3231 + TIMECOL = 15:40:00.0002
3232 + TIMESTAMPCOL = 1918/11/11 11:11:00.0000
3233 + ROWID = 3
3234 + DATECOL = 1066/10/14
3235 + TIMECOL = 23:59:59.9994
3236 + TIMESTAMPCOL = 1918/11/11 11:11:00.0000
3237 + ROWID = 4
3238 + DATECOL = 1815/06/18
3239 + TIMECOL = 00:01:40.1115
3240 + TIMESTAMPCOL = 1945/05/08 22:10:00.0010
3241 +
3242 +
3243 + Testdata - second pass
3244 +
3245 + 1, 01/4/2019, 11:31:05, 29/2/2016 22:02:35
3246 + 2, 03/9/1939, 15:40:00.000, 11/11/1918 11:11:00
3247 + 3, 14/10/1066, 23:59:59.999, 11/11/1918 11:11:00
3248 + 4, 18/6/1815, 00:01:40.112, 08/5/1945 22:10:00
3249 + Sys Time = 1945, 5, 8, 2, 22, 10, 0, 1
3250 + Skipping Firebird 4 and later test part
3251 +
3252 +
3253 + ------------------------------------------------------
3254 + Running Test 18: Firebird 4 Decfloat extensions
3255 + FBVersion = Firebird/linux AMD64 (access method), version "LI-V2.5.9.27139 Firebird 2.5"
3256 + Skipping test for Firebird 4 and later
3257 +
3258 +
3259 + ------------------------------------------------------
3260 + Running Test 19: Batch Update and Insert Queries
3261 + Opening localhost:employee
3262 + Skipping test for Firebird 4 and later
3263 +
3264 +
3265 + ------------------------------------------------------
3266 + Running Test 20: Stress Test IBatch interface
3267 + FBVersion = Firebird/linux AMD64 (access method), version "LI-V2.5.9.27139 Firebird 2.5"
3268 + Skipping test for Firebird 4 and later
3269 +
3270 +
3271 + ------------------------------------------------------
3272 + Running Test 21: Exercise setting and getting of numeric data types
3273 + 1234.567 parsed to 1234567 scale = -3
3274 + As Float =  1.2345670000000000E+003
3275 + -765.4321 parsed to -7654321 scale = -4
3276 + As Float = -7.6543209999999999E+002
3277 + 0.1 parsed to 1 scale = -1
3278 + As Float =  1.0000000000000001E-001
3279 + 0.01 parsed to 1 scale = -2
3280 + As Float =  1.0000000000000000E-002
3281 + +123 parsed to 123 scale = 0
3282 + As Float =  1.2300000000000000E+002
3283 + 1.23456E308 parsed to 123456 scale = 303
3284 + As Float =  1.2345600000000001E+308
3285 + -1.2e-02 parsed to -12 scale = -3
3286 + As Float = -1.2000000000000000E-002
3287 + 10. parsed to 10 scale = 0
3288 + As Float =  1.0000000000000000E+001
3289 + .12 parsed to 12 scale = -2
3290 + As Float =  1.2000000000000000E-001
3291 + 0.12 parsed to 12 scale = -2
3292 + As Float =  1.2000000000000000E-001
3293 + Parsing of 1.2E1.2 failed
3294 + Parsing of 1,000 failed
3295 + Parsing of 1e1e1 failed
3296 + Parsing of 1.2+3 failed
3297 + Validating Numeric Interface - IFBNumeric
3298 + Value from Currency = 9999.1235
3299 + Raw Value = 99991235 Scale = -4
3300 + Value from Currency(rescaled) = 9999.12
3301 + Raw Value = 999912 Scale = -2
3302 + Value from Double = 9999.12345678
3303 + Raw Value = 999912345678 Scale = -8
3304 + Value from Integer = 9223372036854775807
3305 + Raw Value = 9223372036854775807 Scale = 0
3306 + Value from string = 9223372036854775807
3307 + Raw Value = 9223372036854775807 Scale = 0
3308 + Value from string = 9999.12345678
3309 + Raw Value = 999912345678 Scale = -8
3310 + Value from string = -0.12
3311 + Raw Value = -12 Scale = -3
3312 + Value from BCD = 9999.12345678
3313 + Raw Value = 999912345678 Scale = -8
3314 + Value from Raw Data = 9999123.456780
3315 + Raw Value = 9999123456780 Scale = -6
3316 + SQL Params
3317 + SQLType =SQL_LONG
3318 + sub type = 0
3319 + Field Name =
3320 + Scale = 0
3321 + Charset id = 0
3322 + Not Null
3323 + Size = 4
3324 + Value = 0
3325 +
3326 + SQLType =SQL_LONG
3327 + sub type = 0
3328 + Field Name =
3329 + Scale = 0
3330 + Charset id = 0
3331 + Nullable
3332 + Size = 4
3333 +
3334 + SQLType =SQL_INT64
3335 + sub type = 0
3336 + Field Name =
3337 + Scale = 0
3338 + Charset id = 0
3339 + Nullable
3340 + Size = 8
3341 +
3342 + SQLType =SQL_INT64
3343 + sub type = 0
3344 + Field Name =
3345 + Scale = -4
3346 + Charset id = 0
3347 + Nullable
3348 + Size = 8
3349 +
3350 + SQLType =SQL_DOUBLE
3351 + sub type = 0
3352 + Field Name =
3353 + Scale = 0
3354 + Charset id = 0
3355 + Nullable
3356 + Size = 8
3357 +
3358 + SQLType =SQL_INT64
3359 + sub type = 0
3360 + Field Name =
3361 + Scale = -6
3362 + Charset id = 0
3363 + Nullable
3364 + Size = 8
3365 +
3366 + Expected Error - SQLCODE: -303
3367 + Engine Code: 335544569 Incompatible column/host variable data type
3368 + Dynamic SQL Error
3369 + Expected Error - SQLCODE: -303
3370 + Engine Code: 335544569 Incompatible column/host variable data type
3371 + Dynamic SQL Error
3372 + Test Numeric Type
3373 + ROWID = 1
3374 + ITYPE = 101
3375 + I64TYPE = 9223372036854775807
3376 + CURRTYPE = 10,000.12340000
3377 + DTYPE = 9,999.12345678
3378 + FIXEDPOINT = 1,234,567,890.12345700
3379 + ROWID = 2
3380 + ITYPE = -32457
3381 + I64TYPE = -9223372036854775808
3382 + CURRTYPE = 1,000,001.12000000
3383 + DTYPE = 1.7E308
3384 + FIXEDPOINT = -1,234,567,890.12345700
3385 + ROWID = 3
3386 + ITYPE = 0
3387 + I64TYPE = 0
3388 + CURRTYPE = .00000000
3389 + DTYPE = .00000000
3390 + FIXEDPOINT = .00000000
3391 + ROWID = 4
3392 + ITYPE = 1
3393 + I64TYPE = 10
3394 + CURRTYPE = .02300000
3395 + DTYPE = .00110000
3396 + FIXEDPOINT = 233.45600000
3397 + ROWID = 7
3398 + ITYPE = 1
3399 + I64TYPE = 1234567
3400 + CURRTYPE = .02300000
3401 + DTYPE = .00110000
3402 + FIXEDPOINT = 1,234.25000000
3403 +
3404 +
3405 +
3406 + ------------------------------------------------------
3407 + Running Test 22: Journalling
3408 + Start Journaling. Session ID = 0
3409 + 1234.567 parsed to 1234567 scale = -3
3410 + As Float =  1.2345670000000000E+003
3411 + -765.4321 parsed to -7654321 scale = -4
3412 + As Float = -7.6543209999999999E+002
3413 + 0.1 parsed to 1 scale = -1
3414 + As Float =  1.0000000000000001E-001
3415 + 0.01 parsed to 1 scale = -2
3416 + As Float =  1.0000000000000000E-002
3417 + +123 parsed to 123 scale = 0
3418 + As Float =  1.2300000000000000E+002
3419 + 1.23456E308 parsed to 123456 scale = 303
3420 + As Float =  1.2345600000000001E+308
3421 + -1.2e-02 parsed to -12 scale = -3
3422 + As Float = -1.2000000000000000E-002
3423 + 10. parsed to 10 scale = 0
3424 + As Float =  1.0000000000000000E+001
3425 + .12 parsed to 12 scale = -2
3426 + As Float =  1.2000000000000000E-001
3427 + 0.12 parsed to 12 scale = -2
3428 + As Float =  1.2000000000000000E-001
3429 + Parsing of 1.2E1.2 failed
3430 + Parsing of 1,000 failed
3431 + Parsing of 1e1e1 failed
3432 + Parsing of 1.2+3 failed
3433 + SQL Params
3434 + SQLType =SQL_LONG
3435 + sub type = 0
3436 + Field Name =
3437 + Scale = 0
3438 + Charset id = 0
3439 + Not Null
3440 + Size = 4
3441 + Value = 0
3442 +
3443 + SQLType =SQL_LONG
3444 + sub type = 0
3445 + Field Name =
3446 + Scale = 0
3447 + Charset id = 0
3448 + Nullable
3449 + Size = 4
3450 +
3451 + SQLType =SQL_INT64
3452 + sub type = 0
3453 + Field Name =
3454 + Scale = 0
3455 + Charset id = 0
3456 + Nullable
3457 + Size = 8
3458 +
3459 + SQLType =SQL_INT64
3460 + sub type = 0
3461 + Field Name =
3462 + Scale = -4
3463 + Charset id = 0
3464 + Nullable
3465 + Size = 8
3466 +
3467 + SQLType =SQL_DOUBLE
3468 + sub type = 0
3469 + Field Name =
3470 + Scale = 0
3471 + Charset id = 0
3472 + Nullable
3473 + Size = 8
3474 +
3475 + SQLType =SQL_INT64
3476 + sub type = 0
3477 + Field Name =
3478 + Scale = -6
3479 + Charset id = 0
3480 + Nullable
3481 + Size = 8
3482 +
3483 +
3484 + Text Tests
3485 + SQL Params
3486 + SQLType =SQL_LONG
3487 + sub type = 0
3488 + Field Name =
3489 + Scale = 0
3490 + Charset id = 0
3491 + Not Null
3492 + Size = 4
3493 + Value = 0
3494 +
3495 + SQLType =SQL_VARYING
3496 + sub type = 0
3497 + Field Name =
3498 + Scale = 0
3499 + Charset id = 4
3500 + Nullable
3501 + Size = 1024
3502 +
3503 + SQLType =SQL_BLOB
3504 + sub type = 1
3505 + Field Name =
3506 + Scale = 0
3507 + Charset id = 4
3508 + Nullable
3509 + Size = 8
3510 +
3511 +
3512 + Binary Blob Tests
3513 +
3514 + Array Test
3515 + SQL Params
3516 + SQLType =SQL_LONG
3517 + sub type = 0
3518 + Field Name =
3519 + Scale = 0
3520 + Charset id = 0
3521 + Not Null
3522 + Size = 4
3523 + Value = 0
3524 +
3525 + SQLType =SQL_ARRAY
3526 + sub type = 0
3527 + Field Name =
3528 + Scale = 0
3529 + Charset id = 0
3530 + Nullable
3531 + Size = 8
3532 +
3533 + ROWID = 1
3534 + ITYPE = 101
3535 + I64TYPE = 9223372036854775807
3536 + CURRTYPE = 10,000.12340000
3537 + DTYPE = 9,999.12345678
3538 + FIXEDPOINT = 1,234,567,890.12345700
3539 + STR = NULL
3540 + TEXTBLOB = NULL
3541 + OTHERBLOB = NULL
3542 + MYARRAY = NULL
3543 + ROWID = 2
3544 + ITYPE = -32457
3545 + I64TYPE = -9223372036854775808
3546 + CURRTYPE = 1,000,001.12000000
3547 + DTYPE = 1.7E308
3548 + FIXEDPOINT = -1,234,567,890.12345700
3549 + STR = NULL
3550 + TEXTBLOB = NULL
3551 + OTHERBLOB = NULL
3552 + MYARRAY = NULL
3553 + ROWID = 4
3554 + ITYPE = 1
3555 + I64TYPE = 10
3556 + CURRTYPE = .02300000
3557 + DTYPE = .00110000
3558 + FIXEDPOINT = 233.45600000
3559 + STR = NULL
3560 + TEXTBLOB = NULL
3561 + OTHERBLOB = NULL
3562 + MYARRAY = NULL
3563 +
3564 + Journal Table
3565 + IBX$SESSIONID = 1
3566 + IBX$TRANSACTIONID = 8
3567 + IBX$OLDTRANSACTIONID = NULL
3568 + IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
3569 + IBX$CREATED = 2022/01/02 13:50:08.4510
3570 + IBX$SESSIONID = 1
3571 + IBX$TRANSACTIONID = 10
3572 + IBX$OLDTRANSACTIONID = 9
3573 + IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
3574 + IBX$CREATED = 2022/01/02 13:50:08.7550
3575 +
3576 + Journal Entries
3577 + Journal Entry = jeTransStart(Transaction Start)
3578 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3579 + Attachment ID = 2
3580 + Session ID = 1
3581 + Transaction ID = 8
3582 + Transaction Name = "Transaction_29_1"
3583 + TPB: Item Count = 3
3584 +  isc_tpb_write
3585 +  isc_tpb_nowait
3586 +  isc_tpb_concurrency
3587 +
3588 + Default Completion = TACommit
3589 +
3590 + Journal Entry = jeQuery(Query)
3591 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3592 + Attachment ID = 2
3593 + Session ID = 1
3594 + Transaction ID = 8
3595 + Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(1,101,9223372036854775807,10000.1234,9999.12345678,1234567890.12346)
3596 +
3597 + Journal Entry = jeQuery(Query)
3598 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3599 + Attachment ID = 2
3600 + Session ID = 1
3601 + Transaction ID = 8
3602 + Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(2,-32457,-9223372036854775808,1000001.12,1.7E308,-1234567890.12346)
3603 +
3604 + Journal Entry = jeTransCommitRet(Commit Retaining)
3605 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3606 + Attachment ID = 2
3607 + Session ID = 1
3608 + Transaction ID = 9
3609 + Old TransactionID = 8
3610 +
3611 + Journal Entry = jeQuery(Query)
3612 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3613 + Attachment ID = 2
3614 + Session ID = 1
3615 + Transaction ID = 9
3616 + Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(3,0,0,0,0,0)
3617 +
3618 + Journal Entry = jeTransRollbackRet(Rollback Retaining)
3619 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3620 + Attachment ID = 2
3621 + Session ID = 1
3622 + Transaction ID = 10
3623 + Old TransactionID = 9
3624 +
3625 + Journal Entry = jeQuery(Query)
3626 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3627 + Attachment ID = 2
3628 + Session ID = 1
3629 + Transaction ID = 10
3630 + Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(4,1,10,0.023,0.0011,233.456)
3631 +
3632 + Journal Entry = jeTransStart(Transaction Start)
3633 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3634 + Attachment ID = 2
3635 + Session ID = 1
3636 + Transaction ID = 11
3637 + Transaction Name = "Transaction_29_2"
3638 + TPB: Item Count = 3
3639 +  isc_tpb_write
3640 +  isc_tpb_nowait
3641 +  isc_tpb_concurrency
3642 +
3643 + Default Completion = TARollback
3644 +
3645 + Journal Entry = jeTransCommit(Commit)
3646 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3647 + Attachment ID = 2
3648 + Session ID = 1
3649 + Transaction ID = 10
3650 +
3651 + Journal Entry = jeQuery(Query)
3652 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3653 + Attachment ID = 2
3654 + Session ID = 1
3655 + Transaction ID = 11
3656 + Query = Insert into TestData(RowID, Str, TextBlob) Values(5,'It''s the quick brown fox jumps over the lazy dog','To be or not to be-that is the question:
3657 + Whether ''tis nobler in the mind to suffer
3658 + The slings and arrows of outrageous fortune,
3659 + Or to take arms against a sea of troubles,
3660 + And, by opposing, end them. To die, to sleep-
3661 + No more-and by a sleep to say we end
3662 + The heartache and the thousand natural shocks
3663 + That flesh is heir to-''tis a consummation
3664 + Devoutly to be wished. To die, to sleep-
3665 + To sleep, perchance to dream. Aye, there''s the rub,
3666 + For in that sleep of death what dreams may come,
3667 + When we have shuffled off this mortal coil,
3668 + Must give us pause. There''s the respect
3669 + That makes calamity of so long life.
3670 + For who would bear the whips and scorns of time,
3671 + Th'' oppressor''s wrong, the proud man''s contumely,
3672 + The pangs of despised love, the law’s delay,
3673 + The insolence of office, and the spurns
3674 + That patient merit of the unworthy takes,
3675 + When he himself might his quietus make
3676 + With a bare bodkin? Who would fardels bear,
3677 + To grunt and sweat under a weary life,
3678 + But that the dread of something after death,
3679 + The undiscovered country from whose bourn
3680 + No traveler returns, puzzles the will
3681 + And makes us rather bear those ills we have
3682 + Than fly to others that we know not of?
3683 + Thus conscience does make cowards of us all,
3684 + And thus the native hue of resolution
3685 + Is sicklied o''er with the pale cast of thought,
3686 + And enterprises of great pitch and moment,
3687 + With this regard their currents turn awry,
3688 + And lose the name of action.-Soft you now,
3689 + The fair Ophelia.-Nymph, in thy orisons
3690 + Be all my sins remembered
3691 + ')
3692 +
3693 + Journal Entry = jeQuery(Query)
3694 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3695 + Attachment ID = 2
3696 + Session ID = 1
3697 + Transaction ID = 11
3698 + Query = Insert into TestData(RowID,OtherBlob) Values (6,<blob subtype="0">
3699 + FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00
3700 + 0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300
3701 + 01000000010000001A01050001000000DA000000
3702 + </blob>
3703 + )
3704 +
3705 + Journal Entry = jeQuery(Query)
3706 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3707 + Attachment ID = 2
3708 + Session ID = 1
3709 + Transaction ID = 11
3710 + Query = Insert into TestData(RowID,MyArray) Values (7,<array dim = "1" sqltype = "496" length = "4" relation_name = "TESTDATA" column_name = "MYARRAY" scale = "0" bounds="0:16">
3711 + <elt ix="0">100</elt>
3712 + <elt ix="1">99</elt>
3713 + <elt ix="2">98</elt>
3714 + <elt ix="3">97</elt>
3715 + <elt ix="4">96</elt>
3716 + <elt ix="5">95</elt>
3717 + <elt ix="6">94</elt>
3718 + <elt ix="7">93</elt>
3719 + <elt ix="8">92</elt>
3720 + <elt ix="9">91</elt>
3721 + <elt ix="10">90</elt>
3722 + <elt ix="11">89</elt>
3723 + <elt ix="12">88</elt>
3724 + <elt ix="13">87</elt>
3725 + <elt ix="14">86</elt>
3726 + <elt ix="15">85</elt>
3727 + <elt ix="16">84</elt>
3728 + </array>
3729 + )
3730 +
3731 + Journal Entry = jeTransRollback(Rollback)
3732 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3733 + Attachment ID = 2
3734 + Session ID = 1
3735 + Transaction ID = 11
3736 +
3737 +
3738 +
3739 + ------------------------------------------------------
3740   Test Suite Ends

Diff Legend

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