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.
Revision 356 by tony, Sun Oct 24 14:00:52 2021 UTC

# Line 1 | Line 1
1   Firebird API Test Suite
2 < Copyright MWA Software 2016
2 > Copyright MWA Software 2016-2021
3  
4   Starting Tests
5   Client API Version = 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):
11 < unavailable database
10 > Create Database fails (as expected): I/O error during "open O_CREAT" operation for file ""
11 > -Error while trying to create file
12 > -No such file or directory
13   Creating a Database using an SQL Statement
14   Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus
15   SQL Dialect = 3
16 < DB Connect String = /tmp/fbintf-testsuite/testsuite1.fdb
16 > DB Connect String = localhost:/tmp/fbintf-testsuite/testsuite1.fdb
17   DB Charset ID = 0
18   DB SQL Dialect = 3
19   DB Remote Protocol = TCPv4
20   DB ODS Major Version = 11
21   DB ODS Minor Version = 2
22   User Authentication Method = Legacy_Auth
23 < Firebird Library Path = /opt/firebird2.5.9/lib/libfbclient.so
23 > Firebird Library Path = /opt/firebird2.5.9/lib/libfbembed.so
24   DB Client Implementation Version = 2.5
25 < DPB
26 < Count = 3
27 < 28 = SYSDBA
28 < 29 = masterkey
29 < 65 = 3
25 > DPB: Item Count = 3
26 >  isc_dpb_user_name = SYSDBA
27 >  isc_dpb_password = masterkey
28 >  isc_dpb_set_db_sql_dialect = 3
29 >
30 > Firebird Server Version Info
31 > Firebird/linux AMD64 (access method), version "LI-V2.5.9.27139 Firebird 2.5"
32 > Firebird/linux AMD64 (remote server), version "LI-V2.5.9.27139 Firebird 2.5/tcp (zeus)/P12"
33 > Firebird/linux AMD64 (remote interface), version "LI-V2.5.9.27139 Firebird 2.5/tcp (zeus)/P12"
34 > on disk structure version 11.2
35  
36   Dropping Database
37   Creating a Database with a DPD
38 < DB Connect String = /tmp/fbintf-testsuite/testsuite1.fdb
38 > DB Connect String = localhost:/tmp/fbintf-testsuite/testsuite1.fdb
39   DB Charset ID = 4
40   DB SQL Dialect = 3
41   DB Remote Protocol = TCPv4
42   DB ODS Major Version = 11
43   DB ODS Minor Version = 2
44   User Authentication Method = Legacy_Auth
45 < Firebird Library Path = /opt/firebird2.5.9/lib/libfbclient.so
45 > Firebird Library Path = /opt/firebird2.5.9/lib/libfbembed.so
46   DB Client Implementation Version = 2.5
47   Dropping Database
48 < DPB
49 < Count = 4
50 < 28 = SYSDBA
51 < 29 = masterkey
52 < 48 = UTF8
45 < 65 = 3
48 > DPB: Item Count = 4
49 >  isc_dpb_user_name = SYSDBA
50 >  isc_dpb_password = masterkey
51 >  isc_dpb_lc_ctype = UTF8
52 >  isc_dpb_set_db_sql_dialect = 3
53  
54   Creating a Database with a DPD
55   Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus
56   ODS major = 11
57   ODS minor = 2
58 < DB Connect String = /tmp/fbintf-testsuite/testsuite1.fdb
58 > DB Connect String = localhost:/tmp/fbintf-testsuite/testsuite1.fdb
59   DB Charset ID = 4
60   DB SQL Dialect = 3
61   DB Remote Protocol = TCPv4
62   DB ODS Major Version = 11
63   DB ODS Minor Version = 2
64   User Authentication Method = Legacy_Auth
65 < Firebird Library Path = /opt/firebird2.5.9/lib/libfbclient.so
65 > Firebird Library Path = /opt/firebird2.5.9/lib/libfbembed.so
66   DB Client Implementation Version = 2.5
67   RDB$DESCRIPTION =
68   RDB$RELATION_ID = 128
# Line 64 | Line 71 | RDB$CHARACTER_SET_NAME = UTF8
71   Dropping Database
72  
73  
74 + ------------------------------------------------------
75   Running Test 2: Open the employee database and run a query
76 + Open Database fails Your user name and password are not defined. Ask your database administrator to set up a Firebird login
77   Opening localhost:employee
78   Database Open, SQL Dialect = 3
79 + TPB: Item Count = 3
80 +  isc_tpb_read
81 +  isc_tpb_nowait
82 +  isc_tpb_concurrency
83 +
84 + Metadata
85 + SQLType =SQL_SHORT
86 + sub type = 0
87 + Table = EMPLOYEE
88 + Owner = SYSDBA
89 + Column Name = EMP_NO
90 + Alias Name = EMP_NO
91 + Field Name = EMP_NO
92 + Scale = 0
93 + Charset id = 0
94 + Not Null
95 + Size = 2
96 +
97 + SQLType =SQL_VARYING
98 + sub type = 0
99 + Table = EMPLOYEE
100 + Owner = SYSDBA
101 + Column Name = FIRST_NAME
102 + Alias Name = FIRST_NAME
103 + Field Name = FIRST_NAME
104 + Scale = 0
105 + Charset id = 0
106 + Not Null
107 + Size = 15
108 +
109 + SQLType =SQL_VARYING
110 + sub type = 0
111 + Table = EMPLOYEE
112 + Owner = SYSDBA
113 + Column Name = LAST_NAME
114 + Alias Name = LAST_NAME
115 + Field Name = LAST_NAME
116 + Scale = 0
117 + Charset id = 0
118 + Not Null
119 + Size = 20
120 +
121 + SQLType =SQL_VARYING
122 + sub type = 0
123 + Table = EMPLOYEE
124 + Owner = SYSDBA
125 + Column Name = PHONE_EXT
126 + Alias Name = PHONE_EXT
127 + Field Name = PHONE_EXT
128 + Scale = 0
129 + Charset id = 0
130 + Nullable
131 + Size = 4
132 +
133 + SQLType =SQL_TIMESTAMP
134 + sub type = 0
135 + Table = EMPLOYEE
136 + Owner = SYSDBA
137 + Column Name = HIRE_DATE
138 + Alias Name = HIRE_DATE
139 + Field Name = HIRE_DATE
140 + Scale = 0
141 + Charset id = 0
142 + Not Null
143 + Size = 8
144 +
145 + SQLType =SQL_TEXT
146 + sub type = 0
147 + Table = EMPLOYEE
148 + Owner = SYSDBA
149 + Column Name = DEPT_NO
150 + Alias Name = DEPT_NO
151 + Field Name = DEPT_NO
152 + Scale = 0
153 + Charset id = 0
154 + Not Null
155 + Size = 3
156 +
157 + SQLType =SQL_VARYING
158 + sub type = 0
159 + Table = EMPLOYEE
160 + Owner = SYSDBA
161 + Column Name = JOB_CODE
162 + Alias Name = JOB_CODE
163 + Field Name = JOB_CODE
164 + Scale = 0
165 + Charset id = 0
166 + Not Null
167 + Size = 5
168 +
169 + SQLType =SQL_SHORT
170 + sub type = 0
171 + Table = EMPLOYEE
172 + Owner = SYSDBA
173 + Column Name = JOB_GRADE
174 + Alias Name = JOB_GRADE
175 + Field Name = JOB_GRADE
176 + Scale = 0
177 + Charset id = 0
178 + Not Null
179 + Size = 2
180 +
181 + SQLType =SQL_VARYING
182 + sub type = 0
183 + Table = EMPLOYEE
184 + Owner = SYSDBA
185 + Column Name = JOB_COUNTRY
186 + Alias Name = JOB_COUNTRY
187 + Field Name = JOB_COUNTRY
188 + Scale = 0
189 + Charset id = 0
190 + Not Null
191 + Size = 15
192 +
193 + SQLType =SQL_INT64
194 + sub type = 0
195 + Table = EMPLOYEE
196 + Owner = SYSDBA
197 + Column Name = SALARY
198 + Alias Name = SALARY
199 + Field Name = SALARY
200 + Scale = -2
201 + Charset id = 0
202 + Not Null
203 + Size = 8
204 +
205 + SQLType =SQL_VARYING
206 + sub type = 0
207 + Table = EMPLOYEE
208 + Owner = SYSDBA
209 + Column Name = FULL_NAME
210 + Alias Name = FULL_NAME
211 + Field Name = FULL_NAME
212 + Scale = 0
213 + Charset id = 0
214 + Nullable
215 + Size = 37
216 +
217 + Plan =
218 + PLAN (EMPLOYEE NATURAL)
219 + -- SQL style inline comment
220 + /* this is a comment */ Select First 3 * from EMPLOYEE
221 +
222 + EMP_NO = 2
223 + FIRST_NAME = Robert
224 + LAST_NAME = Nelson
225 + PHONE_EXT = 250
226 + HIRE_DATE = 1988/12/28 00:00:00.0000
227 + DEPT_NO = 600
228 + JOB_CODE = VP
229 + JOB_GRADE = 2
230 + JOB_COUNTRY = USA
231 + SALARY = 105,900.00
232 + FULL_NAME = Nelson, Robert
233 + EMP_NO = 4
234 + FIRST_NAME = Bruce
235 + LAST_NAME = Young
236 + PHONE_EXT = 233
237 + HIRE_DATE = 1988/12/28 00:00:00.0000
238 + DEPT_NO = 621
239 + JOB_CODE = Eng
240 + JOB_GRADE = 2
241 + JOB_COUNTRY = USA
242 + SALARY = 97,500.00
243 + FULL_NAME = Young, Bruce
244 + EMP_NO = 5
245 + FIRST_NAME = Kim
246 + LAST_NAME = Lambert
247 + PHONE_EXT = 22
248 + HIRE_DATE = 1989/02/06 00:00:00.0000
249 + DEPT_NO = 130
250 + JOB_CODE = Eng
251 + JOB_GRADE = 2
252 + JOB_COUNTRY = USA
253 + SALARY = 102,750.00
254 + FULL_NAME = Lambert, Kim
255 +
256 + Select * from EMPLOYEE Where EMP_NO = ?
257 + SQL Params
258 + SQLType =SQL_SHORT
259 + sub type = 0
260 + Field Name =
261 + Scale = 0
262 + Charset id = 0
263 + Not Null
264 + Size = 2
265 + Value = 0
266 +
267 + EMP_NO = 8
268 + FIRST_NAME = Leslie
269 + LAST_NAME = Johnson
270 + PHONE_EXT = 410
271 + HIRE_DATE = 1989/04/05 00:00:00.0000
272 + DEPT_NO = 180
273 + JOB_CODE = Mktg
274 + JOB_GRADE = 3
275 + JOB_COUNTRY = USA
276 + SALARY = 64,635.00
277 + FULL_NAME = Johnson, Leslie
278 +
279 + With param names
280 + Select * from EMPLOYEE Where EMP_NO = :EMP_NO
281 + SQL Params
282 + SQLType =SQL_SHORT
283 + sub type = 0
284 + Field Name = EMP_NO
285 + Scale = 0
286 + Charset id = 0
287 + Not Null
288 + Size = 2
289 + Value = 0
290 +
291 + Results for Cursor: Test Cursor
292 + EMP_NO = 8
293 + FIRST_NAME = Leslie
294 + LAST_NAME = Johnson
295 + PHONE_EXT = 410
296 + HIRE_DATE = 1989/04/05 00:00:00.0000
297 + DEPT_NO = 180
298 + JOB_CODE = Mktg
299 + JOB_GRADE = 3
300 + JOB_COUNTRY = USA
301 + SALARY = 64,635.00
302 + FULL_NAME = Johnson, Leslie
303 +
304 + Now open the employee database as a local database
305 + TPB: Item Count = 3
306 +  isc_tpb_read
307 +  isc_tpb_nowait
308 +  isc_tpb_concurrency
309 +
310   Metadata
311   SQLType =SQL_SHORT
312   sub type = 0
# Line 209 | Line 449 | EMP_NO = 2
449   FIRST_NAME = Robert
450   LAST_NAME = Nelson
451   PHONE_EXT = 250
452 < HIRE_DATE = 28/12/1988 00:00:00.000
452 > HIRE_DATE = 1988/12/28 00:00:00.0000
453   DEPT_NO = 600
454   JOB_CODE = VP
455   JOB_GRADE = 2
# Line 220 | Line 460 | EMP_NO = 4
460   FIRST_NAME = Bruce
461   LAST_NAME = Young
462   PHONE_EXT = 233
463 < HIRE_DATE = 28/12/1988 00:00:00.000
463 > HIRE_DATE = 1988/12/28 00:00:00.0000
464   DEPT_NO = 621
465   JOB_CODE = Eng
466   JOB_GRADE = 2
# Line 231 | Line 471 | EMP_NO = 5
471   FIRST_NAME = Kim
472   LAST_NAME = Lambert
473   PHONE_EXT = 22
474 < HIRE_DATE = 6/2/1989 00:00:00.000
474 > HIRE_DATE = 1989/02/06 00:00:00.0000
475   DEPT_NO = 130
476   JOB_CODE = Eng
477   JOB_GRADE = 2
# Line 248 | Line 488 | Scale = 0
488   Charset id = 0
489   Not Null
490   Size = 2
491 + Value = 0
492  
493   EMP_NO = 8
494   FIRST_NAME = Leslie
495   LAST_NAME = Johnson
496   PHONE_EXT = 410
497 < HIRE_DATE = 5/4/1989 00:00:00.000
497 > HIRE_DATE = 1989/04/05 00:00:00.0000
498   DEPT_NO = 180
499   JOB_CODE = Mktg
500   JOB_GRADE = 3
# Line 271 | Line 512 | Scale = 0
512   Charset id = 0
513   Not Null
514   Size = 2
515 + Value = 0
516  
517 + Results for Cursor: Test Cursor
518   EMP_NO = 8
519   FIRST_NAME = Leslie
520   LAST_NAME = Johnson
521   PHONE_EXT = 410
522 < HIRE_DATE = 5/4/1989 00:00:00.000
522 > HIRE_DATE = 1989/04/05 00:00:00.0000
523   DEPT_NO = 180
524   JOB_CODE = Mktg
525   JOB_GRADE = 3
# Line 286 | Line 529 | FULL_NAME = Johnson, Leslie
529  
530  
531  
532 + ------------------------------------------------------
533   Running Test 3: ad hoc queries
534   Opening localhost:employee
535   Database Open
# Line 299 | Line 543 | Constrained Employee Count = 3
543   "Yanowski" Employee Count = 1
544  
545  
546 + ------------------------------------------------------
547   Running Test 4: Update, Insert and Delete Queries
548   Opening localhost:employee
549   Database Open
# Line 311 | Line 556 | EMP_NO = 8
556   FIRST_NAME = Leslie
557   LAST_NAME = Johnson
558   PHONE_EXT = 410
559 < HIRE_DATE = 5/4/1989 00:00:00.000
559 > HIRE_DATE = 1989/04/05 00:00:00.0000
560   DEPT_NO = 180
561   JOB_CODE = Mktg
562   JOB_GRADE = 3
# Line 319 | Line 564 | JOB_COUNTRY = USA
564   SALARY = 64,635.00
565   FULL_NAME = Johnson, Leslie
566  
567 < Current memory = 948664
568 < Delta memory = 1400
569 < Max memory = 992600
570 < Elapsed time= 0.002 sec
567 > Current memory = 948,496
568 > Delta memory = 1,288
569 > Max memory = 992,448
570 > Elapsed time= 0.001 sec
571   Cpu = 0.000 sec
572   Buffers = 75
573   Reads = 0
# Line 467 | Line 712 | EMP_NO = 150
712   FIRST_NAME = John
713   LAST_NAME = Doe
714   PHONE_EXT =
715 < HIRE_DATE = 1/4/2015 00:00:00.000
715 > HIRE_DATE = 2015/04/01 00:00:00.0000
716   DEPT_NO = 600
717   JOB_CODE = Eng
718   JOB_GRADE = 4
# Line 480 | Line 725 | EMP_NO = 151
725   FIRST_NAME = Major
726   LAST_NAME = Major
727   PHONE_EXT =
728 < HIRE_DATE = 1/4/2015 00:00:00.000
728 > HIRE_DATE = 2015/04/01 00:00:00.0000
729   DEPT_NO = 600
730   JOB_CODE = Eng
731   JOB_GRADE = 4
# Line 497 | Line 742 | EMP_NO = 150
742   FIRST_NAME = Jane
743   LAST_NAME = Doe
744   PHONE_EXT = NULL
745 < HIRE_DATE = 1/4/2015 00:00:00.000
745 > HIRE_DATE = 2015/04/01 00:00:00.0000
746   DEPT_NO = 600
747   JOB_CODE = Eng
748   JOB_GRADE = 4
# Line 514 | Line 759 | EMP_NO = 150
759   FIRST_NAME = Jayne's
760   LAST_NAME = Doe
761   PHONE_EXT = NULL
762 < HIRE_DATE = 1/4/2015 00:00:00.000
762 > HIRE_DATE = 2015/04/01 00:00:00.0000
763   DEPT_NO = 600
764   JOB_CODE = Eng
765   JOB_GRADE = 4
# Line 528 | Line 773 | EMP_NO = 8
773   FIRST_NAME = Leslie
774   LAST_NAME = Johnson
775   PHONE_EXT = 410
776 < HIRE_DATE = 5/4/1989 00:00:00.000
776 > HIRE_DATE = 1989/04/05 00:00:00.0000
777   DEPT_NO = 180
778   JOB_CODE = Mktg
779   JOB_GRADE = 3
# Line 542 | Line 787 | EMP_NO = 8
787   FIRST_NAME = Leslie
788   LAST_NAME = Johnson
789   PHONE_EXT = 410
790 < HIRE_DATE = 5/4/1989 00:00:00.000
790 > HIRE_DATE = 1989/04/05 00:00:00.0000
791   DEPT_NO = 180
792   JOB_CODE = Mktg
793   JOB_GRADE = 3
# Line 554 | Line 799 | EMP_NO = 9
799   FIRST_NAME = Phil
800   LAST_NAME = Forest
801   PHONE_EXT = 229
802 < HIRE_DATE = 17/4/1989 00:00:00.000
802 > HIRE_DATE = 1989/04/17 00:00:00.0000
803   DEPT_NO = 622
804   JOB_CODE = Mngr
805   JOB_GRADE = 3
# Line 568 | Line 813 | EMP_NO = 8
813   FIRST_NAME = Leslie
814   LAST_NAME = Johnson
815   PHONE_EXT = 410
816 < HIRE_DATE = 31/1/2015 00:00:00.000
816 > HIRE_DATE = 2015/01/31 00:00:00.0000
817   DEPT_NO = 180
818   JOB_CODE = Mktg
819   JOB_GRADE = 3
# Line 578 | Line 823 | FULL_NAME = Johnson, Leslie
823  
824  
825  
826 + ------------------------------------------------------
827   Running Test 5: Update Returning and Activity Check
828   Opening localhost:employee
829   Database Open
# Line 589 | Line 835 | EMP_NO = 8
835   FIRST_NAME = Leslie
836   LAST_NAME = Johnson
837   PHONE_EXT = 410
838 < HIRE_DATE = 31/1/2016 00:00:00.000
838 > HIRE_DATE = 2016/01/31 00:00:00.0000
839   DEPT_NO = 180
840   JOB_CODE = Mktg
841   JOB_GRADE = 3
# Line 611 | Line 857 | Transaction Active
857   Transaction inactive
858  
859  
860 + ------------------------------------------------------
861   Running Test 6: Blob Handling
862   Metadata
863   SQLType =SQL_TEXT
# Line 637 | Line 884 | Charset id = 0
884   Nullable
885   Size = 2
886  
887 < RDB$CHARACTER_SET_NAME = NONE (Charset Id = 4 Codepage = 65001 Byte Length = 31)
887 > RDB$CHARACTER_SET_NAME = NONE (Charset Id = 4 Codepage = 65001)
888   RDB$CHARACTER_SET_ID = 0
889 < RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 4 Codepage = 65001 Byte Length = 31)
889 > RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 4 Codepage = 65001)
890   RDB$CHARACTER_SET_ID = 1
891 < RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 4 Codepage = 65001 Byte Length = 31)
891 > RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 4 Codepage = 65001)
892   RDB$CHARACTER_SET_ID = 2
893 < RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 4 Codepage = 65001 Byte Length = 31)
893 > RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 4 Codepage = 65001)
894   RDB$CHARACTER_SET_ID = 3
895 < RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
895 > RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 4 Codepage = 65001)
896   RDB$CHARACTER_SET_ID = 4
897 < RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
897 > RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 4 Codepage = 65001)
898   RDB$CHARACTER_SET_ID = 5
899 < RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
899 > RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 4 Codepage = 65001)
900   RDB$CHARACTER_SET_ID = 6
901 < RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
901 > RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 4 Codepage = 65001)
902   RDB$CHARACTER_SET_ID = 9
903 < RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
903 > RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 4 Codepage = 65001)
904   RDB$CHARACTER_SET_ID = 10
905 < RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
905 > RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 4 Codepage = 65001)
906   RDB$CHARACTER_SET_ID = 11
907 < RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
907 > RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 4 Codepage = 65001)
908   RDB$CHARACTER_SET_ID = 12
909 < RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
909 > RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 4 Codepage = 65001)
910   RDB$CHARACTER_SET_ID = 13
911 < RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
911 > RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 4 Codepage = 65001)
912   RDB$CHARACTER_SET_ID = 14
913 < RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
913 > RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 4 Codepage = 65001)
914   RDB$CHARACTER_SET_ID = 15
915 < RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
915 > RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 4 Codepage = 65001)
916   RDB$CHARACTER_SET_ID = 16
917 < RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
917 > RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 4 Codepage = 65001)
918   RDB$CHARACTER_SET_ID = 17
919 < RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
919 > RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 4 Codepage = 65001)
920   RDB$CHARACTER_SET_ID = 18
921 < RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 4 Codepage = 65001 Byte Length = 31)
921 > RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 4 Codepage = 65001)
922   RDB$CHARACTER_SET_ID = 19
923 < RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
923 > RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 4 Codepage = 65001)
924   RDB$CHARACTER_SET_ID = 21
925 < RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
925 > RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 4 Codepage = 65001)
926   RDB$CHARACTER_SET_ID = 22
927 < RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
927 > RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 4 Codepage = 65001)
928   RDB$CHARACTER_SET_ID = 23
929 < RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
929 > RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 4 Codepage = 65001)
930   RDB$CHARACTER_SET_ID = 34
931 < RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
931 > RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 4 Codepage = 65001)
932   RDB$CHARACTER_SET_ID = 35
933 < RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
933 > RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 4 Codepage = 65001)
934   RDB$CHARACTER_SET_ID = 36
935 < RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
935 > RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 4 Codepage = 65001)
936   RDB$CHARACTER_SET_ID = 37
937 < RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
937 > RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 4 Codepage = 65001)
938   RDB$CHARACTER_SET_ID = 38
939 < RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
939 > RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 4 Codepage = 65001)
940   RDB$CHARACTER_SET_ID = 39
941 < RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
941 > RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 4 Codepage = 65001)
942   RDB$CHARACTER_SET_ID = 40
943 < RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
943 > RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 4 Codepage = 65001)
944   RDB$CHARACTER_SET_ID = 44
945 < RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
945 > RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 4 Codepage = 65001)
946   RDB$CHARACTER_SET_ID = 45
947 < RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
947 > RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 4 Codepage = 65001)
948   RDB$CHARACTER_SET_ID = 46
949 < RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
949 > RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 4 Codepage = 65001)
950   RDB$CHARACTER_SET_ID = 47
951 < RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
951 > RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 4 Codepage = 65001)
952   RDB$CHARACTER_SET_ID = 48
953 < RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
953 > RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 4 Codepage = 65001)
954   RDB$CHARACTER_SET_ID = 49
955 < RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 4 Codepage = 65001 Byte Length = 31)
955 > RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 4 Codepage = 65001)
956   RDB$CHARACTER_SET_ID = 50
957 < RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
957 > RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 4 Codepage = 65001)
958   RDB$CHARACTER_SET_ID = 51
959 < RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
959 > RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 4 Codepage = 65001)
960   RDB$CHARACTER_SET_ID = 52
961 < RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
961 > RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 4 Codepage = 65001)
962   RDB$CHARACTER_SET_ID = 53
963 < RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
963 > RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 4 Codepage = 65001)
964   RDB$CHARACTER_SET_ID = 54
965 < RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
965 > RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 4 Codepage = 65001)
966   RDB$CHARACTER_SET_ID = 55
967 < RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
967 > RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 4 Codepage = 65001)
968   RDB$CHARACTER_SET_ID = 56
969 < RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
969 > RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 4 Codepage = 65001)
970   RDB$CHARACTER_SET_ID = 57
971 < RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
971 > RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 4 Codepage = 65001)
972   RDB$CHARACTER_SET_ID = 58
973 < RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
973 > RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 4 Codepage = 65001)
974   RDB$CHARACTER_SET_ID = 59
975 < RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
975 > RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 4 Codepage = 65001)
976   RDB$CHARACTER_SET_ID = 60
977 < RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 4 Codepage = 65001 Byte Length = 31)
977 > RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 4 Codepage = 65001)
978   RDB$CHARACTER_SET_ID = 63
979 < RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 4 Codepage = 65001 Byte Length = 31)
979 > RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 4 Codepage = 65001)
980   RDB$CHARACTER_SET_ID = 64
981 < RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
981 > RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 4 Codepage = 65001)
982   RDB$CHARACTER_SET_ID = 65
983 < RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
983 > RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 4 Codepage = 65001)
984   RDB$CHARACTER_SET_ID = 66
985 < RDB$CHARACTER_SET_NAME = GBK (Charset Id = 4 Codepage = 65001 Byte Length = 31)
985 > RDB$CHARACTER_SET_NAME = GBK (Charset Id = 4 Codepage = 65001)
986   RDB$CHARACTER_SET_ID = 67
987 < RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 4 Codepage = 65001 Byte Length = 31)
987 > RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 4 Codepage = 65001)
988   RDB$CHARACTER_SET_ID = 68
989 < RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
989 > RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 4 Codepage = 65001)
990   RDB$CHARACTER_SET_ID = 69
991  
992   Metadata
# Line 819 | Line 1066 | Scale = 0
1066   Charset id = 0
1067   Not Null
1068   Size = 4
1069 + Value = 0
1070  
1071   SQLType =SQL_VARYING
1072   sub type = 0
# Line 847 | Line 1095 | Size = 8
1095   ROWID = 1
1096   FIXEDPOINT = 20.28
1097   FLOATINGPOINT = 3.14
1098 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
1098 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1099   BLOBDATA = NULL
1100  
1101   SQL Params
# Line 866 | Line 1114 | Scale = 0
1114   Charset id = 0
1115   Not Null
1116   Size = 4
1117 + Value = 0
1118  
1119   ROWID = 1
1120   FIXEDPOINT = 20.28
1121   FLOATINGPOINT = 3.14
1122 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
1122 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1123   BLOBDATA (Charset Id = 4 Codepage = 65001)
1124  
1125   To be or not to be-that is the question:
# Line 918 | Line 1167 | Scale = 0
1167   Charset id = 0
1168   Not Null
1169   Size = 4
1170 + Value = 0
1171  
1172   SQLType =SQL_VARYING
1173   sub type = 0
# Line 946 | Line 1196 | Size = 8
1196   ROWID = 1
1197   FIXEDPOINT = 20.28
1198   FLOATINGPOINT = 3.14
1199 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
1199 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1200   BLOBDATA (Charset Id = 4 Codepage = 65001)
1201  
1202   To be or not to be-that is the question:
# Line 988 | Line 1238 | Be all my sins remembered
1238   ROWID = 2
1239   FIXEDPOINT = NULL
1240   FLOATINGPOINT = NULL
1241 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
1241 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1242   BLOBDATA (Charset Id = 4 Codepage = 65001)
1243  
1244   To be or not to be-that is the question:
# Line 1113 | Line 1363 | Charset id = 0
1363   Nullable
1364   Size = 2
1365  
1366 < RDB$CHARACTER_SET_NAME = NONE (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1366 > RDB$CHARACTER_SET_NAME = NONE (Charset Id = 53 Codepage = 1252)
1367   RDB$CHARACTER_SET_ID = 0
1368 < RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1368 > RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 53 Codepage = 1252)
1369   RDB$CHARACTER_SET_ID = 1
1370 < RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1370 > RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 53 Codepage = 1252)
1371   RDB$CHARACTER_SET_ID = 2
1372 < RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1372 > RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 53 Codepage = 1252)
1373   RDB$CHARACTER_SET_ID = 3
1374 < RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1374 > RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 53 Codepage = 1252)
1375   RDB$CHARACTER_SET_ID = 4
1376 < RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1376 > RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 53 Codepage = 1252)
1377   RDB$CHARACTER_SET_ID = 5
1378 < RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1378 > RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 53 Codepage = 1252)
1379   RDB$CHARACTER_SET_ID = 6
1380 < RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1380 > RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 53 Codepage = 1252)
1381   RDB$CHARACTER_SET_ID = 9
1382 < RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1382 > RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 53 Codepage = 1252)
1383   RDB$CHARACTER_SET_ID = 10
1384 < RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1384 > RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 53 Codepage = 1252)
1385   RDB$CHARACTER_SET_ID = 11
1386 < RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1386 > RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 53 Codepage = 1252)
1387   RDB$CHARACTER_SET_ID = 12
1388 < RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1388 > RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 53 Codepage = 1252)
1389   RDB$CHARACTER_SET_ID = 13
1390 < RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1390 > RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 53 Codepage = 1252)
1391   RDB$CHARACTER_SET_ID = 14
1392 < RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1392 > RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 53 Codepage = 1252)
1393   RDB$CHARACTER_SET_ID = 15
1394 < RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1394 > RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 53 Codepage = 1252)
1395   RDB$CHARACTER_SET_ID = 16
1396 < RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1396 > RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 53 Codepage = 1252)
1397   RDB$CHARACTER_SET_ID = 17
1398 < RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1398 > RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 53 Codepage = 1252)
1399   RDB$CHARACTER_SET_ID = 18
1400 < RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1400 > RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 53 Codepage = 1252)
1401   RDB$CHARACTER_SET_ID = 19
1402 < RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1402 > RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 53 Codepage = 1252)
1403   RDB$CHARACTER_SET_ID = 21
1404 < RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1404 > RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 53 Codepage = 1252)
1405   RDB$CHARACTER_SET_ID = 22
1406 < RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1406 > RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 53 Codepage = 1252)
1407   RDB$CHARACTER_SET_ID = 23
1408 < RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1408 > RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 53 Codepage = 1252)
1409   RDB$CHARACTER_SET_ID = 34
1410 < RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1410 > RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 53 Codepage = 1252)
1411   RDB$CHARACTER_SET_ID = 35
1412 < RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1412 > RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 53 Codepage = 1252)
1413   RDB$CHARACTER_SET_ID = 36
1414 < RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1414 > RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 53 Codepage = 1252)
1415   RDB$CHARACTER_SET_ID = 37
1416 < RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1416 > RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 53 Codepage = 1252)
1417   RDB$CHARACTER_SET_ID = 38
1418 < RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1418 > RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 53 Codepage = 1252)
1419   RDB$CHARACTER_SET_ID = 39
1420 < RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1420 > RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 53 Codepage = 1252)
1421   RDB$CHARACTER_SET_ID = 40
1422 < RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1422 > RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 53 Codepage = 1252)
1423   RDB$CHARACTER_SET_ID = 44
1424 < RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1424 > RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 53 Codepage = 1252)
1425   RDB$CHARACTER_SET_ID = 45
1426 < RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1426 > RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 53 Codepage = 1252)
1427   RDB$CHARACTER_SET_ID = 46
1428 < RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1428 > RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 53 Codepage = 1252)
1429   RDB$CHARACTER_SET_ID = 47
1430 < RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1430 > RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 53 Codepage = 1252)
1431   RDB$CHARACTER_SET_ID = 48
1432 < RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1432 > RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 53 Codepage = 1252)
1433   RDB$CHARACTER_SET_ID = 49
1434 < RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1434 > RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 53 Codepage = 1252)
1435   RDB$CHARACTER_SET_ID = 50
1436 < RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1436 > RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 53 Codepage = 1252)
1437   RDB$CHARACTER_SET_ID = 51
1438 < RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1438 > RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 53 Codepage = 1252)
1439   RDB$CHARACTER_SET_ID = 52
1440 < RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1440 > RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 53 Codepage = 1252)
1441   RDB$CHARACTER_SET_ID = 53
1442 < RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1442 > RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 53 Codepage = 1252)
1443   RDB$CHARACTER_SET_ID = 54
1444 < RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1444 > RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 53 Codepage = 1252)
1445   RDB$CHARACTER_SET_ID = 55
1446 < RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1446 > RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 53 Codepage = 1252)
1447   RDB$CHARACTER_SET_ID = 56
1448 < RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1448 > RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 53 Codepage = 1252)
1449   RDB$CHARACTER_SET_ID = 57
1450 < RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1450 > RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 53 Codepage = 1252)
1451   RDB$CHARACTER_SET_ID = 58
1452 < RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1452 > RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 53 Codepage = 1252)
1453   RDB$CHARACTER_SET_ID = 59
1454 < RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1454 > RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 53 Codepage = 1252)
1455   RDB$CHARACTER_SET_ID = 60
1456 < RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1456 > RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 53 Codepage = 1252)
1457   RDB$CHARACTER_SET_ID = 63
1458 < RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1458 > RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 53 Codepage = 1252)
1459   RDB$CHARACTER_SET_ID = 64
1460 < RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1460 > RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 53 Codepage = 1252)
1461   RDB$CHARACTER_SET_ID = 65
1462 < RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1462 > RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 53 Codepage = 1252)
1463   RDB$CHARACTER_SET_ID = 66
1464 < RDB$CHARACTER_SET_NAME = GBK (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1464 > RDB$CHARACTER_SET_NAME = GBK (Charset Id = 53 Codepage = 1252)
1465   RDB$CHARACTER_SET_ID = 67
1466 < RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1466 > RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 53 Codepage = 1252)
1467   RDB$CHARACTER_SET_ID = 68
1468 < RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1468 > RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 53 Codepage = 1252)
1469   RDB$CHARACTER_SET_ID = 69
1470  
1471   Metadata
# Line 1295 | Line 1545 | Scale = 0
1545   Charset id = 0
1546   Not Null
1547   Size = 4
1548 + Value = 0
1549  
1550   SQLType =SQL_VARYING
1551   sub type = 0
# Line 1323 | Line 1574 | Size = 8
1574   ROWID = 1
1575   FIXEDPOINT = 20.28
1576   FLOATINGPOINT = 3.14
1577 < TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15)
1577 > TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1578   BLOBDATA = NULL
1579  
1580   SQL Params
# Line 1342 | Line 1593 | Scale = 0
1593   Charset id = 0
1594   Not Null
1595   Size = 4
1596 + Value = 0
1597  
1598   ROWID = 1
1599   FIXEDPOINT = 20.28
1600   FLOATINGPOINT = 3.14
1601 < TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15)
1601 > TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1602   BLOBDATA (Charset Id = 53 Codepage = 1252)
1603  
1604   To be or not to be-that is the question:
# Line 1394 | Line 1646 | Scale = 0
1646   Charset id = 0
1647   Not Null
1648   Size = 4
1649 + Value = 0
1650  
1651   SQLType =SQL_VARYING
1652   sub type = 0
# Line 1422 | Line 1675 | Size = 8
1675   ROWID = 1
1676   FIXEDPOINT = 20.28
1677   FLOATINGPOINT = 3.14
1678 < TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15)
1678 > TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1679   BLOBDATA (Charset Id = 53 Codepage = 1252)
1680  
1681   To be or not to be-that is the question:
# Line 1464 | Line 1717 | Be all my sins remembered
1717   ROWID = 2
1718   FIXEDPOINT = NULL
1719   FLOATINGPOINT = NULL
1720 < TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15)
1720 > TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1721   BLOBDATA (Charset Id = 53 Codepage = 1252)
1722  
1723   To be or not to be-that is the question:
# Line 1589 | Line 1842 | Charset id = 0
1842   Nullable
1843   Size = 2
1844  
1845 < RDB$CHARACTER_SET_NAME = NONE (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1845 > RDB$CHARACTER_SET_NAME = NONE (Charset Id = 3 Codepage = 65001)
1846   RDB$CHARACTER_SET_ID = 0
1847 < RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1847 > RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 3 Codepage = 65001)
1848   RDB$CHARACTER_SET_ID = 1
1849 < RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1849 > RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 3 Codepage = 65001)
1850   RDB$CHARACTER_SET_ID = 2
1851 < RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1851 > RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 3 Codepage = 65001)
1852   RDB$CHARACTER_SET_ID = 3
1853 < RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1853 > RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 3 Codepage = 65001)
1854   RDB$CHARACTER_SET_ID = 4
1855 < RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1855 > RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 3 Codepage = 65001)
1856   RDB$CHARACTER_SET_ID = 5
1857 < RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1857 > RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 3 Codepage = 65001)
1858   RDB$CHARACTER_SET_ID = 6
1859 < RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1859 > RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 3 Codepage = 65001)
1860   RDB$CHARACTER_SET_ID = 9
1861 < RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1861 > RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 3 Codepage = 65001)
1862   RDB$CHARACTER_SET_ID = 10
1863 < RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1863 > RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 3 Codepage = 65001)
1864   RDB$CHARACTER_SET_ID = 11
1865 < RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1865 > RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 3 Codepage = 65001)
1866   RDB$CHARACTER_SET_ID = 12
1867 < RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1867 > RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 3 Codepage = 65001)
1868   RDB$CHARACTER_SET_ID = 13
1869 < RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1869 > RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 3 Codepage = 65001)
1870   RDB$CHARACTER_SET_ID = 14
1871 < RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1871 > RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 3 Codepage = 65001)
1872   RDB$CHARACTER_SET_ID = 15
1873 < RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1873 > RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 3 Codepage = 65001)
1874   RDB$CHARACTER_SET_ID = 16
1875 < RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1875 > RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 3 Codepage = 65001)
1876   RDB$CHARACTER_SET_ID = 17
1877 < RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1877 > RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 3 Codepage = 65001)
1878   RDB$CHARACTER_SET_ID = 18
1879 < RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1879 > RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 3 Codepage = 65001)
1880   RDB$CHARACTER_SET_ID = 19
1881 < RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1881 > RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 3 Codepage = 65001)
1882   RDB$CHARACTER_SET_ID = 21
1883 < RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1883 > RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 3 Codepage = 65001)
1884   RDB$CHARACTER_SET_ID = 22
1885 < RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1885 > RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 3 Codepage = 65001)
1886   RDB$CHARACTER_SET_ID = 23
1887 < RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1887 > RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 3 Codepage = 65001)
1888   RDB$CHARACTER_SET_ID = 34
1889 < RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1889 > RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 3 Codepage = 65001)
1890   RDB$CHARACTER_SET_ID = 35
1891 < RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1891 > RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 3 Codepage = 65001)
1892   RDB$CHARACTER_SET_ID = 36
1893 < RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1893 > RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 3 Codepage = 65001)
1894   RDB$CHARACTER_SET_ID = 37
1895 < RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1895 > RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 3 Codepage = 65001)
1896   RDB$CHARACTER_SET_ID = 38
1897 < RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1897 > RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 3 Codepage = 65001)
1898   RDB$CHARACTER_SET_ID = 39
1899 < RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1899 > RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 3 Codepage = 65001)
1900   RDB$CHARACTER_SET_ID = 40
1901 < RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1901 > RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 3 Codepage = 65001)
1902   RDB$CHARACTER_SET_ID = 44
1903 < RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1903 > RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 3 Codepage = 65001)
1904   RDB$CHARACTER_SET_ID = 45
1905 < RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1905 > RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 3 Codepage = 65001)
1906   RDB$CHARACTER_SET_ID = 46
1907 < RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1907 > RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 3 Codepage = 65001)
1908   RDB$CHARACTER_SET_ID = 47
1909 < RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1909 > RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 3 Codepage = 65001)
1910   RDB$CHARACTER_SET_ID = 48
1911 < RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1911 > RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 3 Codepage = 65001)
1912   RDB$CHARACTER_SET_ID = 49
1913 < RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1913 > RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 3 Codepage = 65001)
1914   RDB$CHARACTER_SET_ID = 50
1915 < RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1915 > RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 3 Codepage = 65001)
1916   RDB$CHARACTER_SET_ID = 51
1917 < RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1917 > RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 3 Codepage = 65001)
1918   RDB$CHARACTER_SET_ID = 52
1919 < RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1919 > RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 3 Codepage = 65001)
1920   RDB$CHARACTER_SET_ID = 53
1921 < RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1921 > RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 3 Codepage = 65001)
1922   RDB$CHARACTER_SET_ID = 54
1923 < RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1923 > RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 3 Codepage = 65001)
1924   RDB$CHARACTER_SET_ID = 55
1925 < RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1925 > RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 3 Codepage = 65001)
1926   RDB$CHARACTER_SET_ID = 56
1927 < RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1927 > RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 3 Codepage = 65001)
1928   RDB$CHARACTER_SET_ID = 57
1929 < RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1929 > RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 3 Codepage = 65001)
1930   RDB$CHARACTER_SET_ID = 58
1931 < RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1931 > RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 3 Codepage = 65001)
1932   RDB$CHARACTER_SET_ID = 59
1933 < RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1933 > RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 3 Codepage = 65001)
1934   RDB$CHARACTER_SET_ID = 60
1935 < RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1935 > RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 3 Codepage = 65001)
1936   RDB$CHARACTER_SET_ID = 63
1937 < RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1937 > RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 3 Codepage = 65001)
1938   RDB$CHARACTER_SET_ID = 64
1939 < RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1939 > RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 3 Codepage = 65001)
1940   RDB$CHARACTER_SET_ID = 65
1941 < RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1941 > RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 3 Codepage = 65001)
1942   RDB$CHARACTER_SET_ID = 66
1943 < RDB$CHARACTER_SET_NAME = GBK (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1943 > RDB$CHARACTER_SET_NAME = GBK (Charset Id = 3 Codepage = 65001)
1944   RDB$CHARACTER_SET_ID = 67
1945 < RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1945 > RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 3 Codepage = 65001)
1946   RDB$CHARACTER_SET_ID = 68
1947 < RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1947 > RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 3 Codepage = 65001)
1948   RDB$CHARACTER_SET_ID = 69
1949  
1950   Metadata
# Line 1771 | Line 2024 | Scale = 0
2024   Charset id = 0
2025   Not Null
2026   Size = 4
2027 + Value = 0
2028  
2029   SQLType =SQL_VARYING
2030   sub type = 0
# Line 1799 | Line 2053 | Size = 8
2053   ROWID = 1
2054   FIXEDPOINT = 20.28
2055   FLOATINGPOINT = 3.14
2056 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2056 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2057   BLOBDATA = NULL
2058  
2059   SQL Params
# Line 1818 | Line 2072 | Scale = 0
2072   Charset id = 0
2073   Not Null
2074   Size = 4
2075 + Value = 0
2076  
2077   ROWID = 1
2078   FIXEDPOINT = 20.28
2079   FLOATINGPOINT = 3.14
2080 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2080 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2081   BLOBDATA (Charset Id = 4 Codepage = 65001)
2082  
2083   To be or not to be-that is the question:
# Line 1870 | Line 2125 | Scale = 0
2125   Charset id = 0
2126   Not Null
2127   Size = 4
2128 + Value = 0
2129  
2130   SQLType =SQL_VARYING
2131   sub type = 0
# Line 1898 | Line 2154 | Size = 8
2154   ROWID = 1
2155   FIXEDPOINT = 20.28
2156   FLOATINGPOINT = 3.14
2157 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2157 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2158   BLOBDATA (Charset Id = 4 Codepage = 65001)
2159  
2160   To be or not to be-that is the question:
# Line 1940 | Line 2196 | Be all my sins remembered
2196   ROWID = 2
2197   FIXEDPOINT = NULL
2198   FLOATINGPOINT = NULL
2199 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2199 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2200   BLOBDATA (Charset Id = 4 Codepage = 65001)
2201  
2202   To be or not to be-that is the question:
# Line 2042 | Line 2298 | Be all my sins remembered
2298  
2299  
2300  
2301 + ------------------------------------------------------
2302   Running Test 7: Create and read back an Array
2303   Metadata
2304   SQLType =SQL_LONG
# Line 2113 | Line 2370 | Column = MYARRAY
2370   Dimensions = 1
2371   Bounds: (0:16)
2372  
2373 + SQLType =SQL_ARRAY
2374 + sub type = 0
2375 + Table = TESTDATA
2376 + Owner = SYSDBA
2377 + Column Name = MYARRAY2
2378 + Alias Name = MYARRAY2
2379 + Field Name = MYARRAY2
2380 + Scale = 0
2381 + Charset id = 0
2382 + Nullable
2383 + Size = 8
2384 + Array Meta Data:
2385 + SQLType =SQL_TIMESTAMP
2386 + Scale = 0
2387 + Charset id = 0
2388 + Size = 8
2389 + Table = TESTDATA
2390 + Column = MYARRAY2
2391 + Dimensions = 1
2392 + Bounds: (0:16)
2393 +
2394 + SQLType =SQL_ARRAY
2395 + sub type = 0
2396 + Table = TESTDATA
2397 + Owner = SYSDBA
2398 + Column Name = MYARRAY3
2399 + Alias Name = MYARRAY3
2400 + Field Name = MYARRAY3
2401 + Scale = 0
2402 + Charset id = 0
2403 + Nullable
2404 + Size = 8
2405 + Array Meta Data:
2406 + SQLType =SQL_INT64
2407 + Scale = -2
2408 + Charset id = 0
2409 + Size = 8
2410 + Table = TESTDATA
2411 + Column = MYARRAY3
2412 + Dimensions = 1
2413 + Bounds: (0:16)
2414 +
2415   SQL Params
2416   SQLType =SQL_LONG
2417   sub type = 0
# Line 2121 | Line 2420 | Scale = 0
2420   Charset id = 0
2421   Not Null
2422   Size = 4
2423 + Value = 0
2424  
2425   SQLType =SQL_VARYING
2426   sub type = 0
# Line 2151 | Line 2451 | Param Name = TITLE
2451   Param Name = DATED
2452   Param Name = NOTES
2453   ROWID = 1
2454 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2455 < DATED = 1/4/2016 09:30:00.100
2456 < NOTES = Écoute moi (Charset Id = 4 Codepage = 65001 Byte Length = 11)
2454 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2455 > DATED = 2016/04/01 09:30:00.1000
2456 > NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
2457   MYARRAY = NULL
2458 + MYARRAY2 = NULL
2459 + MYARRAY3 = NULL
2460 +
2461 + SQL Params
2462 + SQLType =SQL_ARRAY
2463 + sub type = 0
2464 + Field Name = MYARRAY
2465 + Scale = 0
2466 + Charset id = 0
2467 + Nullable
2468 + Size = 8
2469 +
2470 + SQL Params
2471 + SQLType =SQL_ARRAY
2472 + sub type = 0
2473 + Field Name = MYARRAY2
2474 + Scale = 0
2475 + Charset id = 0
2476 + Nullable
2477 + Size = 8
2478  
2479   SQL Params
2480   SQLType =SQL_ARRAY
2481   sub type = 0
2482 + Field Name = MYARRAY3
2483 + Scale = 0
2484 + Charset id = 0
2485 + Nullable
2486 + Size = 8
2487 +
2488 + Metadata
2489 + SQLType =SQL_LONG
2490 + sub type = 0
2491 + Table = TESTDATA
2492 + Owner = SYSDBA
2493 + Column Name = ROWID
2494 + Alias Name = ROWID
2495 + Field Name = ROWID
2496 + Scale = 0
2497 + Charset id = 0
2498 + Not Null
2499 + Size = 4
2500 +
2501 + SQLType =SQL_VARYING
2502 + sub type = 0
2503 + Table = TESTDATA
2504 + Owner = SYSDBA
2505 + Column Name = TITLE
2506 + Alias Name = TITLE
2507 + Field Name = TITLE
2508 + Scale = 0
2509 + Charset id = 4
2510 + Nullable
2511 + Size = 128
2512 +
2513 + SQLType =SQL_TIMESTAMP
2514 + sub type = 0
2515 + Table = TESTDATA
2516 + Owner = SYSDBA
2517 + Column Name = DATED
2518 + Alias Name = DATED
2519 + Field Name = DATED
2520 + Scale = 0
2521 + Charset id = 0
2522 + Nullable
2523 + Size = 8
2524 +
2525 + SQLType =SQL_VARYING
2526 + sub type = 0
2527 + Table = TESTDATA
2528 + Owner = SYSDBA
2529 + Column Name = NOTES
2530 + Alias Name = NOTES
2531 + Field Name = NOTES
2532 + Scale = 0
2533 + Charset id = 4
2534 + Nullable
2535 + Size = 256
2536 +
2537 + SQLType =SQL_ARRAY
2538 + sub type = 0
2539 + Table = TESTDATA
2540 + Owner = SYSDBA
2541 + Column Name = MYARRAY
2542 + Alias Name = MYARRAY
2543   Field Name = MYARRAY
2544   Scale = 0
2545   Charset id = 0
2546   Nullable
2547   Size = 8
2548 + Array Meta Data:
2549 + SQLType =SQL_LONG
2550 + Scale = 0
2551 + Charset id = 0
2552 + Size = 4
2553 + Table = TESTDATA
2554 + Column = MYARRAY
2555 + Dimensions = 1
2556 + Bounds: (0:16)
2557 +
2558 + SQLType =SQL_ARRAY
2559 + sub type = 0
2560 + Table = TESTDATA
2561 + Owner = SYSDBA
2562 + Column Name = MYARRAY2
2563 + Alias Name = MYARRAY2
2564 + Field Name = MYARRAY2
2565 + Scale = 0
2566 + Charset id = 0
2567 + Nullable
2568 + Size = 8
2569 + Array Meta Data:
2570 + SQLType =SQL_TIMESTAMP
2571 + Scale = 0
2572 + Charset id = 0
2573 + Size = 8
2574 + Table = TESTDATA
2575 + Column = MYARRAY2
2576 + Dimensions = 1
2577 + Bounds: (0:16)
2578 +
2579 + SQLType =SQL_ARRAY
2580 + sub type = 0
2581 + Table = TESTDATA
2582 + Owner = SYSDBA
2583 + Column Name = MYARRAY3
2584 + Alias Name = MYARRAY3
2585 + Field Name = MYARRAY3
2586 + Scale = 0
2587 + Charset id = 0
2588 + Nullable
2589 + Size = 8
2590 + Array Meta Data:
2591 + SQLType =SQL_INT64
2592 + Scale = -2
2593 + Charset id = 0
2594 + Size = 8
2595 + Table = TESTDATA
2596 + Column = MYARRAY3
2597 + Dimensions = 1
2598 + Bounds: (0:16)
2599  
2600   ROWID = 1
2601 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2602 < DATED = 1/4/2016 09:30:00.100
2603 < NOTES = Écoute moi (Charset Id = 4 Codepage = 65001 Byte Length = 11)
2604 < 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)
2601 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2602 > DATED = 2016/04/01 09:30:00.1000
2603 > NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
2604 > 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)
2605 >
2606 > 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)
2607 >
2608 > MYARRAY3 = Array: (0: 0) (1: 1.04) (2: 2.09) (3: 3.15) (4: 4.19) (5: 5.25) (6: 6.3) (7: 7.34) (8: 8.39) (9: 9.44) (10: 10.5) (11: 11.55) (12: 12.6) (13: 13.64) (14: 0.42) (15: 42.45) (16: 4269)
2609 >
2610  
2611   Shrink to 2:10
2612   Array: (2: 98) (3: 97) (4: 96) (5: 95) (6: 94) (7: 93) (8: 92) (9: 91) (10: 90)
2613 +
2614   Write updated reduced slice
2615   Show update array
2616   ROWID = 1
2617 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2618 < DATED = 1/4/2016 09:30:00.100
2619 < NOTES = Écoute moi (Charset Id = 4 Codepage = 65001 Byte Length = 11)
2620 < 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)
2617 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2618 > DATED = 2016/04/01 09:30:00.1000
2619 > NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
2620 > 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)
2621  
2622 + 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)
2623  
2624 + MYARRAY3 = Array: (0: 0) (1: 1.04) (2: 2.09) (3: 3.15) (4: 4.19) (5: 5.25) (6: 6.3) (7: 7.34) (8: 8.39) (9: 9.44) (10: 10.5) (11: 11.55) (12: 12.6) (13: 13.64) (14: 0.42) (15: 42.45) (16: 4269)
2625  
2626 +
2627 +
2628 +
2629 + ------------------------------------------------------
2630   Running Test 8: Create and read back an Array with 2 dimensions
2631   Metadata
2632   SQLType =SQL_LONG
# Line 2238 | Line 2682 | Scale = 0
2682   Charset id = 0
2683   Not Null
2684   Size = 4
2685 + Value = 0
2686  
2687   SQLType =SQL_VARYING
2688   sub type = 0
# Line 2248 | Line 2693 | Nullable
2693   Size = 128
2694  
2695   ROWID = 1
2696 < TITLE = 2D Array (Charset Id = 4 Codepage = 65001 Byte Length = 8)
2696 > TITLE = 2D Array (Charset Id = 4 Codepage = 65001)
2697   MYARRAY = NULL
2698  
2699   ROWID = 1
2700 < TITLE = 2D Array (Charset Id = 4 Codepage = 65001 Byte Length = 8)
2701 < 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)
2700 > TITLE = 2D Array (Charset Id = 4 Codepage = 65001)
2701 > 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)
2702 >
2703  
2704  
2705  
2706 + ------------------------------------------------------
2707   Running Test 9: Database Information tests
2708   Database ID = 4 FB = /opt/firebird2.5.9/examples/empbuild/employee.fdb SN = zeus
2709   Pages =272
# Line 2273 | Line 2720 | Unknown Response 3
2720   Unknown Response 3
2721   Server Memory = 841392
2722   Forced Writes  = 1
2723 < Max Memory  = 879352
2723 > Max Memory  = 879288
2724   Num Buffers  = 75
2725   Sweep Interval  = 20000
2726   Logged in Users: SYSDBA,
# Line 2319 | Line 2766 | Update Count Operation Counts
2766   Page Size = 4096
2767  
2768  
2769 + ------------------------------------------------------
2770   Running Test 10: Event Handling
2771   Call Async Wait
2772   Async Wait Called
# Line 2342 | Line 2790 | Event Signalled
2790   Event Counts: TESTEVENT, Count = 2
2791  
2792  
2793 + ------------------------------------------------------
2794   Running Test 11: Services API
2795 + SPB: Item Count = 2
2796 +  user_name = SYSDBA
2797 +  password = masterkey
2798 +
2799   Service Manager Version = 2
2800   Server Version = LI-V2.5.9.27139 Firebird 2.5
2801   Implementation = Firebird/linux AMD64
# Line 2364 | Line 2817 | User ID = 0
2817   Group ID = 0
2818  
2819  
2820 < Licence Info:
2368 < feature is not supported
2820 > Licence Info: feature is not supported
2821   -feature is not supported
2822  
2823 < Licence Mask Info:
2372 < feature is not supported
2823 > Licence Mask Info: feature is not supported
2824  
2825   Capabilities = 260
2826  
# Line 2399 | Line 2850 | Database OK
2850   Database Dropped
2851  
2852  
2853 + ------------------------------------------------------
2854   Running Test 12: Character Sets
2855   SQL Params
2856   SQLType =SQL_LONG
# Line 2408 | Line 2860 | Scale = 0
2860   Charset id = 0
2861   Not Null
2862   Size = 4
2863 + Value = 0
2864  
2865   SQLType =SQL_VARYING
2866   sub type = 0
# Line 2457 | Line 2910 | Charset id = 4
2910   Nullable
2911   Size = 16
2912  
2913 + Show Param Values
2914 + SQL Params
2915 + SQLType =SQL_LONG
2916 + sub type = 0
2917 + Field Name = ROWID
2918 + Scale = 0
2919 + Charset id = 0
2920 + Not Null
2921 + Size = 4
2922 + Value = 1
2923 +
2924 + SQLType =SQL_TEXT
2925 + sub type = 0
2926 + Field Name = TITLE
2927 + Scale = 0
2928 + Charset id = 4
2929 + Nullable
2930 + Size = 128
2931 + Value = Blob Test ©€
2932 +
2933 + SQLType =SQL_TEXT
2934 + sub type = 0
2935 + Field Name = NOTES
2936 + Scale = 0
2937 + Charset id = 4
2938 + Nullable
2939 + Size = 256
2940 + Value = Écoute moi
2941 +
2942 + SQLType =SQL_TEXT
2943 + sub type = 0
2944 + Field Name = BLOBDATA
2945 + Scale = 0
2946 + Charset id = 1
2947 + Nullable
2948 + Size = 8
2949 + Value = Some German Special Characters like ÖÄÜöäüß
2950 +
2951 + SQLType =SQL_BLOB
2952 + sub type = 1
2953 + Field Name = BLOBDATA2
2954 + Scale = 0
2955 + Charset id = 4
2956 + Nullable
2957 + Size = 8
2958 + Value = Some German Special Characters like ÖÄÜöäüß
2959 +
2960 + SQLType =SQL_TEXT
2961 + sub type = 0
2962 + Field Name = INCLEAR
2963 + Scale = 0
2964 + Charset id = 1
2965 + Nullable
2966 + Size = 16
2967 + Value = &Test
2968  
2969 +
2970 + SQLType =SQL_TEXT
2971 + sub type = 0
2972 + Field Name = FIXEDWIDTH
2973 + Scale = 0
2974 + Charset id = 4
2975 + Nullable
2976 + Size = 16
2977 + Value = É
2978 +
2979   Connection Character Set UTF8
2980   ROWID = 1
2981 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2982 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
2981 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
2982 > NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
2983   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)
2984   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)
2985 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
2986 < FIXEDWIDTH = C3 89  (Charset Id = 4 Codepage = 65001 Byte Length = 5)
2985 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
2986 > FIXEDWIDTH = C3 89  (Charset Id = 4 Codepage = 65001)
2987  
2988   Connection Character Set NONE
2989   ROWID = 1
2990 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2991 < NOTES = C9 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 21 Codepage = 28591 Byte Length = 10)
2990 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
2991 > NOTES = C9 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 21 Codepage = 28591)
2992   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)
2993   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)
2994 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
2995 < FIXEDWIDTH = C3 89  (Charset Id = 4 Codepage = 65001 Byte Length = 5)
2994 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
2995 > FIXEDWIDTH = C3 89  (Charset Id = 4 Codepage = 65001)
2996  
2997   Connection Character Set WIN1252
2998   ROWID = 1
2999 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 A9 80  (Charset Id = 53 Codepage = 1252 Byte Length = 12)
3000 < NOTES = C9 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 53 Codepage = 1252 Byte Length = 10)
2999 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 A9 80  (Charset Id = 53 Codepage = 1252)
3000 > NOTES = C9 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 53 Codepage = 1252)
3001   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)
3002   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)
3003 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3004 < FIXEDWIDTH = C9  (Charset Id = 53 Codepage = 1252 Byte Length = 4)
3003 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3004 > FIXEDWIDTH = C9  (Charset Id = 53 Codepage = 1252)
3005  
3006  
3007  
3008 + ------------------------------------------------------
3009   Running Test 13: Transaction over two databases
3010   Init Database 1
3011   ROWID = 1
3012 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001 Byte Length = 15)
3013 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
3012 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
3013 > NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
3014   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)
3015   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)
3016 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3016 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3017  
3018   Init Database 2
3019   ROWID = 1
3020 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001 Byte Length = 15)
3021 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
3020 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
3021 > NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
3022   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)
3023   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)
3024 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3024 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3025  
3026   ROWID = 1
3027 < TITLE = 44 61 74 61 62 61 73 65 31  (Charset Id = 4 Codepage = 65001 Byte Length = 9)
3028 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
3027 > TITLE = 44 61 74 61 62 61 73 65 31  (Charset Id = 4 Codepage = 65001)
3028 > NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
3029   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)
3030   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)
3031 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3031 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3032  
3033   ROWID = 1
3034 < TITLE = 44 61 74 61 62 61 73 65 32  (Charset Id = 4 Codepage = 65001 Byte Length = 9)
3035 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
3034 > TITLE = 44 61 74 61 62 61 73 65 32  (Charset Id = 4 Codepage = 65001)
3035 > NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
3036   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)
3037   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)
3038 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3038 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3039  
3040  
3041  
3042 + ------------------------------------------------------
3043   Running Test 14: Non select procedures
3044   Default Character set Name = UTF8
3045   Metadata
# Line 2547 | Line 3067 | Nullable
3067   Size = 128
3068  
3069   ROWID = 1
3070 < TITLE = Testing (Charset Id = 4 Codepage = 65001 Byte Length = 7)
3070 > TITLE = Testing (Charset Id = 4 Codepage = 65001)
3071  
3072   Repeat with a different execute transaction
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 original 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  
3083 + ------------------------------------------------------
3084   Running Test 15: Blob Handling and BPBs
3085  
3086   Testdata
3087  
3088   ROWID = 1
3089 < TITLE = Blob Test (Charset Id = 4 Codepage = 65001 Byte Length = 9)
3089 > TITLE = Blob Test (Charset Id = 4 Codepage = 65001)
3090   BLOBDATA = (blob), Length = 92514
3091  
3092 + ROWID = 2
3093 + TITLE = Blob Test with binary string (Charset Id = 4 Codepage = 65001)
3094 + BLOBDATA = (blob), Length = 13
3095 + 0 9 A C9 63 6F 75 74 65 20 6D 6F 69
3096  
3097   Testdata 2
3098  
3099   ROWID = 1
3100 < TITLE = Blob Test (Charset Id = 4 Codepage = 65001 Byte Length = 9)
3100 > TITLE = Blob Test (Charset Id = 4 Codepage = 65001)
3101   BLOBDATA (Charset Id = 4 Codepage = 65001)
3102  
3103   Écoute moi
3104  
3105  
3106  
3107 + ------------------------------------------------------
3108   Running Test 16: Error handling
3109   Invalid Database Name Test
3110 < Error Handled:
2585 < I/O error during "open" operation for file "Malformed Name"
3110 > Error Handled: I/O error during "open" operation for file "Malformed Name"
3111   -Error while trying to open file
3112   -No such file or directory
3113   Invalid User Name Test
3114 < Error Handled:
2590 < Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3114 > Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3115   Invalid password Test
3116 < Error Handled:
2593 < Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3116 > Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3117   Invalid Prepare SQL Test
3118 < Error Handled:
2596 < Dynamic SQL Error
3118 > Error Handled: Dynamic SQL Error
3119   -SQL error code = -206
3120   -Column unknown
3121   -UNKNOWN_DATE
3122   -At line 1, column 21 When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ?
3123   Invalid Open Cursor SQL Test
3124 < Error Handled:
2603 < Dynamic SQL Error
3124 > Error Handled: Dynamic SQL Error
3125   -SQL error code = -206
3126   -Column unknown
3127   -X
# Line 2611 | Line 3132 | Invalid Param SQL Type Test
3132   Error Handled: Field "EMP_NO" not found
3133   Case sensitive Param SQL  Test
3134   Error Handled: Field "EMP_NO" not found
3135 + Stale Reference Check
3136 + First test correct usage
3137 + COUNTER = 42
3138 +
3139 + New Transaction before param set
3140 + Error Handled: This interface is no longer up-to-date
3141 + New Transaction before Open Cursor
3142 + Error Handled: This interface is no longer up-to-date
3143 + Stop Stale Reference Checks
3144 + New Transaction before param set
3145 + COUNTER = 42
3146 +
3147 + New Transaction before Open Cursor
3148 + COUNTER = 42
3149 +
3150   Invalid Server Name Test
3151 < Error Handled:
2616 < Unable to complete network request to host "unknown".
3151 > Error Handled: Unable to complete network request to host "unknown".
3152   -Failed to locate host machine
3153   Invalid User Name Test
3154 < Error Handled:
2620 < Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3154 > Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3155   Invalid password Test
3156 < Error Handled:
3157 < Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3156 > Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3157 >
3158 >
3159 > ------------------------------------------------------
3160 > Running Test 17: Date/Time tests and Firebird 4 extensions
3161 > FBVersion = Firebird/linux AMD64 (access method), version "LI-V2.5.9.27139 Firebird 2.5"
3162 > Has Local TZ DB = FALSE
3163 >
3164 > Testdata
3165 >
3166 > Metadata
3167 > SQLType =SQL_LONG
3168 > sub type = 0
3169 > Table = TESTDATA
3170 > Owner = SYSDBA
3171 > Column Name = ROWID
3172 > Alias Name = ROWID
3173 > Field Name = ROWID
3174 > Scale = 0
3175 > Charset id = 0
3176 > Not Null
3177 > Size = 4
3178 >
3179 > SQLType =SQL_TYPE_DATE
3180 > sub type = 0
3181 > Table = TESTDATA
3182 > Owner = SYSDBA
3183 > Column Name = DATECOL
3184 > Alias Name = DATECOL
3185 > Field Name = DATECOL
3186 > Scale = 0
3187 > Charset id = 0
3188 > Nullable
3189 > Size = 4
3190 >
3191 > SQLType =SQL_TYPE_TIME
3192 > sub type = 0
3193 > Table = TESTDATA
3194 > Owner = SYSDBA
3195 > Column Name = TIMECOL
3196 > Alias Name = TIMECOL
3197 > Field Name = TIMECOL
3198 > Scale = 0
3199 > Charset id = 0
3200 > Nullable
3201 > Size = 4
3202 >
3203 > SQLType =SQL_TIMESTAMP
3204 > sub type = 0
3205 > Table = TESTDATA
3206 > Owner = SYSDBA
3207 > Column Name = TIMESTAMPCOL
3208 > Alias Name = TIMESTAMPCOL
3209 > Field Name = TIMESTAMPCOL
3210 > Scale = 0
3211 > Charset id = 0
3212 > Nullable
3213 > Size = 8
3214 >
3215 > ROWID = 1
3216 > DATECOL = 2019/04/01
3217 > TIMECOL = 11:31:05.0001
3218 > TIMESTAMPCOL = 2016/02/29 22:02:35.0001
3219 > ROWID = 2
3220 > DATECOL = 1939/09/03
3221 > TIMECOL = 15:40:00.0002
3222 > TIMESTAMPCOL = 1918/11/11 11:11:00.0000
3223 > ROWID = 3
3224 > DATECOL = 1066/10/14
3225 > TIMECOL = 23:59:59.9994
3226 > TIMESTAMPCOL = 1918/11/11 11:11:00.0000
3227 > ROWID = 4
3228 > DATECOL = 1815/06/18
3229 > TIMECOL = 00:01:40.1115
3230 > TIMESTAMPCOL = 1945/05/08 22:10:00.0010
3231 >
3232 >
3233 > Testdata - second pass
3234 >
3235 > 1, 01/4/2019, 11:31:05, 29/2/2016 22:02:35
3236 > 2, 03/9/1939, 15:40:00.000, 11/11/1918 11:11:00
3237 > 3, 14/10/1066, 23:59:59.999, 11/11/1918 11:11:00
3238 > 4, 18/6/1815, 00:01:40.112, 08/5/1945 22:10:00
3239 > Sys Time = 1945, 5, 8, 2, 22, 10, 0, 1
3240 > Skipping Firebird 4 and later test part
3241 >
3242 >
3243 > ------------------------------------------------------
3244 > Running Test 18: Firebird 4 Decfloat extensions
3245 > FBVersion = Firebird/linux AMD64 (access method), version "LI-V2.5.9.27139 Firebird 2.5"
3246 > Skipping test for Firebird 4 and later
3247 >
3248 >
3249 > ------------------------------------------------------
3250 > Running Test 19: Batch Update and Insert Queries
3251 > Opening localhost:employee
3252 > Skipping test for Firebird 4 and later
3253 >
3254 >
3255 > ------------------------------------------------------
3256 > Running Test 20: Stress Test IBatch interface
3257 > FBVersion = Firebird/linux AMD64 (access method), version "LI-V2.5.9.27139 Firebird 2.5"
3258 > Skipping test for Firebird 4 and later
3259 >
3260 >
3261 > ------------------------------------------------------
3262 > Running Test 21: Exercise setting and getting of numeric data types
3263 > 1234.567 parsed to 1234567 scale = -3
3264 > As Float =  1.2345670000000000E+003
3265 > -765.4321 parsed to -7654321 scale = -4
3266 > As Float = -7.6543209999999999E+002
3267 > 0.1 parsed to 1 scale = -1
3268 > As Float =  1.0000000000000001E-001
3269 > 0.01 parsed to 1 scale = -2
3270 > As Float =  1.0000000000000000E-002
3271 > +123 parsed to 123 scale = 0
3272 > As Float =  1.2300000000000000E+002
3273 > 1.23456E308 parsed to 123456 scale = 303
3274 > As Float =  1.2345600000000001E+308
3275 > -1.2e-02 parsed to -12 scale = -3
3276 > As Float = -1.2000000000000000E-002
3277 > 10. parsed to 10 scale = 0
3278 > As Float =  1.0000000000000000E+001
3279 > .12 parsed to 12 scale = -2
3280 > As Float =  1.2000000000000000E-001
3281 > 0.12 parsed to 12 scale = -2
3282 > As Float =  1.2000000000000000E-001
3283 > Parsing of 1.2E1.2 failed
3284 > Parsing of 1,000 failed
3285 > Parsing of 1e1e1 failed
3286 > Parsing of 1.2+3 failed
3287 > SQL Params
3288 > SQLType =SQL_LONG
3289 > sub type = 0
3290 > Field Name =
3291 > Scale = 0
3292 > Charset id = 0
3293 > Not Null
3294 > Size = 4
3295 > Value = 0
3296 >
3297 > SQLType =SQL_LONG
3298 > sub type = 0
3299 > Field Name =
3300 > Scale = 0
3301 > Charset id = 0
3302 > Nullable
3303 > Size = 4
3304 >
3305 > SQLType =SQL_INT64
3306 > sub type = 0
3307 > Field Name =
3308 > Scale = 0
3309 > Charset id = 0
3310 > Nullable
3311 > Size = 8
3312 >
3313 > SQLType =SQL_INT64
3314 > sub type = 0
3315 > Field Name =
3316 > Scale = -4
3317 > Charset id = 0
3318 > Nullable
3319 > Size = 8
3320 >
3321 > SQLType =SQL_DOUBLE
3322 > sub type = 0
3323 > Field Name =
3324 > Scale = 0
3325 > Charset id = 0
3326 > Nullable
3327 > Size = 8
3328 >
3329 > SQLType =SQL_INT64
3330 > sub type = 0
3331 > Field Name =
3332 > Scale = -6
3333 > Charset id = 0
3334 > Nullable
3335 > Size = 8
3336 >
3337 > Expected Error - Dynamic SQL Error
3338 > -SQL error code = -303
3339 > -conversion error from string "1,000"
3340 > Expected Error - Dynamic SQL Error
3341 > -SQL error code = -303
3342 > -conversion error from string "10.0.0"
3343 > ROWID = 1
3344 > ITYPE = 101
3345 > I64TYPE = 9223372036854775807
3346 > CURRTYPE = 10,000.12340000
3347 > DTYPE = 9,999.12345678
3348 > FIXEDPOINT = 1,234,567,890.12345700
3349 > ROWID = 2
3350 > ITYPE = -32457
3351 > I64TYPE = -9223372036854775808
3352 > CURRTYPE = 1,000,001.12000000
3353 > DTYPE = 1.7E308
3354 > FIXEDPOINT = -1,234,567,890.12345700
3355 > ROWID = 3
3356 > ITYPE = 0
3357 > I64TYPE = 0
3358 > CURRTYPE = .00000000
3359 > DTYPE = .00000000
3360 > FIXEDPOINT = .00000000
3361 > ROWID = 4
3362 > ITYPE = 1
3363 > I64TYPE = 10
3364 > CURRTYPE = .02300000
3365 > DTYPE = .00110000
3366 > FIXEDPOINT = 233.45600000
3367 >
3368  
3369  
3370 + ------------------------------------------------------
3371   Test Suite Ends

Diff Legend

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