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

Comparing ibx/trunk/fbintf/testsuite/FB2reference.log (file contents):
Revision 344 by tony, Fri Feb 26 16:34:26 2021 UTC vs.
Revision 345 by tony, Mon Aug 23 14:22:29 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   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 + EMP_NO = 8
291 + FIRST_NAME = Leslie
292 + LAST_NAME = Johnson
293 + PHONE_EXT = 410
294 + HIRE_DATE = 1989/04/05 00:00:00.0000
295 + DEPT_NO = 180
296 + JOB_CODE = Mktg
297 + JOB_GRADE = 3
298 + JOB_COUNTRY = USA
299 + SALARY = 64,635.00
300 + FULL_NAME = Johnson, Leslie
301 +
302 + Now open the employee database as a local database
303 + TPB: Item Count = 3
304 +  isc_tpb_read
305 +  isc_tpb_nowait
306 +  isc_tpb_concurrency
307 +
308   Metadata
309   SQLType =SQL_SHORT
310   sub type = 0
# Line 209 | Line 447 | EMP_NO = 2
447   FIRST_NAME = Robert
448   LAST_NAME = Nelson
449   PHONE_EXT = 250
450 < HIRE_DATE = 28/12/1988 00:00:00.000
450 > HIRE_DATE = 1988/12/28 00:00:00.0000
451   DEPT_NO = 600
452   JOB_CODE = VP
453   JOB_GRADE = 2
# Line 220 | Line 458 | EMP_NO = 4
458   FIRST_NAME = Bruce
459   LAST_NAME = Young
460   PHONE_EXT = 233
461 < HIRE_DATE = 28/12/1988 00:00:00.000
461 > HIRE_DATE = 1988/12/28 00:00:00.0000
462   DEPT_NO = 621
463   JOB_CODE = Eng
464   JOB_GRADE = 2
# Line 231 | Line 469 | EMP_NO = 5
469   FIRST_NAME = Kim
470   LAST_NAME = Lambert
471   PHONE_EXT = 22
472 < HIRE_DATE = 6/2/1989 00:00:00.000
472 > HIRE_DATE = 1989/02/06 00:00:00.0000
473   DEPT_NO = 130
474   JOB_CODE = Eng
475   JOB_GRADE = 2
# Line 248 | Line 486 | Scale = 0
486   Charset id = 0
487   Not Null
488   Size = 2
489 + Value = 0
490  
491   EMP_NO = 8
492   FIRST_NAME = Leslie
493   LAST_NAME = Johnson
494   PHONE_EXT = 410
495 < HIRE_DATE = 5/4/1989 00:00:00.000
495 > HIRE_DATE = 1989/04/05 00:00:00.0000
496   DEPT_NO = 180
497   JOB_CODE = Mktg
498   JOB_GRADE = 3
# Line 271 | Line 510 | Scale = 0
510   Charset id = 0
511   Not Null
512   Size = 2
513 + Value = 0
514  
515   EMP_NO = 8
516   FIRST_NAME = Leslie
517   LAST_NAME = Johnson
518   PHONE_EXT = 410
519 < HIRE_DATE = 5/4/1989 00:00:00.000
519 > HIRE_DATE = 1989/04/05 00:00:00.0000
520   DEPT_NO = 180
521   JOB_CODE = Mktg
522   JOB_GRADE = 3
# Line 286 | Line 526 | FULL_NAME = Johnson, Leslie
526  
527  
528  
529 + ------------------------------------------------------
530   Running Test 3: ad hoc queries
531   Opening localhost:employee
532   Database Open
# Line 299 | Line 540 | Constrained Employee Count = 3
540   "Yanowski" Employee Count = 1
541  
542  
543 + ------------------------------------------------------
544   Running Test 4: Update, Insert and Delete Queries
545   Opening localhost:employee
546   Database Open
# Line 311 | Line 553 | EMP_NO = 8
553   FIRST_NAME = Leslie
554   LAST_NAME = Johnson
555   PHONE_EXT = 410
556 < HIRE_DATE = 5/4/1989 00:00:00.000
556 > HIRE_DATE = 1989/04/05 00:00:00.0000
557   DEPT_NO = 180
558   JOB_CODE = Mktg
559   JOB_GRADE = 3
# Line 319 | Line 561 | JOB_COUNTRY = USA
561   SALARY = 64,635.00
562   FULL_NAME = Johnson, Leslie
563  
564 < Current memory = 948664
565 < Delta memory = 1400
566 < Max memory = 992600
564 > Current memory = 948,560
565 > Delta memory = 1,400
566 > Max memory = 992,504
567   Elapsed time= 0.002 sec
568   Cpu = 0.000 sec
569   Buffers = 75
# Line 467 | Line 709 | EMP_NO = 150
709   FIRST_NAME = John
710   LAST_NAME = Doe
711   PHONE_EXT =
712 < HIRE_DATE = 1/4/2015 00:00:00.000
712 > HIRE_DATE = 2015/04/01 00:00:00.0000
713   DEPT_NO = 600
714   JOB_CODE = Eng
715   JOB_GRADE = 4
# Line 480 | Line 722 | EMP_NO = 151
722   FIRST_NAME = Major
723   LAST_NAME = Major
724   PHONE_EXT =
725 < HIRE_DATE = 1/4/2015 00:00:00.000
725 > HIRE_DATE = 2015/04/01 00:00:00.0000
726   DEPT_NO = 600
727   JOB_CODE = Eng
728   JOB_GRADE = 4
# Line 497 | Line 739 | EMP_NO = 150
739   FIRST_NAME = Jane
740   LAST_NAME = Doe
741   PHONE_EXT = NULL
742 < HIRE_DATE = 1/4/2015 00:00:00.000
742 > HIRE_DATE = 2015/04/01 00:00:00.0000
743   DEPT_NO = 600
744   JOB_CODE = Eng
745   JOB_GRADE = 4
# Line 514 | Line 756 | EMP_NO = 150
756   FIRST_NAME = Jayne's
757   LAST_NAME = Doe
758   PHONE_EXT = NULL
759 < HIRE_DATE = 1/4/2015 00:00:00.000
759 > HIRE_DATE = 2015/04/01 00:00:00.0000
760   DEPT_NO = 600
761   JOB_CODE = Eng
762   JOB_GRADE = 4
# Line 528 | Line 770 | EMP_NO = 8
770   FIRST_NAME = Leslie
771   LAST_NAME = Johnson
772   PHONE_EXT = 410
773 < HIRE_DATE = 5/4/1989 00:00:00.000
773 > HIRE_DATE = 1989/04/05 00:00:00.0000
774   DEPT_NO = 180
775   JOB_CODE = Mktg
776   JOB_GRADE = 3
# Line 542 | Line 784 | EMP_NO = 8
784   FIRST_NAME = Leslie
785   LAST_NAME = Johnson
786   PHONE_EXT = 410
787 < HIRE_DATE = 5/4/1989 00:00:00.000
787 > HIRE_DATE = 1989/04/05 00:00:00.0000
788   DEPT_NO = 180
789   JOB_CODE = Mktg
790   JOB_GRADE = 3
# Line 554 | Line 796 | EMP_NO = 9
796   FIRST_NAME = Phil
797   LAST_NAME = Forest
798   PHONE_EXT = 229
799 < HIRE_DATE = 17/4/1989 00:00:00.000
799 > HIRE_DATE = 1989/04/17 00:00:00.0000
800   DEPT_NO = 622
801   JOB_CODE = Mngr
802   JOB_GRADE = 3
# Line 568 | Line 810 | EMP_NO = 8
810   FIRST_NAME = Leslie
811   LAST_NAME = Johnson
812   PHONE_EXT = 410
813 < HIRE_DATE = 31/1/2015 00:00:00.000
813 > HIRE_DATE = 2015/01/31 00:00:00.0000
814   DEPT_NO = 180
815   JOB_CODE = Mktg
816   JOB_GRADE = 3
# Line 578 | Line 820 | FULL_NAME = Johnson, Leslie
820  
821  
822  
823 + ------------------------------------------------------
824   Running Test 5: Update Returning and Activity Check
825   Opening localhost:employee
826   Database Open
# Line 589 | Line 832 | EMP_NO = 8
832   FIRST_NAME = Leslie
833   LAST_NAME = Johnson
834   PHONE_EXT = 410
835 < HIRE_DATE = 31/1/2016 00:00:00.000
835 > HIRE_DATE = 2016/01/31 00:00:00.0000
836   DEPT_NO = 180
837   JOB_CODE = Mktg
838   JOB_GRADE = 3
# Line 611 | Line 854 | Transaction Active
854   Transaction inactive
855  
856  
857 + ------------------------------------------------------
858   Running Test 6: Blob Handling
859   Metadata
860   SQLType =SQL_TEXT
# Line 637 | Line 881 | Charset id = 0
881   Nullable
882   Size = 2
883  
884 < RDB$CHARACTER_SET_NAME = NONE (Charset Id = 4 Codepage = 65001 Byte Length = 31)
884 > RDB$CHARACTER_SET_NAME = NONE (Charset Id = 4 Codepage = 65001)
885   RDB$CHARACTER_SET_ID = 0
886 < RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 4 Codepage = 65001 Byte Length = 31)
886 > RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 4 Codepage = 65001)
887   RDB$CHARACTER_SET_ID = 1
888 < RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 4 Codepage = 65001 Byte Length = 31)
888 > RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 4 Codepage = 65001)
889   RDB$CHARACTER_SET_ID = 2
890 < RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 4 Codepage = 65001 Byte Length = 31)
890 > RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 4 Codepage = 65001)
891   RDB$CHARACTER_SET_ID = 3
892 < RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
892 > RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 4 Codepage = 65001)
893   RDB$CHARACTER_SET_ID = 4
894 < RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
894 > RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 4 Codepage = 65001)
895   RDB$CHARACTER_SET_ID = 5
896 < RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
896 > RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 4 Codepage = 65001)
897   RDB$CHARACTER_SET_ID = 6
898 < RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
898 > RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 4 Codepage = 65001)
899   RDB$CHARACTER_SET_ID = 9
900 < RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
900 > RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 4 Codepage = 65001)
901   RDB$CHARACTER_SET_ID = 10
902 < RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
902 > RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 4 Codepage = 65001)
903   RDB$CHARACTER_SET_ID = 11
904 < RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
904 > RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 4 Codepage = 65001)
905   RDB$CHARACTER_SET_ID = 12
906 < RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
906 > RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 4 Codepage = 65001)
907   RDB$CHARACTER_SET_ID = 13
908 < RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
908 > RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 4 Codepage = 65001)
909   RDB$CHARACTER_SET_ID = 14
910 < RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
910 > RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 4 Codepage = 65001)
911   RDB$CHARACTER_SET_ID = 15
912 < RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
912 > RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 4 Codepage = 65001)
913   RDB$CHARACTER_SET_ID = 16
914 < RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
914 > RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 4 Codepage = 65001)
915   RDB$CHARACTER_SET_ID = 17
916 < RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
916 > RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 4 Codepage = 65001)
917   RDB$CHARACTER_SET_ID = 18
918 < RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 4 Codepage = 65001 Byte Length = 31)
918 > RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 4 Codepage = 65001)
919   RDB$CHARACTER_SET_ID = 19
920 < RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
920 > RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 4 Codepage = 65001)
921   RDB$CHARACTER_SET_ID = 21
922 < RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
922 > RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 4 Codepage = 65001)
923   RDB$CHARACTER_SET_ID = 22
924 < RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
924 > RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 4 Codepage = 65001)
925   RDB$CHARACTER_SET_ID = 23
926 < RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
926 > RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 4 Codepage = 65001)
927   RDB$CHARACTER_SET_ID = 34
928 < RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
928 > RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 4 Codepage = 65001)
929   RDB$CHARACTER_SET_ID = 35
930 < RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
930 > RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 4 Codepage = 65001)
931   RDB$CHARACTER_SET_ID = 36
932 < RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
932 > RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 4 Codepage = 65001)
933   RDB$CHARACTER_SET_ID = 37
934 < RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
934 > RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 4 Codepage = 65001)
935   RDB$CHARACTER_SET_ID = 38
936 < RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
936 > RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 4 Codepage = 65001)
937   RDB$CHARACTER_SET_ID = 39
938 < RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
938 > RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 4 Codepage = 65001)
939   RDB$CHARACTER_SET_ID = 40
940 < RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
940 > RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 4 Codepage = 65001)
941   RDB$CHARACTER_SET_ID = 44
942 < RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
942 > RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 4 Codepage = 65001)
943   RDB$CHARACTER_SET_ID = 45
944 < RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
944 > RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 4 Codepage = 65001)
945   RDB$CHARACTER_SET_ID = 46
946 < RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
946 > RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 4 Codepage = 65001)
947   RDB$CHARACTER_SET_ID = 47
948 < RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
948 > RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 4 Codepage = 65001)
949   RDB$CHARACTER_SET_ID = 48
950 < RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
950 > RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 4 Codepage = 65001)
951   RDB$CHARACTER_SET_ID = 49
952 < RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 4 Codepage = 65001 Byte Length = 31)
952 > RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 4 Codepage = 65001)
953   RDB$CHARACTER_SET_ID = 50
954 < RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
954 > RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 4 Codepage = 65001)
955   RDB$CHARACTER_SET_ID = 51
956 < RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
956 > RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 4 Codepage = 65001)
957   RDB$CHARACTER_SET_ID = 52
958 < RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
958 > RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 4 Codepage = 65001)
959   RDB$CHARACTER_SET_ID = 53
960 < RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
960 > RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 4 Codepage = 65001)
961   RDB$CHARACTER_SET_ID = 54
962 < RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
962 > RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 4 Codepage = 65001)
963   RDB$CHARACTER_SET_ID = 55
964 < RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
964 > RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 4 Codepage = 65001)
965   RDB$CHARACTER_SET_ID = 56
966 < RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
966 > RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 4 Codepage = 65001)
967   RDB$CHARACTER_SET_ID = 57
968 < RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
968 > RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 4 Codepage = 65001)
969   RDB$CHARACTER_SET_ID = 58
970 < RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
970 > RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 4 Codepage = 65001)
971   RDB$CHARACTER_SET_ID = 59
972 < RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
972 > RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 4 Codepage = 65001)
973   RDB$CHARACTER_SET_ID = 60
974 < RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 4 Codepage = 65001 Byte Length = 31)
974 > RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 4 Codepage = 65001)
975   RDB$CHARACTER_SET_ID = 63
976 < RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 4 Codepage = 65001 Byte Length = 31)
976 > RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 4 Codepage = 65001)
977   RDB$CHARACTER_SET_ID = 64
978 < RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
978 > RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 4 Codepage = 65001)
979   RDB$CHARACTER_SET_ID = 65
980 < RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
980 > RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 4 Codepage = 65001)
981   RDB$CHARACTER_SET_ID = 66
982 < RDB$CHARACTER_SET_NAME = GBK (Charset Id = 4 Codepage = 65001 Byte Length = 31)
982 > RDB$CHARACTER_SET_NAME = GBK (Charset Id = 4 Codepage = 65001)
983   RDB$CHARACTER_SET_ID = 67
984 < RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 4 Codepage = 65001 Byte Length = 31)
984 > RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 4 Codepage = 65001)
985   RDB$CHARACTER_SET_ID = 68
986 < RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
986 > RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 4 Codepage = 65001)
987   RDB$CHARACTER_SET_ID = 69
988  
989   Metadata
# Line 819 | Line 1063 | Scale = 0
1063   Charset id = 0
1064   Not Null
1065   Size = 4
1066 + Value = 0
1067  
1068   SQLType =SQL_VARYING
1069   sub type = 0
# Line 847 | Line 1092 | Size = 8
1092   ROWID = 1
1093   FIXEDPOINT = 20.28
1094   FLOATINGPOINT = 3.14
1095 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
1095 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1096   BLOBDATA = NULL
1097  
1098   SQL Params
# Line 866 | Line 1111 | Scale = 0
1111   Charset id = 0
1112   Not Null
1113   Size = 4
1114 + Value = 0
1115  
1116   ROWID = 1
1117   FIXEDPOINT = 20.28
1118   FLOATINGPOINT = 3.14
1119 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
1119 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1120   BLOBDATA (Charset Id = 4 Codepage = 65001)
1121  
1122   To be or not to be-that is the question:
# Line 918 | Line 1164 | Scale = 0
1164   Charset id = 0
1165   Not Null
1166   Size = 4
1167 + Value = 0
1168  
1169   SQLType =SQL_VARYING
1170   sub type = 0
# Line 946 | Line 1193 | Size = 8
1193   ROWID = 1
1194   FIXEDPOINT = 20.28
1195   FLOATINGPOINT = 3.14
1196 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
1196 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1197   BLOBDATA (Charset Id = 4 Codepage = 65001)
1198  
1199   To be or not to be-that is the question:
# Line 988 | Line 1235 | Be all my sins remembered
1235   ROWID = 2
1236   FIXEDPOINT = NULL
1237   FLOATINGPOINT = NULL
1238 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
1238 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1239   BLOBDATA (Charset Id = 4 Codepage = 65001)
1240  
1241   To be or not to be-that is the question:
# Line 1113 | Line 1360 | Charset id = 0
1360   Nullable
1361   Size = 2
1362  
1363 < RDB$CHARACTER_SET_NAME = NONE (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1363 > RDB$CHARACTER_SET_NAME = NONE (Charset Id = 53 Codepage = 1252)
1364   RDB$CHARACTER_SET_ID = 0
1365 < RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1365 > RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 53 Codepage = 1252)
1366   RDB$CHARACTER_SET_ID = 1
1367 < RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1367 > RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 53 Codepage = 1252)
1368   RDB$CHARACTER_SET_ID = 2
1369 < RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1369 > RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 53 Codepage = 1252)
1370   RDB$CHARACTER_SET_ID = 3
1371 < RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1371 > RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 53 Codepage = 1252)
1372   RDB$CHARACTER_SET_ID = 4
1373 < RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1373 > RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 53 Codepage = 1252)
1374   RDB$CHARACTER_SET_ID = 5
1375 < RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1375 > RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 53 Codepage = 1252)
1376   RDB$CHARACTER_SET_ID = 6
1377 < RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1377 > RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 53 Codepage = 1252)
1378   RDB$CHARACTER_SET_ID = 9
1379 < RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1379 > RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 53 Codepage = 1252)
1380   RDB$CHARACTER_SET_ID = 10
1381 < RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1381 > RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 53 Codepage = 1252)
1382   RDB$CHARACTER_SET_ID = 11
1383 < RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1383 > RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 53 Codepage = 1252)
1384   RDB$CHARACTER_SET_ID = 12
1385 < RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1385 > RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 53 Codepage = 1252)
1386   RDB$CHARACTER_SET_ID = 13
1387 < RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1387 > RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 53 Codepage = 1252)
1388   RDB$CHARACTER_SET_ID = 14
1389 < RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1389 > RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 53 Codepage = 1252)
1390   RDB$CHARACTER_SET_ID = 15
1391 < RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1391 > RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 53 Codepage = 1252)
1392   RDB$CHARACTER_SET_ID = 16
1393 < RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1393 > RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 53 Codepage = 1252)
1394   RDB$CHARACTER_SET_ID = 17
1395 < RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1395 > RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 53 Codepage = 1252)
1396   RDB$CHARACTER_SET_ID = 18
1397 < RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1397 > RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 53 Codepage = 1252)
1398   RDB$CHARACTER_SET_ID = 19
1399 < RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1399 > RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 53 Codepage = 1252)
1400   RDB$CHARACTER_SET_ID = 21
1401 < RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1401 > RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 53 Codepage = 1252)
1402   RDB$CHARACTER_SET_ID = 22
1403 < RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1403 > RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 53 Codepage = 1252)
1404   RDB$CHARACTER_SET_ID = 23
1405 < RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1405 > RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 53 Codepage = 1252)
1406   RDB$CHARACTER_SET_ID = 34
1407 < RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1407 > RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 53 Codepage = 1252)
1408   RDB$CHARACTER_SET_ID = 35
1409 < RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1409 > RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 53 Codepage = 1252)
1410   RDB$CHARACTER_SET_ID = 36
1411 < RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1411 > RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 53 Codepage = 1252)
1412   RDB$CHARACTER_SET_ID = 37
1413 < RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1413 > RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 53 Codepage = 1252)
1414   RDB$CHARACTER_SET_ID = 38
1415 < RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1415 > RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 53 Codepage = 1252)
1416   RDB$CHARACTER_SET_ID = 39
1417 < RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1417 > RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 53 Codepage = 1252)
1418   RDB$CHARACTER_SET_ID = 40
1419 < RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1419 > RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 53 Codepage = 1252)
1420   RDB$CHARACTER_SET_ID = 44
1421 < RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1421 > RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 53 Codepage = 1252)
1422   RDB$CHARACTER_SET_ID = 45
1423 < RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1423 > RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 53 Codepage = 1252)
1424   RDB$CHARACTER_SET_ID = 46
1425 < RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1425 > RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 53 Codepage = 1252)
1426   RDB$CHARACTER_SET_ID = 47
1427 < RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1427 > RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 53 Codepage = 1252)
1428   RDB$CHARACTER_SET_ID = 48
1429 < RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1429 > RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 53 Codepage = 1252)
1430   RDB$CHARACTER_SET_ID = 49
1431 < RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1431 > RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 53 Codepage = 1252)
1432   RDB$CHARACTER_SET_ID = 50
1433 < RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1433 > RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 53 Codepage = 1252)
1434   RDB$CHARACTER_SET_ID = 51
1435 < RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1435 > RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 53 Codepage = 1252)
1436   RDB$CHARACTER_SET_ID = 52
1437 < RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1437 > RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 53 Codepage = 1252)
1438   RDB$CHARACTER_SET_ID = 53
1439 < RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1439 > RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 53 Codepage = 1252)
1440   RDB$CHARACTER_SET_ID = 54
1441 < RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1441 > RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 53 Codepage = 1252)
1442   RDB$CHARACTER_SET_ID = 55
1443 < RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1443 > RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 53 Codepage = 1252)
1444   RDB$CHARACTER_SET_ID = 56
1445 < RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1445 > RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 53 Codepage = 1252)
1446   RDB$CHARACTER_SET_ID = 57
1447 < RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1447 > RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 53 Codepage = 1252)
1448   RDB$CHARACTER_SET_ID = 58
1449 < RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1449 > RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 53 Codepage = 1252)
1450   RDB$CHARACTER_SET_ID = 59
1451 < RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1451 > RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 53 Codepage = 1252)
1452   RDB$CHARACTER_SET_ID = 60
1453 < RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1453 > RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 53 Codepage = 1252)
1454   RDB$CHARACTER_SET_ID = 63
1455 < RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1455 > RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 53 Codepage = 1252)
1456   RDB$CHARACTER_SET_ID = 64
1457 < RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1457 > RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 53 Codepage = 1252)
1458   RDB$CHARACTER_SET_ID = 65
1459 < RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1459 > RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 53 Codepage = 1252)
1460   RDB$CHARACTER_SET_ID = 66
1461 < RDB$CHARACTER_SET_NAME = GBK (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1461 > RDB$CHARACTER_SET_NAME = GBK (Charset Id = 53 Codepage = 1252)
1462   RDB$CHARACTER_SET_ID = 67
1463 < RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1463 > RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 53 Codepage = 1252)
1464   RDB$CHARACTER_SET_ID = 68
1465 < RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1465 > RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 53 Codepage = 1252)
1466   RDB$CHARACTER_SET_ID = 69
1467  
1468   Metadata
# Line 1295 | Line 1542 | Scale = 0
1542   Charset id = 0
1543   Not Null
1544   Size = 4
1545 + Value = 0
1546  
1547   SQLType =SQL_VARYING
1548   sub type = 0
# Line 1323 | Line 1571 | Size = 8
1571   ROWID = 1
1572   FIXEDPOINT = 20.28
1573   FLOATINGPOINT = 3.14
1574 < TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15)
1574 > TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1575   BLOBDATA = NULL
1576  
1577   SQL Params
# Line 1342 | Line 1590 | Scale = 0
1590   Charset id = 0
1591   Not Null
1592   Size = 4
1593 + Value = 0
1594  
1595   ROWID = 1
1596   FIXEDPOINT = 20.28
1597   FLOATINGPOINT = 3.14
1598 < TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15)
1598 > TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1599   BLOBDATA (Charset Id = 53 Codepage = 1252)
1600  
1601   To be or not to be-that is the question:
# Line 1394 | Line 1643 | Scale = 0
1643   Charset id = 0
1644   Not Null
1645   Size = 4
1646 + Value = 0
1647  
1648   SQLType =SQL_VARYING
1649   sub type = 0
# Line 1422 | Line 1672 | Size = 8
1672   ROWID = 1
1673   FIXEDPOINT = 20.28
1674   FLOATINGPOINT = 3.14
1675 < TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15)
1675 > TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1676   BLOBDATA (Charset Id = 53 Codepage = 1252)
1677  
1678   To be or not to be-that is the question:
# Line 1464 | Line 1714 | Be all my sins remembered
1714   ROWID = 2
1715   FIXEDPOINT = NULL
1716   FLOATINGPOINT = NULL
1717 < TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15)
1717 > TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1718   BLOBDATA (Charset Id = 53 Codepage = 1252)
1719  
1720   To be or not to be-that is the question:
# Line 1589 | Line 1839 | Charset id = 0
1839   Nullable
1840   Size = 2
1841  
1842 < RDB$CHARACTER_SET_NAME = NONE (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1842 > RDB$CHARACTER_SET_NAME = NONE (Charset Id = 3 Codepage = 65001)
1843   RDB$CHARACTER_SET_ID = 0
1844 < RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1844 > RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 3 Codepage = 65001)
1845   RDB$CHARACTER_SET_ID = 1
1846 < RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1846 > RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 3 Codepage = 65001)
1847   RDB$CHARACTER_SET_ID = 2
1848 < RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1848 > RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 3 Codepage = 65001)
1849   RDB$CHARACTER_SET_ID = 3
1850 < RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1850 > RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 3 Codepage = 65001)
1851   RDB$CHARACTER_SET_ID = 4
1852 < RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1852 > RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 3 Codepage = 65001)
1853   RDB$CHARACTER_SET_ID = 5
1854 < RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1854 > RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 3 Codepage = 65001)
1855   RDB$CHARACTER_SET_ID = 6
1856 < RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1856 > RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 3 Codepage = 65001)
1857   RDB$CHARACTER_SET_ID = 9
1858 < RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1858 > RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 3 Codepage = 65001)
1859   RDB$CHARACTER_SET_ID = 10
1860 < RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1860 > RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 3 Codepage = 65001)
1861   RDB$CHARACTER_SET_ID = 11
1862 < RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1862 > RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 3 Codepage = 65001)
1863   RDB$CHARACTER_SET_ID = 12
1864 < RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1864 > RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 3 Codepage = 65001)
1865   RDB$CHARACTER_SET_ID = 13
1866 < RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1866 > RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 3 Codepage = 65001)
1867   RDB$CHARACTER_SET_ID = 14
1868 < RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1868 > RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 3 Codepage = 65001)
1869   RDB$CHARACTER_SET_ID = 15
1870 < RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1870 > RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 3 Codepage = 65001)
1871   RDB$CHARACTER_SET_ID = 16
1872 < RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1872 > RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 3 Codepage = 65001)
1873   RDB$CHARACTER_SET_ID = 17
1874 < RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1874 > RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 3 Codepage = 65001)
1875   RDB$CHARACTER_SET_ID = 18
1876 < RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1876 > RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 3 Codepage = 65001)
1877   RDB$CHARACTER_SET_ID = 19
1878 < RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1878 > RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 3 Codepage = 65001)
1879   RDB$CHARACTER_SET_ID = 21
1880 < RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1880 > RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 3 Codepage = 65001)
1881   RDB$CHARACTER_SET_ID = 22
1882 < RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1882 > RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 3 Codepage = 65001)
1883   RDB$CHARACTER_SET_ID = 23
1884 < RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1884 > RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 3 Codepage = 65001)
1885   RDB$CHARACTER_SET_ID = 34
1886 < RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1886 > RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 3 Codepage = 65001)
1887   RDB$CHARACTER_SET_ID = 35
1888 < RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1888 > RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 3 Codepage = 65001)
1889   RDB$CHARACTER_SET_ID = 36
1890 < RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1890 > RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 3 Codepage = 65001)
1891   RDB$CHARACTER_SET_ID = 37
1892 < RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1892 > RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 3 Codepage = 65001)
1893   RDB$CHARACTER_SET_ID = 38
1894 < RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1894 > RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 3 Codepage = 65001)
1895   RDB$CHARACTER_SET_ID = 39
1896 < RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1896 > RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 3 Codepage = 65001)
1897   RDB$CHARACTER_SET_ID = 40
1898 < RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1898 > RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 3 Codepage = 65001)
1899   RDB$CHARACTER_SET_ID = 44
1900 < RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1900 > RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 3 Codepage = 65001)
1901   RDB$CHARACTER_SET_ID = 45
1902 < RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1902 > RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 3 Codepage = 65001)
1903   RDB$CHARACTER_SET_ID = 46
1904 < RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1904 > RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 3 Codepage = 65001)
1905   RDB$CHARACTER_SET_ID = 47
1906 < RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1906 > RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 3 Codepage = 65001)
1907   RDB$CHARACTER_SET_ID = 48
1908 < RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1908 > RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 3 Codepage = 65001)
1909   RDB$CHARACTER_SET_ID = 49
1910 < RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1910 > RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 3 Codepage = 65001)
1911   RDB$CHARACTER_SET_ID = 50
1912 < RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1912 > RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 3 Codepage = 65001)
1913   RDB$CHARACTER_SET_ID = 51
1914 < RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1914 > RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 3 Codepage = 65001)
1915   RDB$CHARACTER_SET_ID = 52
1916 < RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1916 > RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 3 Codepage = 65001)
1917   RDB$CHARACTER_SET_ID = 53
1918 < RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1918 > RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 3 Codepage = 65001)
1919   RDB$CHARACTER_SET_ID = 54
1920 < RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1920 > RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 3 Codepage = 65001)
1921   RDB$CHARACTER_SET_ID = 55
1922 < RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1922 > RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 3 Codepage = 65001)
1923   RDB$CHARACTER_SET_ID = 56
1924 < RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1924 > RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 3 Codepage = 65001)
1925   RDB$CHARACTER_SET_ID = 57
1926 < RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1926 > RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 3 Codepage = 65001)
1927   RDB$CHARACTER_SET_ID = 58
1928 < RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1928 > RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 3 Codepage = 65001)
1929   RDB$CHARACTER_SET_ID = 59
1930 < RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1930 > RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 3 Codepage = 65001)
1931   RDB$CHARACTER_SET_ID = 60
1932 < RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1932 > RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 3 Codepage = 65001)
1933   RDB$CHARACTER_SET_ID = 63
1934 < RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1934 > RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 3 Codepage = 65001)
1935   RDB$CHARACTER_SET_ID = 64
1936 < RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1936 > RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 3 Codepage = 65001)
1937   RDB$CHARACTER_SET_ID = 65
1938 < RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1938 > RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 3 Codepage = 65001)
1939   RDB$CHARACTER_SET_ID = 66
1940 < RDB$CHARACTER_SET_NAME = GBK (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1940 > RDB$CHARACTER_SET_NAME = GBK (Charset Id = 3 Codepage = 65001)
1941   RDB$CHARACTER_SET_ID = 67
1942 < RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1942 > RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 3 Codepage = 65001)
1943   RDB$CHARACTER_SET_ID = 68
1944 < RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1944 > RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 3 Codepage = 65001)
1945   RDB$CHARACTER_SET_ID = 69
1946  
1947   Metadata
# Line 1771 | Line 2021 | Scale = 0
2021   Charset id = 0
2022   Not Null
2023   Size = 4
2024 + Value = 0
2025  
2026   SQLType =SQL_VARYING
2027   sub type = 0
# Line 1799 | Line 2050 | Size = 8
2050   ROWID = 1
2051   FIXEDPOINT = 20.28
2052   FLOATINGPOINT = 3.14
2053 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2053 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2054   BLOBDATA = NULL
2055  
2056   SQL Params
# Line 1818 | Line 2069 | Scale = 0
2069   Charset id = 0
2070   Not Null
2071   Size = 4
2072 + Value = 0
2073  
2074   ROWID = 1
2075   FIXEDPOINT = 20.28
2076   FLOATINGPOINT = 3.14
2077 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2077 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2078   BLOBDATA (Charset Id = 4 Codepage = 65001)
2079  
2080   To be or not to be-that is the question:
# Line 1870 | Line 2122 | Scale = 0
2122   Charset id = 0
2123   Not Null
2124   Size = 4
2125 + Value = 0
2126  
2127   SQLType =SQL_VARYING
2128   sub type = 0
# Line 1898 | Line 2151 | Size = 8
2151   ROWID = 1
2152   FIXEDPOINT = 20.28
2153   FLOATINGPOINT = 3.14
2154 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2154 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2155   BLOBDATA (Charset Id = 4 Codepage = 65001)
2156  
2157   To be or not to be-that is the question:
# Line 1940 | Line 2193 | Be all my sins remembered
2193   ROWID = 2
2194   FIXEDPOINT = NULL
2195   FLOATINGPOINT = NULL
2196 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2196 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2197   BLOBDATA (Charset Id = 4 Codepage = 65001)
2198  
2199   To be or not to be-that is the question:
# Line 2042 | Line 2295 | Be all my sins remembered
2295  
2296  
2297  
2298 + ------------------------------------------------------
2299   Running Test 7: Create and read back an Array
2300   Metadata
2301   SQLType =SQL_LONG
# Line 2113 | Line 2367 | Column = MYARRAY
2367   Dimensions = 1
2368   Bounds: (0:16)
2369  
2370 + SQLType =SQL_ARRAY
2371 + sub type = 0
2372 + Table = TESTDATA
2373 + Owner = SYSDBA
2374 + Column Name = MYARRAY2
2375 + Alias Name = MYARRAY2
2376 + Field Name = MYARRAY2
2377 + Scale = 0
2378 + Charset id = 0
2379 + Nullable
2380 + Size = 8
2381 + Array Meta Data:
2382 + SQLType =SQL_TIMESTAMP
2383 + Scale = 0
2384 + Charset id = 0
2385 + Size = 8
2386 + Table = TESTDATA
2387 + Column = MYARRAY2
2388 + Dimensions = 1
2389 + Bounds: (0:16)
2390 +
2391 + SQLType =SQL_ARRAY
2392 + sub type = 0
2393 + Table = TESTDATA
2394 + Owner = SYSDBA
2395 + Column Name = MYARRAY3
2396 + Alias Name = MYARRAY3
2397 + Field Name = MYARRAY3
2398 + Scale = 0
2399 + Charset id = 0
2400 + Nullable
2401 + Size = 8
2402 + Array Meta Data:
2403 + SQLType =SQL_INT64
2404 + Scale = -2
2405 + Charset id = 0
2406 + Size = 8
2407 + Table = TESTDATA
2408 + Column = MYARRAY3
2409 + Dimensions = 1
2410 + Bounds: (0:16)
2411 +
2412   SQL Params
2413   SQLType =SQL_LONG
2414   sub type = 0
# Line 2121 | Line 2417 | Scale = 0
2417   Charset id = 0
2418   Not Null
2419   Size = 4
2420 + Value = 0
2421  
2422   SQLType =SQL_VARYING
2423   sub type = 0
# Line 2151 | Line 2448 | Param Name = TITLE
2448   Param Name = DATED
2449   Param Name = NOTES
2450   ROWID = 1
2451 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2452 < DATED = 1/4/2016 09:30:00.100
2453 < NOTES = Écoute moi (Charset Id = 4 Codepage = 65001 Byte Length = 11)
2451 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2452 > DATED = 2016/04/01 09:30:00.1000
2453 > NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
2454   MYARRAY = NULL
2455 + MYARRAY2 = NULL
2456 + MYARRAY3 = NULL
2457  
2458   SQL Params
2459   SQLType =SQL_ARRAY
# Line 2165 | Line 2464 | Charset id = 0
2464   Nullable
2465   Size = 8
2466  
2467 + SQL Params
2468 + SQLType =SQL_ARRAY
2469 + sub type = 0
2470 + Field Name = MYARRAY2
2471 + Scale = 0
2472 + Charset id = 0
2473 + Nullable
2474 + Size = 8
2475 +
2476 + SQL Params
2477 + SQLType =SQL_ARRAY
2478 + sub type = 0
2479 + Field Name = MYARRAY3
2480 + Scale = 0
2481 + Charset id = 0
2482 + Nullable
2483 + Size = 8
2484 +
2485 + Metadata
2486 + SQLType =SQL_LONG
2487 + sub type = 0
2488 + Table = TESTDATA
2489 + Owner = SYSDBA
2490 + Column Name = ROWID
2491 + Alias Name = ROWID
2492 + Field Name = ROWID
2493 + Scale = 0
2494 + Charset id = 0
2495 + Not Null
2496 + Size = 4
2497 +
2498 + SQLType =SQL_VARYING
2499 + sub type = 0
2500 + Table = TESTDATA
2501 + Owner = SYSDBA
2502 + Column Name = TITLE
2503 + Alias Name = TITLE
2504 + Field Name = TITLE
2505 + Scale = 0
2506 + Charset id = 4
2507 + Nullable
2508 + Size = 128
2509 +
2510 + SQLType =SQL_TIMESTAMP
2511 + sub type = 0
2512 + Table = TESTDATA
2513 + Owner = SYSDBA
2514 + Column Name = DATED
2515 + Alias Name = DATED
2516 + Field Name = DATED
2517 + Scale = 0
2518 + Charset id = 0
2519 + Nullable
2520 + Size = 8
2521 +
2522 + SQLType =SQL_VARYING
2523 + sub type = 0
2524 + Table = TESTDATA
2525 + Owner = SYSDBA
2526 + Column Name = NOTES
2527 + Alias Name = NOTES
2528 + Field Name = NOTES
2529 + Scale = 0
2530 + Charset id = 4
2531 + Nullable
2532 + Size = 256
2533 +
2534 + SQLType =SQL_ARRAY
2535 + sub type = 0
2536 + Table = TESTDATA
2537 + Owner = SYSDBA
2538 + Column Name = MYARRAY
2539 + Alias Name = MYARRAY
2540 + Field Name = MYARRAY
2541 + Scale = 0
2542 + Charset id = 0
2543 + Nullable
2544 + Size = 8
2545 + Array Meta Data:
2546 + SQLType =SQL_LONG
2547 + Scale = 0
2548 + Charset id = 0
2549 + Size = 4
2550 + Table = TESTDATA
2551 + Column = MYARRAY
2552 + Dimensions = 1
2553 + Bounds: (0:16)
2554 +
2555 + SQLType =SQL_ARRAY
2556 + sub type = 0
2557 + Table = TESTDATA
2558 + Owner = SYSDBA
2559 + Column Name = MYARRAY2
2560 + Alias Name = MYARRAY2
2561 + Field Name = MYARRAY2
2562 + Scale = 0
2563 + Charset id = 0
2564 + Nullable
2565 + Size = 8
2566 + Array Meta Data:
2567 + SQLType =SQL_TIMESTAMP
2568 + Scale = 0
2569 + Charset id = 0
2570 + Size = 8
2571 + Table = TESTDATA
2572 + Column = MYARRAY2
2573 + Dimensions = 1
2574 + Bounds: (0:16)
2575 +
2576 + SQLType =SQL_ARRAY
2577 + sub type = 0
2578 + Table = TESTDATA
2579 + Owner = SYSDBA
2580 + Column Name = MYARRAY3
2581 + Alias Name = MYARRAY3
2582 + Field Name = MYARRAY3
2583 + Scale = 0
2584 + Charset id = 0
2585 + Nullable
2586 + Size = 8
2587 + Array Meta Data:
2588 + SQLType =SQL_INT64
2589 + Scale = -2
2590 + Charset id = 0
2591 + Size = 8
2592 + Table = TESTDATA
2593 + Column = MYARRAY3
2594 + Dimensions = 1
2595 + Bounds: (0:16)
2596 +
2597   ROWID = 1
2598 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2599 < DATED = 1/4/2016 09:30:00.100
2600 < NOTES = Écoute moi (Charset Id = 4 Codepage = 65001 Byte Length = 11)
2601 < 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)
2598 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2599 > DATED = 2016/04/01 09:30:00.1000
2600 > NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
2601 > 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)
2602 >
2603 > 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)
2604 >
2605 > MYARRAY3 = Array: (0: 0) (1: 1.04) (2: 2.09) (3: 3.15) (4: 4.19) (5: 5.25) (6: 6.3) (7: 7.34) (8: 8.39) (9: 9.44) (10: 10.5) (11: 11.55) (12: 12.6) (13: 13.64) (14: 14.69) (15: 15.75) (16: 16.79)
2606 >
2607  
2608   Shrink to 2:10
2609   Array: (2: 98) (3: 97) (4: 96) (5: 95) (6: 94) (7: 93) (8: 92) (9: 91) (10: 90)
2610 +
2611   Write updated reduced slice
2612   Show update array
2613   ROWID = 1
2614 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2615 < DATED = 1/4/2016 09:30:00.100
2616 < NOTES = Écoute moi (Charset Id = 4 Codepage = 65001 Byte Length = 11)
2617 < 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)
2614 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2615 > DATED = 2016/04/01 09:30:00.1000
2616 > NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
2617 > 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)
2618 >
2619 > 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)
2620 >
2621 > MYARRAY3 = Array: (0: 0) (1: 1.04) (2: 2.09) (3: 3.15) (4: 4.19) (5: 5.25) (6: 6.3) (7: 7.34) (8: 8.39) (9: 9.44) (10: 10.5) (11: 11.55) (12: 12.6) (13: 13.64) (14: 14.69) (15: 15.75) (16: 16.79)
2622  
2623  
2624  
2625 +
2626 + ------------------------------------------------------
2627   Running Test 8: Create and read back an Array with 2 dimensions
2628   Metadata
2629   SQLType =SQL_LONG
# Line 2238 | Line 2679 | Scale = 0
2679   Charset id = 0
2680   Not Null
2681   Size = 4
2682 + Value = 0
2683  
2684   SQLType =SQL_VARYING
2685   sub type = 0
# Line 2248 | Line 2690 | Nullable
2690   Size = 128
2691  
2692   ROWID = 1
2693 < TITLE = 2D Array (Charset Id = 4 Codepage = 65001 Byte Length = 8)
2693 > TITLE = 2D Array (Charset Id = 4 Codepage = 65001)
2694   MYARRAY = NULL
2695  
2696   ROWID = 1
2697 < TITLE = 2D Array (Charset Id = 4 Codepage = 65001 Byte Length = 8)
2698 < 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)
2697 > TITLE = 2D Array (Charset Id = 4 Codepage = 65001)
2698 > 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)
2699 >
2700  
2701  
2702  
2703 + ------------------------------------------------------
2704   Running Test 9: Database Information tests
2705   Database ID = 4 FB = /opt/firebird2.5.9/examples/empbuild/employee.fdb SN = zeus
2706   Pages =272
# Line 2273 | Line 2717 | Unknown Response 3
2717   Unknown Response 3
2718   Server Memory = 841392
2719   Forced Writes  = 1
2720 < Max Memory  = 879352
2720 > Max Memory  = 879240
2721   Num Buffers  = 75
2722   Sweep Interval  = 20000
2723   Logged in Users: SYSDBA,
# Line 2319 | Line 2763 | Update Count Operation Counts
2763   Page Size = 4096
2764  
2765  
2766 + ------------------------------------------------------
2767   Running Test 10: Event Handling
2768   Call Async Wait
2769   Async Wait Called
# Line 2342 | Line 2787 | Event Signalled
2787   Event Counts: TESTEVENT, Count = 2
2788  
2789  
2790 + ------------------------------------------------------
2791   Running Test 11: Services API
2792 + SPB: Item Count = 2
2793 +  user_name = SYSDBA
2794 +  password = masterkey
2795 +
2796   Service Manager Version = 2
2797   Server Version = LI-V2.5.9.27139 Firebird 2.5
2798   Implementation = Firebird/linux AMD64
# Line 2364 | Line 2814 | User ID = 0
2814   Group ID = 0
2815  
2816  
2817 < Licence Info:
2368 < feature is not supported
2817 > Licence Info: feature is not supported
2818   -feature is not supported
2819  
2820 < Licence Mask Info:
2372 < feature is not supported
2820 > Licence Mask Info: feature is not supported
2821  
2822   Capabilities = 260
2823  
# Line 2399 | Line 2847 | Database OK
2847   Database Dropped
2848  
2849  
2850 + ------------------------------------------------------
2851   Running Test 12: Character Sets
2852   SQL Params
2853   SQLType =SQL_LONG
# Line 2408 | Line 2857 | Scale = 0
2857   Charset id = 0
2858   Not Null
2859   Size = 4
2860 + Value = 0
2861  
2862   SQLType =SQL_VARYING
2863   sub type = 0
# Line 2457 | Line 2907 | Charset id = 4
2907   Nullable
2908   Size = 16
2909  
2910 + Show Param Values
2911 + SQL Params
2912 + SQLType =SQL_LONG
2913 + sub type = 0
2914 + Field Name = ROWID
2915 + Scale = 0
2916 + Charset id = 0
2917 + Not Null
2918 + Size = 4
2919 + Value = 1
2920 +
2921 + SQLType =SQL_TEXT
2922 + sub type = 0
2923 + Field Name = TITLE
2924 + Scale = 0
2925 + Charset id = 4
2926 + Nullable
2927 + Size = 128
2928 + Value = Blob Test ©€
2929 +
2930 + SQLType =SQL_TEXT
2931 + sub type = 0
2932 + Field Name = NOTES
2933 + Scale = 0
2934 + Charset id = 4
2935 + Nullable
2936 + Size = 256
2937 + Value = Écoute moi
2938 +
2939 + SQLType =SQL_TEXT
2940 + sub type = 0
2941 + Field Name = BLOBDATA
2942 + Scale = 0
2943 + Charset id = 1
2944 + Nullable
2945 + Size = 8
2946 + Value = Some German Special Characters like Ă–Ă„ĂœĂ¶Ă¤Ă¼ĂŸ
2947 +
2948 + SQLType =SQL_BLOB
2949 + sub type = 1
2950 + Field Name = BLOBDATA2
2951 + Scale = 0
2952 + Charset id = 4
2953 + Nullable
2954 + Size = 8
2955 + Value = Some German Special Characters like Ă–Ă„ĂœĂ¶Ă¤Ă¼ĂŸ
2956 +
2957 + SQLType =SQL_TEXT
2958 + sub type = 0
2959 + Field Name = INCLEAR
2960 + Scale = 0
2961 + Charset id = 1
2962 + Nullable
2963 + Size = 16
2964 + Value = &Test
2965  
2966 +
2967 + SQLType =SQL_TEXT
2968 + sub type = 0
2969 + Field Name = FIXEDWIDTH
2970 + Scale = 0
2971 + Charset id = 4
2972 + Nullable
2973 + Size = 16
2974 + Value = É
2975 +
2976   Connection Character Set UTF8
2977   ROWID = 1
2978 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2979 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
2978 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
2979 > NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
2980   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)
2981   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)
2982 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
2983 < FIXEDWIDTH = C3 89  (Charset Id = 4 Codepage = 65001 Byte Length = 5)
2982 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
2983 > FIXEDWIDTH = C3 89  (Charset Id = 4 Codepage = 65001)
2984  
2985   Connection Character Set NONE
2986   ROWID = 1
2987 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2988 < NOTES = C9 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 21 Codepage = 28591 Byte Length = 10)
2987 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
2988 > NOTES = C9 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 21 Codepage = 28591)
2989   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)
2990   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)
2991 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
2992 < FIXEDWIDTH = C3 89  (Charset Id = 4 Codepage = 65001 Byte Length = 5)
2991 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
2992 > FIXEDWIDTH = C3 89  (Charset Id = 4 Codepage = 65001)
2993  
2994   Connection Character Set WIN1252
2995   ROWID = 1
2996 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 A9 80  (Charset Id = 53 Codepage = 1252 Byte Length = 12)
2997 < NOTES = C9 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 53 Codepage = 1252 Byte Length = 10)
2996 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 A9 80  (Charset Id = 53 Codepage = 1252)
2997 > NOTES = C9 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 53 Codepage = 1252)
2998   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)
2999   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)
3000 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3001 < FIXEDWIDTH = C9  (Charset Id = 53 Codepage = 1252 Byte Length = 4)
3000 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3001 > FIXEDWIDTH = C9  (Charset Id = 53 Codepage = 1252)
3002  
3003  
3004  
3005 + ------------------------------------------------------
3006   Running Test 13: Transaction over two databases
3007   Init Database 1
3008   ROWID = 1
3009 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001 Byte Length = 15)
3010 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
3009 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
3010 > NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
3011   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)
3012   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)
3013 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3013 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3014  
3015   Init Database 2
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   ROWID = 1
3024 < TITLE = 44 61 74 61 62 61 73 65 31  (Charset Id = 4 Codepage = 65001 Byte Length = 9)
3025 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
3024 > TITLE = 44 61 74 61 62 61 73 65 31  (Charset Id = 4 Codepage = 65001)
3025 > NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
3026   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)
3027   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)
3028 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3028 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3029  
3030   ROWID = 1
3031 < TITLE = 44 61 74 61 62 61 73 65 32  (Charset Id = 4 Codepage = 65001 Byte Length = 9)
3032 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
3031 > TITLE = 44 61 74 61 62 61 73 65 32  (Charset Id = 4 Codepage = 65001)
3032 > NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
3033   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)
3034   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)
3035 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3035 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3036  
3037  
3038  
3039 + ------------------------------------------------------
3040   Running Test 14: Non select procedures
3041   Default Character set Name = UTF8
3042   Metadata
# Line 2547 | Line 3064 | Nullable
3064   Size = 128
3065  
3066   ROWID = 1
3067 < TITLE = Testing (Charset Id = 4 Codepage = 65001 Byte Length = 7)
3067 > TITLE = Testing (Charset Id = 4 Codepage = 65001)
3068  
3069   Repeat with a different execute transaction
3070  
3071   ROWID = 1
3072 < TITLE = Testing (Charset Id = 4 Codepage = 65001 Byte Length = 7)
3072 > TITLE = Testing (Charset Id = 4 Codepage = 65001)
3073  
3074   Repeat with a original transaction
3075  
3076   ROWID = 1
3077 < TITLE = Testing (Charset Id = 4 Codepage = 65001 Byte Length = 7)
3077 > TITLE = Testing (Charset Id = 4 Codepage = 65001)
3078  
3079  
3080 + ------------------------------------------------------
3081   Running Test 15: Blob Handling and BPBs
3082  
3083   Testdata
3084  
3085   ROWID = 1
3086 < TITLE = Blob Test (Charset Id = 4 Codepage = 65001 Byte Length = 9)
3086 > TITLE = Blob Test (Charset Id = 4 Codepage = 65001)
3087   BLOBDATA = (blob), Length = 92514
3088  
3089 + ROWID = 2
3090 + TITLE = Blob Test with binary string (Charset Id = 4 Codepage = 65001)
3091 + BLOBDATA = (blob), Length = 13
3092 + 0 9 A C9 63 6F 75 74 65 20 6D 6F 69
3093  
3094   Testdata 2
3095  
3096   ROWID = 1
3097 < TITLE = Blob Test (Charset Id = 4 Codepage = 65001 Byte Length = 9)
3097 > TITLE = Blob Test (Charset Id = 4 Codepage = 65001)
3098   BLOBDATA (Charset Id = 4 Codepage = 65001)
3099  
3100   Écoute moi
3101  
3102  
3103  
3104 + ------------------------------------------------------
3105   Running Test 16: Error handling
3106   Invalid Database Name Test
3107 < Error Handled:
2585 < I/O error during "open" operation for file "Malformed Name"
3107 > Error Handled: I/O error during "open" operation for file "Malformed Name"
3108   -Error while trying to open file
3109   -No such file or directory
3110   Invalid User Name Test
3111 < Error Handled:
2590 < Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3111 > Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3112   Invalid password Test
3113 < Error Handled:
2593 < Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3113 > Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3114   Invalid Prepare SQL Test
3115 < Error Handled:
2596 < Dynamic SQL Error
3115 > Error Handled: Dynamic SQL Error
3116   -SQL error code = -206
3117   -Column unknown
3118   -UNKNOWN_DATE
3119   -At line 1, column 21 When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ?
3120   Invalid Open Cursor SQL Test
3121 < Error Handled:
2603 < Dynamic SQL Error
3121 > Error Handled: Dynamic SQL Error
3122   -SQL error code = -206
3123   -Column unknown
3124   -X
# Line 2612 | Line 3130 | Error Handled: Field "EMP_NO" not found
3130   Case sensitive Param SQL  Test
3131   Error Handled: Field "EMP_NO" not found
3132   Invalid Server Name Test
3133 < Error Handled:
2616 < Unable to complete network request to host "unknown".
3133 > Error Handled: Unable to complete network request to host "unknown".
3134   -Failed to locate host machine
3135   Invalid User Name Test
3136 < Error Handled:
2620 < Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3136 > Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3137   Invalid password Test
3138 < Error Handled:
3139 < Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3138 > Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3139 >
3140 >
3141 > ------------------------------------------------------
3142 > Running Test 17: Date/Time tests and Firebird 4 extensions
3143 > FBVersion = Firebird/linux AMD64 (access method), version "LI-V2.5.9.27139 Firebird 2.5"
3144 > Has Local TZ DB = FALSE
3145 >
3146 > Testdata
3147 >
3148 > Metadata
3149 > SQLType =SQL_LONG
3150 > sub type = 0
3151 > Table = TESTDATA
3152 > Owner = SYSDBA
3153 > Column Name = ROWID
3154 > Alias Name = ROWID
3155 > Field Name = ROWID
3156 > Scale = 0
3157 > Charset id = 0
3158 > Not Null
3159 > Size = 4
3160 >
3161 > SQLType =SQL_TYPE_DATE
3162 > sub type = 0
3163 > Table = TESTDATA
3164 > Owner = SYSDBA
3165 > Column Name = DATECOL
3166 > Alias Name = DATECOL
3167 > Field Name = DATECOL
3168 > Scale = 0
3169 > Charset id = 0
3170 > Nullable
3171 > Size = 4
3172 >
3173 > SQLType =SQL_TYPE_TIME
3174 > sub type = 0
3175 > Table = TESTDATA
3176 > Owner = SYSDBA
3177 > Column Name = TIMECOL
3178 > Alias Name = TIMECOL
3179 > Field Name = TIMECOL
3180 > Scale = 0
3181 > Charset id = 0
3182 > Nullable
3183 > Size = 4
3184 >
3185 > SQLType =SQL_TIMESTAMP
3186 > sub type = 0
3187 > Table = TESTDATA
3188 > Owner = SYSDBA
3189 > Column Name = TIMESTAMPCOL
3190 > Alias Name = TIMESTAMPCOL
3191 > Field Name = TIMESTAMPCOL
3192 > Scale = 0
3193 > Charset id = 0
3194 > Nullable
3195 > Size = 8
3196 >
3197 > ROWID = 1
3198 > DATECOL = 2019/04/01
3199 > TIMECOL = 11:31:05.0001
3200 > TIMESTAMPCOL = 2016/02/29 22:02:35.0001
3201 > ROWID = 2
3202 > DATECOL = 1939/09/03
3203 > TIMECOL = 15:40:00.0002
3204 > TIMESTAMPCOL = 1918/11/11 11:11:00.0000
3205 > ROWID = 3
3206 > DATECOL = 1066/10/14
3207 > TIMECOL = 23:59:59.9994
3208 > TIMESTAMPCOL = 1918/11/11 11:11:00.0000
3209 > ROWID = 4
3210 > DATECOL = 1815/06/18
3211 > TIMECOL = 00:01:40.1115
3212 > TIMESTAMPCOL = 1945/05/08 22:10:00.0010
3213 >
3214 >
3215 > Testdata - second pass
3216 >
3217 > 1, 01/4/2019, 11:31:05, 29/2/2016 22:02:35
3218 > 2, 03/9/1939, 15:40:00.000, 11/11/1918 11:11:00
3219 > 3, 14/10/1066, 23:59:59.999, 11/11/1918 11:11:00
3220 > 4, 18/6/1815, 00:01:40.112, 08/5/1945 22:10:00
3221 > Sys Time = 1945, 5, 8, 2, 22, 10, 0, 1
3222 > Skipping Firebird 4 and later test part
3223 >
3224 >
3225 > ------------------------------------------------------
3226 > Running Test 18: Firebird 4 Decfloat extensions
3227 > FBVersion = Firebird/linux AMD64 (access method), version "LI-V2.5.9.27139 Firebird 2.5"
3228 > Skipping test for Firebird 4 and later
3229 >
3230 >
3231 > ------------------------------------------------------
3232 > Running Test 19: Batch Update and Insert Queries
3233 > Opening localhost:employee
3234 > Skipping test for Firebird 4 and later
3235 >
3236 >
3237 > ------------------------------------------------------
3238 > Running Test 20: Stress Test IBatch interface
3239 > FBVersion = Firebird/linux AMD64 (access method), version "LI-V2.5.9.27139 Firebird 2.5"
3240 > Skipping test for Firebird 4 and later
3241  
3242  
3243 + ------------------------------------------------------
3244   Test Suite Ends

Diff Legend

Removed lines
+ Added lines
< Changed lines
> Changed lines