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

Comparing ibx/trunk/fbintf/testsuite/FB3reference.log (file contents):
Revision 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 = 3.0
6 + Firebird Environment Variable = /opt/firebird3.0.5
7 + Firebird Bin Directory = /opt/firebird3.0.5/bin
8 + Firebird Conf Directory = /opt/firebird3.0.5/
9 + Firebird Client Library Path = /opt/firebird3.0.5/lib/libfbclient.so
10   Running Test 1: Create and Drop a Database
11   Creating a Database with empty parameters
12 < Create Database fails (as expected):
9 < I/O error during "open O_CREAT" operation for file ""
12 > Create Database fails (as expected): I/O error during "open O_CREAT" operation for file ""
13   -Error while trying to create file
14   -No such file or directory
15   Creating a Database using an SQL Statement
16 < Database ID = 2 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus
16 > Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus
17   SQL Dialect = 3
18 < DB Connect String = /tmp/fbintf-testsuite/testsuite1.fdb
18 > DB Connect String = inet://localhost//tmp/fbintf-testsuite/testsuite1.fdb
19   DB Charset ID = 0
20   DB SQL Dialect = 3
21 < DB Remote Protocol =
21 > DB Remote Protocol = TCPv4
22   DB ODS Major Version = 12
23   DB ODS Minor Version = 0
24 < User Authentication Method = User name in DPB
24 > User Authentication Method = Srp
25   Firebird Library Path = /opt/firebird3.0.5/lib/libfbclient.so
26   DB Client Implementation Version = 3.0
27 < DPB
28 < Count = 3
29 < 28 = SYSDBA
30 < 29 = masterkey
31 < 65 = 3
27 > DPB: Item Count = 3
28 >  isc_dpb_user_name = SYSDBA
29 >  isc_dpb_password = masterkey
30 >  isc_dpb_set_db_sql_dialect = 3
31 >
32 > Firebird Server Version Info
33 > Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.5.33220 Firebird 3.0"
34 > Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.5.33220 Firebird 3.0/tcp (zeus)/P15:C"
35 > Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.5.33220 Firebird 3.0/tcp (zeus)/P15:C"
36 > on disk structure version 12.0
37  
38   Dropping Database
39   Creating a Database with a DPD
40 < DB Connect String = /tmp/fbintf-testsuite/testsuite1.fdb
40 > DB Connect String = inet://localhost//tmp/fbintf-testsuite/testsuite1.fdb
41   DB Charset ID = 4
42   DB SQL Dialect = 3
43 < DB Remote Protocol =
43 > DB Remote Protocol = TCPv4
44   DB ODS Major Version = 12
45   DB ODS Minor Version = 0
46 < User Authentication Method = User name in DPB
46 > User Authentication Method = Srp
47   Firebird Library Path = /opt/firebird3.0.5/lib/libfbclient.so
48   DB Client Implementation Version = 3.0
49   Dropping Database
50 < DPB
51 < Count = 4
52 < 28 = SYSDBA
53 < 29 = masterkey
54 < 48 = UTF8
47 < 65 = 3
50 > DPB: Item Count = 4
51 >  isc_dpb_user_name = SYSDBA
52 >  isc_dpb_password = masterkey
53 >  isc_dpb_lc_ctype = UTF8
54 >  isc_dpb_set_db_sql_dialect = 3
55  
56   Creating a Database with a DPD
57 < Database ID = 2 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus
57 > Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus
58   ODS major = 12
59   ODS minor = 0
60 < DB Connect String = /tmp/fbintf-testsuite/testsuite1.fdb
60 > DB Connect String = inet://localhost//tmp/fbintf-testsuite/testsuite1.fdb
61   DB Charset ID = 4
62   DB SQL Dialect = 3
63 < DB Remote Protocol =
63 > DB Remote Protocol = TCPv4
64   DB ODS Major Version = 12
65   DB ODS Minor Version = 0
66 < User Authentication Method = User name in DPB
66 > User Authentication Method = Srp
67   Firebird Library Path = /opt/firebird3.0.5/lib/libfbclient.so
68   DB Client Implementation Version = 3.0
69   RDB$DESCRIPTION =
# Line 67 | Line 74 | RDB$LINGER =
74   Dropping Database
75  
76  
77 + ------------------------------------------------------
78   Running Test 2: Open the employee database and run a query
79   Opening inet://localhost/employee
80   Database Open, SQL Dialect = 3
81 + TPB: Item Count = 3
82 +  isc_tpb_read
83 +  isc_tpb_nowait
84 +  isc_tpb_concurrency
85 +
86   Metadata
87   SQLType =SQL_SHORT
88   sub type = 0
# Line 214 | Line 227 | EMP_NO = 2
227   FIRST_NAME = Robert
228   LAST_NAME = Nelson
229   PHONE_EXT = 250
230 < HIRE_DATE = 28/12/1988 00:00:00.000
230 > HIRE_DATE = 1988/12/28 00:00:00.0000
231   DEPT_NO = 600
232   JOB_CODE = VP
233   JOB_GRADE = 2
# Line 225 | Line 238 | EMP_NO = 4
238   FIRST_NAME = Bruce
239   LAST_NAME = Young
240   PHONE_EXT = 233
241 < HIRE_DATE = 28/12/1988 00:00:00.000
241 > HIRE_DATE = 1988/12/28 00:00:00.0000
242   DEPT_NO = 621
243   JOB_CODE = Eng
244   JOB_GRADE = 2
# Line 236 | Line 249 | EMP_NO = 5
249   FIRST_NAME = Kim
250   LAST_NAME = Lambert
251   PHONE_EXT = 22
252 < HIRE_DATE = 6/2/1989 00:00:00.000
252 > HIRE_DATE = 1989/02/06 00:00:00.0000
253   DEPT_NO = 130
254   JOB_CODE = Eng
255   JOB_GRADE = 2
# Line 253 | Line 266 | Scale = 0
266   Charset id = 0
267   Not Null
268   Size = 2
269 + Value = 0
270  
271   EMP_NO = 8
272   FIRST_NAME = Leslie
273   LAST_NAME = Johnson
274   PHONE_EXT = 410
275 < HIRE_DATE = 5/4/1989 00:00:00.000
275 > HIRE_DATE = 1989/04/05 00:00:00.0000
276   DEPT_NO = 180
277   JOB_CODE = Mktg
278   JOB_GRADE = 3
# Line 276 | Line 290 | Scale = 0
290   Charset id = 0
291   Not Null
292   Size = 2
293 + Value = 0
294  
295   EMP_NO = 8
296   FIRST_NAME = Leslie
297   LAST_NAME = Johnson
298   PHONE_EXT = 410
299 < HIRE_DATE = 5/4/1989 00:00:00.000
299 > HIRE_DATE = 1989/04/05 00:00:00.0000
300   DEPT_NO = 180
301   JOB_CODE = Mktg
302   JOB_GRADE = 3
# Line 289 | Line 304 | JOB_COUNTRY = USA
304   SALARY = 64,635.00
305   FULL_NAME = Johnson, Leslie
306  
307 + Now open the employee database as a local database
308 + TPB: Item Count = 3
309 +  isc_tpb_read
310 +  isc_tpb_nowait
311 +  isc_tpb_concurrency
312 +
313 + Metadata
314 + SQLType =SQL_SHORT
315 + sub type = 0
316 + Table = EMPLOYEE
317 + Owner = SYSDBA
318 + Column Name = EMP_NO
319 + Alias Name = EMP_NO
320 + Field Name = EMP_NO
321 + Scale = 0
322 + Charset id = 0
323 + Not Null
324 + Size = 2
325 +
326 + SQLType =SQL_VARYING
327 + sub type = 0
328 + Table = EMPLOYEE
329 + Owner = SYSDBA
330 + Column Name = FIRST_NAME
331 + Alias Name = FIRST_NAME
332 + Field Name = FIRST_NAME
333 + Scale = 0
334 + Charset id = 0
335 + Not Null
336 + Size = 15
337 +
338 + SQLType =SQL_VARYING
339 + sub type = 0
340 + Table = EMPLOYEE
341 + Owner = SYSDBA
342 + Column Name = LAST_NAME
343 + Alias Name = LAST_NAME
344 + Field Name = LAST_NAME
345 + Scale = 0
346 + Charset id = 0
347 + Not Null
348 + Size = 20
349  
350 + SQLType =SQL_VARYING
351 + sub type = 0
352 + Table = EMPLOYEE
353 + Owner = SYSDBA
354 + Column Name = PHONE_EXT
355 + Alias Name = PHONE_EXT
356 + Field Name = PHONE_EXT
357 + Scale = 0
358 + Charset id = 0
359 + Nullable
360 + Size = 4
361  
362 + SQLType =SQL_TIMESTAMP
363 + sub type = 0
364 + Table = EMPLOYEE
365 + Owner = SYSDBA
366 + Column Name = HIRE_DATE
367 + Alias Name = HIRE_DATE
368 + Field Name = HIRE_DATE
369 + Scale = 0
370 + Charset id = 0
371 + Not Null
372 + Size = 8
373 +
374 + SQLType =SQL_TEXT
375 + sub type = 0
376 + Table = EMPLOYEE
377 + Owner = SYSDBA
378 + Column Name = DEPT_NO
379 + Alias Name = DEPT_NO
380 + Field Name = DEPT_NO
381 + Scale = 0
382 + Charset id = 0
383 + Not Null
384 + Size = 3
385 +
386 + SQLType =SQL_VARYING
387 + sub type = 0
388 + Table = EMPLOYEE
389 + Owner = SYSDBA
390 + Column Name = JOB_CODE
391 + Alias Name = JOB_CODE
392 + Field Name = JOB_CODE
393 + Scale = 0
394 + Charset id = 0
395 + Not Null
396 + Size = 5
397 +
398 + SQLType =SQL_SHORT
399 + sub type = 0
400 + Table = EMPLOYEE
401 + Owner = SYSDBA
402 + Column Name = JOB_GRADE
403 + Alias Name = JOB_GRADE
404 + Field Name = JOB_GRADE
405 + Scale = 0
406 + Charset id = 0
407 + Not Null
408 + Size = 2
409 +
410 + SQLType =SQL_VARYING
411 + sub type = 0
412 + Table = EMPLOYEE
413 + Owner = SYSDBA
414 + Column Name = JOB_COUNTRY
415 + Alias Name = JOB_COUNTRY
416 + Field Name = JOB_COUNTRY
417 + Scale = 0
418 + Charset id = 0
419 + Not Null
420 + Size = 15
421 +
422 + SQLType =SQL_INT64
423 + sub type = 0
424 + Table = EMPLOYEE
425 + Owner = SYSDBA
426 + Column Name = SALARY
427 + Alias Name = SALARY
428 + Field Name = SALARY
429 + Scale = -2
430 + Charset id = 0
431 + Not Null
432 + Size = 8
433 +
434 + SQLType =SQL_VARYING
435 + sub type = 0
436 + Table = EMPLOYEE
437 + Owner = SYSDBA
438 + Column Name = FULL_NAME
439 + Alias Name = FULL_NAME
440 + Field Name = FULL_NAME
441 + Scale = 0
442 + Charset id = 0
443 + Nullable
444 + Size = 37
445 +
446 + Plan =
447 + Select Expression
448 +    -> First N Records
449 +        -> Table "EMPLOYEE" Full Scan
450 + -- SQL style inline comment
451 + /* this is a comment */ Select First 3 * from EMPLOYEE
452 +
453 + EMP_NO = 2
454 + FIRST_NAME = Robert
455 + LAST_NAME = Nelson
456 + PHONE_EXT = 250
457 + HIRE_DATE = 1988/12/28 00:00:00.0000
458 + DEPT_NO = 600
459 + JOB_CODE = VP
460 + JOB_GRADE = 2
461 + JOB_COUNTRY = USA
462 + SALARY = 105,900.00
463 + FULL_NAME = Nelson, Robert
464 + EMP_NO = 4
465 + FIRST_NAME = Bruce
466 + LAST_NAME = Young
467 + PHONE_EXT = 233
468 + HIRE_DATE = 1988/12/28 00:00:00.0000
469 + DEPT_NO = 621
470 + JOB_CODE = Eng
471 + JOB_GRADE = 2
472 + JOB_COUNTRY = USA
473 + SALARY = 97,500.00
474 + FULL_NAME = Young, Bruce
475 + EMP_NO = 5
476 + FIRST_NAME = Kim
477 + LAST_NAME = Lambert
478 + PHONE_EXT = 22
479 + HIRE_DATE = 1989/02/06 00:00:00.0000
480 + DEPT_NO = 130
481 + JOB_CODE = Eng
482 + JOB_GRADE = 2
483 + JOB_COUNTRY = USA
484 + SALARY = 102,750.00
485 + FULL_NAME = Lambert, Kim
486 +
487 + Select * from EMPLOYEE Where EMP_NO = ?
488 + SQL Params
489 + SQLType =SQL_SHORT
490 + sub type = 0
491 + Field Name =
492 + Scale = 0
493 + Charset id = 0
494 + Not Null
495 + Size = 2
496 + Value = 0
497 +
498 + EMP_NO = 8
499 + FIRST_NAME = Leslie
500 + LAST_NAME = Johnson
501 + PHONE_EXT = 410
502 + HIRE_DATE = 1989/04/05 00:00:00.0000
503 + DEPT_NO = 180
504 + JOB_CODE = Mktg
505 + JOB_GRADE = 3
506 + JOB_COUNTRY = USA
507 + SALARY = 64,635.00
508 + FULL_NAME = Johnson, Leslie
509 +
510 + With param names
511 + Select * from EMPLOYEE Where EMP_NO = :EMP_NO
512 + SQL Params
513 + SQLType =SQL_SHORT
514 + sub type = 0
515 + Field Name = EMP_NO
516 + Scale = 0
517 + Charset id = 0
518 + Not Null
519 + Size = 2
520 + Value = 0
521 +
522 + EMP_NO = 8
523 + FIRST_NAME = Leslie
524 + LAST_NAME = Johnson
525 + PHONE_EXT = 410
526 + HIRE_DATE = 1989/04/05 00:00:00.0000
527 + DEPT_NO = 180
528 + JOB_CODE = Mktg
529 + JOB_GRADE = 3
530 + JOB_COUNTRY = USA
531 + SALARY = 64,635.00
532 + FULL_NAME = Johnson, Leslie
533 +
534 +
535 +
536 + ------------------------------------------------------
537   Running Test 3: ad hoc queries
538   Opening inet://localhost/employee
539   Database Open
# Line 304 | Line 547 | Constrained Employee Count = 3
547   "Yanowski" Employee Count = 1
548  
549  
550 + ------------------------------------------------------
551   Running Test 4: Update, Insert and Delete Queries
552   Opening inet://localhost/employee
553   Database Open
# Line 316 | Line 560 | EMP_NO = 8
560   FIRST_NAME = Leslie
561   LAST_NAME = Johnson
562   PHONE_EXT = 410
563 < HIRE_DATE = 5/4/1989 00:00:00.000
563 > HIRE_DATE = 1989/04/05 00:00:00.0000
564   DEPT_NO = 180
565   JOB_CODE = Mktg
566   JOB_GRADE = 3
# Line 324 | Line 568 | JOB_COUNTRY = USA
568   SALARY = 64,635.00
569   FULL_NAME = Johnson, Leslie
570  
571 < Current memory = 19693296
572 < Delta memory = 4480
573 < Max memory = 19755408
571 > Current memory = 19,693,312
572 > Delta memory = 4,480
573 > Max memory = 19,755,424
574   Elapsed time= 0.001 sec
575   Cpu = 0.000 sec
576   Buffers = 2048
# Line 472 | Line 716 | EMP_NO = 150
716   FIRST_NAME = John
717   LAST_NAME = Doe
718   PHONE_EXT =
719 < HIRE_DATE = 1/4/2015 00:00:00.000
719 > HIRE_DATE = 2015/04/01 00:00:00.0000
720   DEPT_NO = 600
721   JOB_CODE = Eng
722   JOB_GRADE = 4
# Line 485 | Line 729 | EMP_NO = 151
729   FIRST_NAME = Major
730   LAST_NAME = Major
731   PHONE_EXT =
732 < HIRE_DATE = 1/4/2015 00:00:00.000
732 > HIRE_DATE = 2015/04/01 00:00:00.0000
733   DEPT_NO = 600
734   JOB_CODE = Eng
735   JOB_GRADE = 4
# Line 502 | Line 746 | EMP_NO = 150
746   FIRST_NAME = Jane
747   LAST_NAME = Doe
748   PHONE_EXT = NULL
749 < HIRE_DATE = 1/4/2015 00:00:00.000
749 > HIRE_DATE = 2015/04/01 00:00:00.0000
750   DEPT_NO = 600
751   JOB_CODE = Eng
752   JOB_GRADE = 4
# Line 519 | Line 763 | EMP_NO = 150
763   FIRST_NAME = Jayne's
764   LAST_NAME = Doe
765   PHONE_EXT = NULL
766 < HIRE_DATE = 1/4/2015 00:00:00.000
766 > HIRE_DATE = 2015/04/01 00:00:00.0000
767   DEPT_NO = 600
768   JOB_CODE = Eng
769   JOB_GRADE = 4
# Line 533 | Line 777 | EMP_NO = 8
777   FIRST_NAME = Leslie
778   LAST_NAME = Johnson
779   PHONE_EXT = 410
780 < HIRE_DATE = 5/4/1989 00:00:00.000
780 > HIRE_DATE = 1989/04/05 00:00:00.0000
781   DEPT_NO = 180
782   JOB_CODE = Mktg
783   JOB_GRADE = 3
# Line 547 | Line 791 | EMP_NO = 8
791   FIRST_NAME = Leslie
792   LAST_NAME = Johnson
793   PHONE_EXT = 410
794 < HIRE_DATE = 5/4/1989 00:00:00.000
794 > HIRE_DATE = 1989/04/05 00:00:00.0000
795   DEPT_NO = 180
796   JOB_CODE = Mktg
797   JOB_GRADE = 3
# Line 559 | Line 803 | EMP_NO = 9
803   FIRST_NAME = Phil
804   LAST_NAME = Forest
805   PHONE_EXT = 229
806 < HIRE_DATE = 17/4/1989 00:00:00.000
806 > HIRE_DATE = 1989/04/17 00:00:00.0000
807   DEPT_NO = 622
808   JOB_CODE = Mngr
809   JOB_GRADE = 3
# Line 573 | Line 817 | EMP_NO = 8
817   FIRST_NAME = Leslie
818   LAST_NAME = Johnson
819   PHONE_EXT = 410
820 < HIRE_DATE = 31/1/2015 00:00:00.000
820 > HIRE_DATE = 2015/01/31 00:00:00.0000
821   DEPT_NO = 180
822   JOB_CODE = Mktg
823   JOB_GRADE = 3
# Line 583 | Line 827 | FULL_NAME = Johnson, Leslie
827  
828  
829  
830 + ------------------------------------------------------
831   Running Test 5: Update Returning and Activity Check
832   Opening inet://localhost/employee
833   Database Open
# Line 594 | Line 839 | EMP_NO = 8
839   FIRST_NAME = Leslie
840   LAST_NAME = Johnson
841   PHONE_EXT = 410
842 < HIRE_DATE = 31/1/2016 00:00:00.000
842 > HIRE_DATE = 2016/01/31 00:00:00.0000
843   DEPT_NO = 180
844   JOB_CODE = Mktg
845   JOB_GRADE = 3
# Line 616 | Line 861 | Transaction Active
861   Transaction inactive
862  
863  
864 + ------------------------------------------------------
865   Running Test 6: Blob Handling
866   Metadata
867   SQLType =SQL_TEXT
# Line 642 | Line 888 | Charset id = 0
888   Nullable
889   Size = 2
890  
891 < RDB$CHARACTER_SET_NAME = NONE (Charset Id = 4 Codepage = 65001 Byte Length = 31)
891 > RDB$CHARACTER_SET_NAME = NONE (Charset Id = 4 Codepage = 65001)
892   RDB$CHARACTER_SET_ID = 0
893 < RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 4 Codepage = 65001 Byte Length = 31)
893 > RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 4 Codepage = 65001)
894   RDB$CHARACTER_SET_ID = 1
895 < RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 4 Codepage = 65001 Byte Length = 31)
895 > RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 4 Codepage = 65001)
896   RDB$CHARACTER_SET_ID = 2
897 < RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 4 Codepage = 65001 Byte Length = 31)
897 > RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 4 Codepage = 65001)
898   RDB$CHARACTER_SET_ID = 3
899 < RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
899 > RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 4 Codepage = 65001)
900   RDB$CHARACTER_SET_ID = 4
901 < RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
901 > RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 4 Codepage = 65001)
902   RDB$CHARACTER_SET_ID = 5
903 < RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
903 > RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 4 Codepage = 65001)
904   RDB$CHARACTER_SET_ID = 6
905 < RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
905 > RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 4 Codepage = 65001)
906   RDB$CHARACTER_SET_ID = 9
907 < RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
907 > RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 4 Codepage = 65001)
908   RDB$CHARACTER_SET_ID = 10
909 < RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
909 > RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 4 Codepage = 65001)
910   RDB$CHARACTER_SET_ID = 11
911 < RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
911 > RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 4 Codepage = 65001)
912   RDB$CHARACTER_SET_ID = 12
913 < RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
913 > RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 4 Codepage = 65001)
914   RDB$CHARACTER_SET_ID = 13
915 < RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
915 > RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 4 Codepage = 65001)
916   RDB$CHARACTER_SET_ID = 14
917 < RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
917 > RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 4 Codepage = 65001)
918   RDB$CHARACTER_SET_ID = 15
919 < RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
919 > RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 4 Codepage = 65001)
920   RDB$CHARACTER_SET_ID = 16
921 < RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
921 > RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 4 Codepage = 65001)
922   RDB$CHARACTER_SET_ID = 17
923 < RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
923 > RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 4 Codepage = 65001)
924   RDB$CHARACTER_SET_ID = 18
925 < RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 4 Codepage = 65001 Byte Length = 31)
925 > RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 4 Codepage = 65001)
926   RDB$CHARACTER_SET_ID = 19
927 < RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
927 > RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 4 Codepage = 65001)
928   RDB$CHARACTER_SET_ID = 21
929 < RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
929 > RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 4 Codepage = 65001)
930   RDB$CHARACTER_SET_ID = 22
931 < RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
931 > RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 4 Codepage = 65001)
932   RDB$CHARACTER_SET_ID = 23
933 < RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
933 > RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 4 Codepage = 65001)
934   RDB$CHARACTER_SET_ID = 34
935 < RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
935 > RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 4 Codepage = 65001)
936   RDB$CHARACTER_SET_ID = 35
937 < RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
937 > RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 4 Codepage = 65001)
938   RDB$CHARACTER_SET_ID = 36
939 < RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
939 > RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 4 Codepage = 65001)
940   RDB$CHARACTER_SET_ID = 37
941 < RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
941 > RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 4 Codepage = 65001)
942   RDB$CHARACTER_SET_ID = 38
943 < RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
943 > RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 4 Codepage = 65001)
944   RDB$CHARACTER_SET_ID = 39
945 < RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
945 > RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 4 Codepage = 65001)
946   RDB$CHARACTER_SET_ID = 40
947 < RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
947 > RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 4 Codepage = 65001)
948   RDB$CHARACTER_SET_ID = 44
949 < RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
949 > RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 4 Codepage = 65001)
950   RDB$CHARACTER_SET_ID = 45
951 < RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
951 > RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 4 Codepage = 65001)
952   RDB$CHARACTER_SET_ID = 46
953 < RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
953 > RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 4 Codepage = 65001)
954   RDB$CHARACTER_SET_ID = 47
955 < RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
955 > RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 4 Codepage = 65001)
956   RDB$CHARACTER_SET_ID = 48
957 < RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
957 > RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 4 Codepage = 65001)
958   RDB$CHARACTER_SET_ID = 49
959 < RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 4 Codepage = 65001 Byte Length = 31)
959 > RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 4 Codepage = 65001)
960   RDB$CHARACTER_SET_ID = 50
961 < RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
961 > RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 4 Codepage = 65001)
962   RDB$CHARACTER_SET_ID = 51
963 < RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
963 > RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 4 Codepage = 65001)
964   RDB$CHARACTER_SET_ID = 52
965 < RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
965 > RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 4 Codepage = 65001)
966   RDB$CHARACTER_SET_ID = 53
967 < RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
967 > RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 4 Codepage = 65001)
968   RDB$CHARACTER_SET_ID = 54
969 < RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
969 > RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 4 Codepage = 65001)
970   RDB$CHARACTER_SET_ID = 55
971 < RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
971 > RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 4 Codepage = 65001)
972   RDB$CHARACTER_SET_ID = 56
973 < RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
973 > RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 4 Codepage = 65001)
974   RDB$CHARACTER_SET_ID = 57
975 < RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
975 > RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 4 Codepage = 65001)
976   RDB$CHARACTER_SET_ID = 58
977 < RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
977 > RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 4 Codepage = 65001)
978   RDB$CHARACTER_SET_ID = 59
979 < RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
979 > RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 4 Codepage = 65001)
980   RDB$CHARACTER_SET_ID = 60
981 < RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 4 Codepage = 65001 Byte Length = 31)
981 > RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 4 Codepage = 65001)
982   RDB$CHARACTER_SET_ID = 63
983 < RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 4 Codepage = 65001 Byte Length = 31)
983 > RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 4 Codepage = 65001)
984   RDB$CHARACTER_SET_ID = 64
985 < RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
985 > RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 4 Codepage = 65001)
986   RDB$CHARACTER_SET_ID = 65
987 < RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
987 > RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 4 Codepage = 65001)
988   RDB$CHARACTER_SET_ID = 66
989 < RDB$CHARACTER_SET_NAME = GBK (Charset Id = 4 Codepage = 65001 Byte Length = 31)
989 > RDB$CHARACTER_SET_NAME = GBK (Charset Id = 4 Codepage = 65001)
990   RDB$CHARACTER_SET_ID = 67
991 < RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 4 Codepage = 65001 Byte Length = 31)
991 > RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 4 Codepage = 65001)
992   RDB$CHARACTER_SET_ID = 68
993 < RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
993 > RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 4 Codepage = 65001)
994   RDB$CHARACTER_SET_ID = 69
995  
996   Metadata
# Line 824 | Line 1070 | Scale = 0
1070   Charset id = 0
1071   Not Null
1072   Size = 4
1073 + Value = 0
1074  
1075   SQLType =SQL_VARYING
1076   sub type = 0
# Line 852 | Line 1099 | Size = 8
1099   ROWID = 1
1100   FIXEDPOINT = 20.28
1101   FLOATINGPOINT = 3.14
1102 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
1102 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1103   BLOBDATA = NULL
1104  
1105   SQL Params
# Line 871 | Line 1118 | Scale = 0
1118   Charset id = 0
1119   Not Null
1120   Size = 4
1121 + Value = 0
1122  
1123   ROWID = 1
1124   FIXEDPOINT = 20.28
1125   FLOATINGPOINT = 3.14
1126 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
1126 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1127   BLOBDATA (Charset Id = 4 Codepage = 65001)
1128  
1129   To be or not to be-that is the question:
# Line 923 | Line 1171 | Scale = 0
1171   Charset id = 0
1172   Not Null
1173   Size = 4
1174 + Value = 0
1175  
1176   SQLType =SQL_VARYING
1177   sub type = 0
# Line 951 | Line 1200 | Size = 8
1200   ROWID = 1
1201   FIXEDPOINT = 20.28
1202   FLOATINGPOINT = 3.14
1203 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
1203 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1204   BLOBDATA (Charset Id = 4 Codepage = 65001)
1205  
1206   To be or not to be-that is the question:
# Line 993 | Line 1242 | Be all my sins remembered
1242   ROWID = 2
1243   FIXEDPOINT = NULL
1244   FLOATINGPOINT = NULL
1245 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
1245 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1246   BLOBDATA (Charset Id = 4 Codepage = 65001)
1247  
1248   To be or not to be-that is the question:
# Line 1118 | Line 1367 | Charset id = 0
1367   Nullable
1368   Size = 2
1369  
1370 < RDB$CHARACTER_SET_NAME = NONE (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1370 > RDB$CHARACTER_SET_NAME = NONE (Charset Id = 53 Codepage = 1252)
1371   RDB$CHARACTER_SET_ID = 0
1372 < RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1372 > RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 53 Codepage = 1252)
1373   RDB$CHARACTER_SET_ID = 1
1374 < RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1374 > RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 53 Codepage = 1252)
1375   RDB$CHARACTER_SET_ID = 2
1376 < RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1376 > RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 53 Codepage = 1252)
1377   RDB$CHARACTER_SET_ID = 3
1378 < RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1378 > RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 53 Codepage = 1252)
1379   RDB$CHARACTER_SET_ID = 4
1380 < RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1380 > RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 53 Codepage = 1252)
1381   RDB$CHARACTER_SET_ID = 5
1382 < RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1382 > RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 53 Codepage = 1252)
1383   RDB$CHARACTER_SET_ID = 6
1384 < RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1384 > RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 53 Codepage = 1252)
1385   RDB$CHARACTER_SET_ID = 9
1386 < RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1386 > RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 53 Codepage = 1252)
1387   RDB$CHARACTER_SET_ID = 10
1388 < RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1388 > RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 53 Codepage = 1252)
1389   RDB$CHARACTER_SET_ID = 11
1390 < RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1390 > RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 53 Codepage = 1252)
1391   RDB$CHARACTER_SET_ID = 12
1392 < RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1392 > RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 53 Codepage = 1252)
1393   RDB$CHARACTER_SET_ID = 13
1394 < RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1394 > RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 53 Codepage = 1252)
1395   RDB$CHARACTER_SET_ID = 14
1396 < RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1396 > RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 53 Codepage = 1252)
1397   RDB$CHARACTER_SET_ID = 15
1398 < RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1398 > RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 53 Codepage = 1252)
1399   RDB$CHARACTER_SET_ID = 16
1400 < RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1400 > RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 53 Codepage = 1252)
1401   RDB$CHARACTER_SET_ID = 17
1402 < RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1402 > RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 53 Codepage = 1252)
1403   RDB$CHARACTER_SET_ID = 18
1404 < RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1404 > RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 53 Codepage = 1252)
1405   RDB$CHARACTER_SET_ID = 19
1406 < RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1406 > RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 53 Codepage = 1252)
1407   RDB$CHARACTER_SET_ID = 21
1408 < RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1408 > RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 53 Codepage = 1252)
1409   RDB$CHARACTER_SET_ID = 22
1410 < RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1410 > RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 53 Codepage = 1252)
1411   RDB$CHARACTER_SET_ID = 23
1412 < RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1412 > RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 53 Codepage = 1252)
1413   RDB$CHARACTER_SET_ID = 34
1414 < RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1414 > RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 53 Codepage = 1252)
1415   RDB$CHARACTER_SET_ID = 35
1416 < RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1416 > RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 53 Codepage = 1252)
1417   RDB$CHARACTER_SET_ID = 36
1418 < RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1418 > RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 53 Codepage = 1252)
1419   RDB$CHARACTER_SET_ID = 37
1420 < RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1420 > RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 53 Codepage = 1252)
1421   RDB$CHARACTER_SET_ID = 38
1422 < RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1422 > RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 53 Codepage = 1252)
1423   RDB$CHARACTER_SET_ID = 39
1424 < RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1424 > RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 53 Codepage = 1252)
1425   RDB$CHARACTER_SET_ID = 40
1426 < RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1426 > RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 53 Codepage = 1252)
1427   RDB$CHARACTER_SET_ID = 44
1428 < RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1428 > RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 53 Codepage = 1252)
1429   RDB$CHARACTER_SET_ID = 45
1430 < RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1430 > RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 53 Codepage = 1252)
1431   RDB$CHARACTER_SET_ID = 46
1432 < RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1432 > RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 53 Codepage = 1252)
1433   RDB$CHARACTER_SET_ID = 47
1434 < RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1434 > RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 53 Codepage = 1252)
1435   RDB$CHARACTER_SET_ID = 48
1436 < RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1436 > RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 53 Codepage = 1252)
1437   RDB$CHARACTER_SET_ID = 49
1438 < RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1438 > RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 53 Codepage = 1252)
1439   RDB$CHARACTER_SET_ID = 50
1440 < RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1440 > RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 53 Codepage = 1252)
1441   RDB$CHARACTER_SET_ID = 51
1442 < RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1442 > RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 53 Codepage = 1252)
1443   RDB$CHARACTER_SET_ID = 52
1444 < RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1444 > RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 53 Codepage = 1252)
1445   RDB$CHARACTER_SET_ID = 53
1446 < RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1446 > RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 53 Codepage = 1252)
1447   RDB$CHARACTER_SET_ID = 54
1448 < RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1448 > RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 53 Codepage = 1252)
1449   RDB$CHARACTER_SET_ID = 55
1450 < RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1450 > RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 53 Codepage = 1252)
1451   RDB$CHARACTER_SET_ID = 56
1452 < RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1452 > RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 53 Codepage = 1252)
1453   RDB$CHARACTER_SET_ID = 57
1454 < RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1454 > RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 53 Codepage = 1252)
1455   RDB$CHARACTER_SET_ID = 58
1456 < RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1456 > RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 53 Codepage = 1252)
1457   RDB$CHARACTER_SET_ID = 59
1458 < RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1458 > RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 53 Codepage = 1252)
1459   RDB$CHARACTER_SET_ID = 60
1460 < RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1460 > RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 53 Codepage = 1252)
1461   RDB$CHARACTER_SET_ID = 63
1462 < RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1462 > RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 53 Codepage = 1252)
1463   RDB$CHARACTER_SET_ID = 64
1464 < RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1464 > RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 53 Codepage = 1252)
1465   RDB$CHARACTER_SET_ID = 65
1466 < RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1466 > RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 53 Codepage = 1252)
1467   RDB$CHARACTER_SET_ID = 66
1468 < RDB$CHARACTER_SET_NAME = GBK (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1468 > RDB$CHARACTER_SET_NAME = GBK (Charset Id = 53 Codepage = 1252)
1469   RDB$CHARACTER_SET_ID = 67
1470 < RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1470 > RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 53 Codepage = 1252)
1471   RDB$CHARACTER_SET_ID = 68
1472 < RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1472 > RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 53 Codepage = 1252)
1473   RDB$CHARACTER_SET_ID = 69
1474  
1475   Metadata
# Line 1300 | Line 1549 | Scale = 0
1549   Charset id = 0
1550   Not Null
1551   Size = 4
1552 + Value = 0
1553  
1554   SQLType =SQL_VARYING
1555   sub type = 0
# Line 1328 | Line 1578 | Size = 8
1578   ROWID = 1
1579   FIXEDPOINT = 20.28
1580   FLOATINGPOINT = 3.14
1581 < TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15)
1581 > TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1582   BLOBDATA = NULL
1583  
1584   SQL Params
# Line 1347 | Line 1597 | Scale = 0
1597   Charset id = 0
1598   Not Null
1599   Size = 4
1600 + Value = 0
1601  
1602   ROWID = 1
1603   FIXEDPOINT = 20.28
1604   FLOATINGPOINT = 3.14
1605 < TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15)
1605 > TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1606   BLOBDATA (Charset Id = 53 Codepage = 1252)
1607  
1608   To be or not to be-that is the question:
# Line 1399 | Line 1650 | Scale = 0
1650   Charset id = 0
1651   Not Null
1652   Size = 4
1653 + Value = 0
1654  
1655   SQLType =SQL_VARYING
1656   sub type = 0
# Line 1427 | Line 1679 | Size = 8
1679   ROWID = 1
1680   FIXEDPOINT = 20.28
1681   FLOATINGPOINT = 3.14
1682 < TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15)
1682 > TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1683   BLOBDATA (Charset Id = 53 Codepage = 1252)
1684  
1685   To be or not to be-that is the question:
# Line 1469 | Line 1721 | Be all my sins remembered
1721   ROWID = 2
1722   FIXEDPOINT = NULL
1723   FLOATINGPOINT = NULL
1724 < TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15)
1724 > TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1725   BLOBDATA (Charset Id = 53 Codepage = 1252)
1726  
1727   To be or not to be-that is the question:
# Line 1594 | Line 1846 | Charset id = 0
1846   Nullable
1847   Size = 2
1848  
1849 < RDB$CHARACTER_SET_NAME = NONE (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1849 > RDB$CHARACTER_SET_NAME = NONE (Charset Id = 3 Codepage = 65001)
1850   RDB$CHARACTER_SET_ID = 0
1851 < RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1851 > RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 3 Codepage = 65001)
1852   RDB$CHARACTER_SET_ID = 1
1853 < RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1853 > RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 3 Codepage = 65001)
1854   RDB$CHARACTER_SET_ID = 2
1855 < RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1855 > RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 3 Codepage = 65001)
1856   RDB$CHARACTER_SET_ID = 3
1857 < RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1857 > RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 3 Codepage = 65001)
1858   RDB$CHARACTER_SET_ID = 4
1859 < RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1859 > RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 3 Codepage = 65001)
1860   RDB$CHARACTER_SET_ID = 5
1861 < RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1861 > RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 3 Codepage = 65001)
1862   RDB$CHARACTER_SET_ID = 6
1863 < RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1863 > RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 3 Codepage = 65001)
1864   RDB$CHARACTER_SET_ID = 9
1865 < RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1865 > RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 3 Codepage = 65001)
1866   RDB$CHARACTER_SET_ID = 10
1867 < RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1867 > RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 3 Codepage = 65001)
1868   RDB$CHARACTER_SET_ID = 11
1869 < RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1869 > RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 3 Codepage = 65001)
1870   RDB$CHARACTER_SET_ID = 12
1871 < RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1871 > RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 3 Codepage = 65001)
1872   RDB$CHARACTER_SET_ID = 13
1873 < RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1873 > RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 3 Codepage = 65001)
1874   RDB$CHARACTER_SET_ID = 14
1875 < RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1875 > RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 3 Codepage = 65001)
1876   RDB$CHARACTER_SET_ID = 15
1877 < RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1877 > RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 3 Codepage = 65001)
1878   RDB$CHARACTER_SET_ID = 16
1879 < RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1879 > RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 3 Codepage = 65001)
1880   RDB$CHARACTER_SET_ID = 17
1881 < RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1881 > RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 3 Codepage = 65001)
1882   RDB$CHARACTER_SET_ID = 18
1883 < RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1883 > RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 3 Codepage = 65001)
1884   RDB$CHARACTER_SET_ID = 19
1885 < RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1885 > RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 3 Codepage = 65001)
1886   RDB$CHARACTER_SET_ID = 21
1887 < RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1887 > RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 3 Codepage = 65001)
1888   RDB$CHARACTER_SET_ID = 22
1889 < RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1889 > RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 3 Codepage = 65001)
1890   RDB$CHARACTER_SET_ID = 23
1891 < RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1891 > RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 3 Codepage = 65001)
1892   RDB$CHARACTER_SET_ID = 34
1893 < RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1893 > RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 3 Codepage = 65001)
1894   RDB$CHARACTER_SET_ID = 35
1895 < RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1895 > RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 3 Codepage = 65001)
1896   RDB$CHARACTER_SET_ID = 36
1897 < RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1897 > RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 3 Codepage = 65001)
1898   RDB$CHARACTER_SET_ID = 37
1899 < RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1899 > RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 3 Codepage = 65001)
1900   RDB$CHARACTER_SET_ID = 38
1901 < RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1901 > RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 3 Codepage = 65001)
1902   RDB$CHARACTER_SET_ID = 39
1903 < RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1903 > RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 3 Codepage = 65001)
1904   RDB$CHARACTER_SET_ID = 40
1905 < RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1905 > RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 3 Codepage = 65001)
1906   RDB$CHARACTER_SET_ID = 44
1907 < RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1907 > RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 3 Codepage = 65001)
1908   RDB$CHARACTER_SET_ID = 45
1909 < RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1909 > RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 3 Codepage = 65001)
1910   RDB$CHARACTER_SET_ID = 46
1911 < RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1911 > RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 3 Codepage = 65001)
1912   RDB$CHARACTER_SET_ID = 47
1913 < RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1913 > RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 3 Codepage = 65001)
1914   RDB$CHARACTER_SET_ID = 48
1915 < RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1915 > RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 3 Codepage = 65001)
1916   RDB$CHARACTER_SET_ID = 49
1917 < RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1917 > RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 3 Codepage = 65001)
1918   RDB$CHARACTER_SET_ID = 50
1919 < RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1919 > RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 3 Codepage = 65001)
1920   RDB$CHARACTER_SET_ID = 51
1921 < RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1921 > RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 3 Codepage = 65001)
1922   RDB$CHARACTER_SET_ID = 52
1923 < RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1923 > RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 3 Codepage = 65001)
1924   RDB$CHARACTER_SET_ID = 53
1925 < RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1925 > RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 3 Codepage = 65001)
1926   RDB$CHARACTER_SET_ID = 54
1927 < RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1927 > RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 3 Codepage = 65001)
1928   RDB$CHARACTER_SET_ID = 55
1929 < RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1929 > RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 3 Codepage = 65001)
1930   RDB$CHARACTER_SET_ID = 56
1931 < RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1931 > RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 3 Codepage = 65001)
1932   RDB$CHARACTER_SET_ID = 57
1933 < RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1933 > RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 3 Codepage = 65001)
1934   RDB$CHARACTER_SET_ID = 58
1935 < RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1935 > RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 3 Codepage = 65001)
1936   RDB$CHARACTER_SET_ID = 59
1937 < RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1937 > RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 3 Codepage = 65001)
1938   RDB$CHARACTER_SET_ID = 60
1939 < RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1939 > RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 3 Codepage = 65001)
1940   RDB$CHARACTER_SET_ID = 63
1941 < RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1941 > RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 3 Codepage = 65001)
1942   RDB$CHARACTER_SET_ID = 64
1943 < RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1943 > RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 3 Codepage = 65001)
1944   RDB$CHARACTER_SET_ID = 65
1945 < RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1945 > RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 3 Codepage = 65001)
1946   RDB$CHARACTER_SET_ID = 66
1947 < RDB$CHARACTER_SET_NAME = GBK (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1947 > RDB$CHARACTER_SET_NAME = GBK (Charset Id = 3 Codepage = 65001)
1948   RDB$CHARACTER_SET_ID = 67
1949 < RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1949 > RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 3 Codepage = 65001)
1950   RDB$CHARACTER_SET_ID = 68
1951 < RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1951 > RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 3 Codepage = 65001)
1952   RDB$CHARACTER_SET_ID = 69
1953  
1954   Metadata
# Line 1776 | Line 2028 | Scale = 0
2028   Charset id = 0
2029   Not Null
2030   Size = 4
2031 + Value = 0
2032  
2033   SQLType =SQL_VARYING
2034   sub type = 0
# Line 1804 | Line 2057 | Size = 8
2057   ROWID = 1
2058   FIXEDPOINT = 20.28
2059   FLOATINGPOINT = 3.14
2060 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2060 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2061   BLOBDATA = NULL
2062  
2063   SQL Params
# Line 1823 | Line 2076 | Scale = 0
2076   Charset id = 0
2077   Not Null
2078   Size = 4
2079 + Value = 0
2080  
2081   ROWID = 1
2082   FIXEDPOINT = 20.28
2083   FLOATINGPOINT = 3.14
2084 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2084 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2085   BLOBDATA (Charset Id = 4 Codepage = 65001)
2086  
2087   To be or not to be-that is the question:
# Line 1875 | Line 2129 | Scale = 0
2129   Charset id = 0
2130   Not Null
2131   Size = 4
2132 + Value = 0
2133  
2134   SQLType =SQL_VARYING
2135   sub type = 0
# Line 1903 | Line 2158 | Size = 8
2158   ROWID = 1
2159   FIXEDPOINT = 20.28
2160   FLOATINGPOINT = 3.14
2161 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2161 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2162   BLOBDATA (Charset Id = 4 Codepage = 65001)
2163  
2164   To be or not to be-that is the question:
# Line 1945 | Line 2200 | Be all my sins remembered
2200   ROWID = 2
2201   FIXEDPOINT = NULL
2202   FLOATINGPOINT = NULL
2203 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2203 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2204   BLOBDATA (Charset Id = 4 Codepage = 65001)
2205  
2206   To be or not to be-that is the question:
# Line 2047 | Line 2302 | Be all my sins remembered
2302  
2303  
2304  
2305 + ------------------------------------------------------
2306   Running Test 7: Create and read back an Array
2307   Metadata
2308   SQLType =SQL_LONG
# Line 2118 | Line 2374 | Column = MYARRAY
2374   Dimensions = 1
2375   Bounds: (0:16)
2376  
2377 + SQLType =SQL_ARRAY
2378 + sub type = 0
2379 + Table = TESTDATA
2380 + Owner = SYSDBA
2381 + Column Name = MYARRAY2
2382 + Alias Name = MYARRAY2
2383 + Field Name = MYARRAY2
2384 + Scale = 0
2385 + Charset id = 0
2386 + Nullable
2387 + Size = 8
2388 + Array Meta Data:
2389 + SQLType =SQL_TIMESTAMP
2390 + Scale = 0
2391 + Charset id = 0
2392 + Size = 8
2393 + Table = TESTDATA
2394 + Column = MYARRAY2
2395 + Dimensions = 1
2396 + Bounds: (0:16)
2397 +
2398 + SQLType =SQL_ARRAY
2399 + sub type = 0
2400 + Table = TESTDATA
2401 + Owner = SYSDBA
2402 + Column Name = MYARRAY3
2403 + Alias Name = MYARRAY3
2404 + Field Name = MYARRAY3
2405 + Scale = 0
2406 + Charset id = 0
2407 + Nullable
2408 + Size = 8
2409 + Array Meta Data:
2410 + SQLType =SQL_INT64
2411 + Scale = -2
2412 + Charset id = 0
2413 + Size = 8
2414 + Table = TESTDATA
2415 + Column = MYARRAY3
2416 + Dimensions = 1
2417 + Bounds: (0:16)
2418 +
2419   SQL Params
2420   SQLType =SQL_LONG
2421   sub type = 0
# Line 2126 | Line 2424 | Scale = 0
2424   Charset id = 0
2425   Not Null
2426   Size = 4
2427 + Value = 0
2428  
2429   SQLType =SQL_VARYING
2430   sub type = 0
# Line 2156 | Line 2455 | Param Name = TITLE
2455   Param Name = DATED
2456   Param Name = NOTES
2457   ROWID = 1
2458 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2459 < DATED = 1/4/2016 09:30:00.100
2460 < NOTES = Écoute moi (Charset Id = 4 Codepage = 65001 Byte Length = 11)
2458 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2459 > DATED = 2016/04/01 09:30:00.1000
2460 > NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
2461   MYARRAY = NULL
2462 + MYARRAY2 = NULL
2463 + MYARRAY3 = NULL
2464  
2465   SQL Params
2466   SQLType =SQL_ARRAY
# Line 2170 | Line 2471 | Charset id = 0
2471   Nullable
2472   Size = 8
2473  
2474 + SQL Params
2475 + SQLType =SQL_ARRAY
2476 + sub type = 0
2477 + Field Name = MYARRAY2
2478 + Scale = 0
2479 + Charset id = 0
2480 + Nullable
2481 + Size = 8
2482 +
2483 + SQL Params
2484 + SQLType =SQL_ARRAY
2485 + sub type = 0
2486 + Field Name = MYARRAY3
2487 + Scale = 0
2488 + Charset id = 0
2489 + Nullable
2490 + Size = 8
2491 +
2492 + Metadata
2493 + SQLType =SQL_LONG
2494 + sub type = 0
2495 + Table = TESTDATA
2496 + Owner = SYSDBA
2497 + Column Name = ROWID
2498 + Alias Name = ROWID
2499 + Field Name = ROWID
2500 + Scale = 0
2501 + Charset id = 0
2502 + Not Null
2503 + Size = 4
2504 +
2505 + SQLType =SQL_VARYING
2506 + sub type = 0
2507 + Table = TESTDATA
2508 + Owner = SYSDBA
2509 + Column Name = TITLE
2510 + Alias Name = TITLE
2511 + Field Name = TITLE
2512 + Scale = 0
2513 + Charset id = 4
2514 + Nullable
2515 + Size = 128
2516 +
2517 + SQLType =SQL_TIMESTAMP
2518 + sub type = 0
2519 + Table = TESTDATA
2520 + Owner = SYSDBA
2521 + Column Name = DATED
2522 + Alias Name = DATED
2523 + Field Name = DATED
2524 + Scale = 0
2525 + Charset id = 0
2526 + Nullable
2527 + Size = 8
2528 +
2529 + SQLType =SQL_VARYING
2530 + sub type = 0
2531 + Table = TESTDATA
2532 + Owner = SYSDBA
2533 + Column Name = NOTES
2534 + Alias Name = NOTES
2535 + Field Name = NOTES
2536 + Scale = 0
2537 + Charset id = 4
2538 + Nullable
2539 + Size = 256
2540 +
2541 + SQLType =SQL_ARRAY
2542 + sub type = 0
2543 + Table = TESTDATA
2544 + Owner = SYSDBA
2545 + Column Name = MYARRAY
2546 + Alias Name = MYARRAY
2547 + Field Name = MYARRAY
2548 + Scale = 0
2549 + Charset id = 0
2550 + Nullable
2551 + Size = 8
2552 + Array Meta Data:
2553 + SQLType =SQL_LONG
2554 + Scale = 0
2555 + Charset id = 0
2556 + Size = 4
2557 + Table = TESTDATA
2558 + Column = MYARRAY
2559 + Dimensions = 1
2560 + Bounds: (0:16)
2561 +
2562 + SQLType =SQL_ARRAY
2563 + sub type = 0
2564 + Table = TESTDATA
2565 + Owner = SYSDBA
2566 + Column Name = MYARRAY2
2567 + Alias Name = MYARRAY2
2568 + Field Name = MYARRAY2
2569 + Scale = 0
2570 + Charset id = 0
2571 + Nullable
2572 + Size = 8
2573 + Array Meta Data:
2574 + SQLType =SQL_TIMESTAMP
2575 + Scale = 0
2576 + Charset id = 0
2577 + Size = 8
2578 + Table = TESTDATA
2579 + Column = MYARRAY2
2580 + Dimensions = 1
2581 + Bounds: (0:16)
2582 +
2583 + SQLType =SQL_ARRAY
2584 + sub type = 0
2585 + Table = TESTDATA
2586 + Owner = SYSDBA
2587 + Column Name = MYARRAY3
2588 + Alias Name = MYARRAY3
2589 + Field Name = MYARRAY3
2590 + Scale = 0
2591 + Charset id = 0
2592 + Nullable
2593 + Size = 8
2594 + Array Meta Data:
2595 + SQLType =SQL_INT64
2596 + Scale = -2
2597 + Charset id = 0
2598 + Size = 8
2599 + Table = TESTDATA
2600 + Column = MYARRAY3
2601 + Dimensions = 1
2602 + Bounds: (0:16)
2603 +
2604   ROWID = 1
2605 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2606 < DATED = 1/4/2016 09:30:00.100
2607 < NOTES = Écoute moi (Charset Id = 4 Codepage = 65001 Byte Length = 11)
2608 < 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 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2606 > DATED = 2016/04/01 09:30:00.1000
2607 > NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
2608 > 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)
2609 >
2610 > 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)
2611 >
2612 > 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)
2613 >
2614  
2615   Shrink to 2:10
2616   Array: (2: 98) (3: 97) (4: 96) (5: 95) (6: 94) (7: 93) (8: 92) (9: 91) (10: 90)
2617 +
2618   Write updated reduced slice
2619   Show update array
2620   ROWID = 1
2621 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2622 < DATED = 1/4/2016 09:30:00.100
2623 < NOTES = Écoute moi (Charset Id = 4 Codepage = 65001 Byte Length = 11)
2624 < 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 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2622 > DATED = 2016/04/01 09:30:00.1000
2623 > NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
2624 > 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)
2625 >
2626 > 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)
2627 >
2628 > 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)
2629  
2630  
2631  
2632 +
2633 + ------------------------------------------------------
2634   Running Test 8: Create and read back an Array with 2 dimensions
2635   Metadata
2636   SQLType =SQL_LONG
# Line 2243 | Line 2686 | Scale = 0
2686   Charset id = 0
2687   Not Null
2688   Size = 4
2689 + Value = 0
2690  
2691   SQLType =SQL_VARYING
2692   sub type = 0
# Line 2253 | Line 2697 | Nullable
2697   Size = 128
2698  
2699   ROWID = 1
2700 < TITLE = 2D Array (Charset Id = 4 Codepage = 65001 Byte Length = 8)
2700 > TITLE = 2D Array (Charset Id = 4 Codepage = 65001)
2701   MYARRAY = NULL
2702  
2703   ROWID = 1
2704 < TITLE = 2D Array (Charset Id = 4 Codepage = 65001 Byte Length = 8)
2705 < 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)
2704 > TITLE = 2D Array (Charset Id = 4 Codepage = 65001)
2705 > 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)
2706 >
2707  
2708  
2709  
2710 + ------------------------------------------------------
2711   Running Test 9: Database Information tests
2712   Database ID = 4 FB = /opt/firebird3.0.5/examples/empbuild/employee.fdb SN = zeus
2713   Pages =307
# Line 2273 | Line 2719 | ODS major = 12
2719   Page Size = 8192
2720   Version = 1: LI-V6.3.5.33220 Firebird 3.0
2721   Database is Read/Write
2722 < Database Created: 9/1/2020 13:13:45
2722 > Database Created: 09/1/2020 13:13:45
2723   Pages Used = 297
2724   Pages Free = 10
2725 < Server Memory = 19195648
2725 > Server Memory = 19195664
2726   Forced Writes  = 1
2727 < Max Memory  = 19316160
2727 > Max Memory  = 19316176
2728   Num Buffers  = 2048
2729   Sweep Interval  = 20000
2730   Logged in Users: SYSDBA,
# Line 2324 | Line 2770 | Update Count Operation Counts
2770   Page Size = 8192
2771  
2772  
2773 + ------------------------------------------------------
2774   Running Test 10: Event Handling
2775   Call Async Wait
2776   Async Wait Called
# Line 2350 | Line 2797 | Event Signalled
2797   Event Counts: TESTEVENT, Count = 1
2798  
2799  
2800 + ------------------------------------------------------
2801   Running Test 11: Services API
2802 + SPB: Item Count = 2
2803 +  user_name = SYSDBA
2804 +  password = masterkey
2805 +
2806   Service Manager Version = 2
2807   Server Version = LI-V3.0.5.33220 Firebird 3.0
2808   Implementation = Firebird/Linux/AMD/Intel/x64
# Line 2372 | Line 2824 | User ID = 0
2824   Group ID = 0
2825  
2826  
2827 < Licence Info:
2376 < feature is not supported
2827 > Licence Info: feature is not supported
2828   -feature is not supported
2829  
2830 < Licence Mask Info:
2380 < feature is not supported
2830 > Licence Mask Info: feature is not supported
2831  
2832   Capabilities = 6
2833  
# Line 2407 | Line 2857 | Database OK
2857   Database Dropped
2858  
2859  
2860 + ------------------------------------------------------
2861   Running Test 12: Character Sets
2862   SQL Params
2863   SQLType =SQL_LONG
# Line 2416 | Line 2867 | Scale = 0
2867   Charset id = 0
2868   Not Null
2869   Size = 4
2870 + Value = 0
2871  
2872   SQLType =SQL_VARYING
2873   sub type = 0
# Line 2465 | Line 2917 | Charset id = 4
2917   Nullable
2918   Size = 16
2919  
2920 + Show Param Values
2921 + SQL Params
2922 + SQLType =SQL_LONG
2923 + sub type = 0
2924 + Field Name = ROWID
2925 + Scale = 0
2926 + Charset id = 0
2927 + Not Null
2928 + Size = 4
2929 + Value = 1
2930 +
2931 + SQLType =SQL_VARYING
2932 + sub type = 0
2933 + Field Name = TITLE
2934 + Scale = 0
2935 + Charset id = 4
2936 + Nullable
2937 + Size = 128
2938 + Value = Blob Test ©€
2939 +
2940 + SQLType =SQL_VARYING
2941 + sub type = 0
2942 + Field Name = NOTES
2943 + Scale = 0
2944 + Charset id = 4
2945 + Nullable
2946 + Size = 256
2947 + Value = Écoute moi
2948 +
2949 + SQLType =SQL_VARYING
2950 + sub type = 1
2951 + Field Name = BLOBDATA
2952 + Scale = 0
2953 + Charset id = 4
2954 + Nullable
2955 + Size = 8192
2956 + Value = Some German Special Characters like ÖÄÜöäüß
2957 +
2958 + SQLType =SQL_BLOB
2959 + sub type = 1
2960 + Field Name = BLOBDATA2
2961 + Scale = 0
2962 + Charset id = 4
2963 + Nullable
2964 + Size = 8
2965 + Value = Some German Special Characters like ÖÄÜöäüß
2966 +
2967 + SQLType =SQL_VARYING
2968 + sub type = 0
2969 + Field Name = INCLEAR
2970 + Scale = 0
2971 + Charset id = 1
2972 + Nullable
2973 + Size = 16
2974 + Value = &Test
2975  
2976 +
2977 + SQLType =SQL_VARYING
2978 + sub type = 0
2979 + Field Name = FIXEDWIDTH
2980 + Scale = 0
2981 + Charset id = 4
2982 + Nullable
2983 + Size = 16
2984 + Value = É
2985 +
2986   Connection Character Set UTF8
2987   ROWID = 1
2988 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2989 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
2988 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
2989 > NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
2990   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)
2991   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)
2992 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
2993 < FIXEDWIDTH = C3 89  (Charset Id = 4 Codepage = 65001 Byte Length = 5)
2992 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
2993 > FIXEDWIDTH = C3 89  (Charset Id = 4 Codepage = 65001)
2994  
2995   Connection Character Set NONE
2996   ROWID = 1
2997 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2998 < NOTES = C9 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 21 Codepage = 28591 Byte Length = 10)
2997 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
2998 > NOTES = C9 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 21 Codepage = 28591)
2999   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)
3000   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)
3001 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3002 < FIXEDWIDTH = C3 89  (Charset Id = 4 Codepage = 65001 Byte Length = 5)
3001 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3002 > FIXEDWIDTH = C3 89  (Charset Id = 4 Codepage = 65001)
3003  
3004   Connection Character Set WIN1252
3005   ROWID = 1
3006 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 A9 80  (Charset Id = 53 Codepage = 1252 Byte Length = 12)
3007 < NOTES = C9 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 53 Codepage = 1252 Byte Length = 10)
3006 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 A9 80  (Charset Id = 53 Codepage = 1252)
3007 > NOTES = C9 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 53 Codepage = 1252)
3008   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)
3009   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)
3010 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3011 < FIXEDWIDTH = C9  (Charset Id = 53 Codepage = 1252 Byte Length = 4)
3010 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3011 > FIXEDWIDTH = C9  (Charset Id = 53 Codepage = 1252)
3012  
3013  
3014  
3015 + ------------------------------------------------------
3016   Running Test 13: Transaction over two databases
3017   Init Database 1
3018   ROWID = 1
3019 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001 Byte Length = 15)
3020 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
3019 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
3020 > NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
3021   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)
3022   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)
3023 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3023 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3024  
3025   Init Database 2
3026   ROWID = 1
3027 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001 Byte Length = 15)
3028 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
3027 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (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 31  (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 31  (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   ROWID = 1
3041 < TITLE = 44 61 74 61 62 61 73 65 32  (Charset Id = 4 Codepage = 65001 Byte Length = 9)
3042 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
3041 > TITLE = 44 61 74 61 62 61 73 65 32  (Charset Id = 4 Codepage = 65001)
3042 > NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
3043   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)
3044   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)
3045 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3045 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3046  
3047  
3048  
3049 + ------------------------------------------------------
3050   Running Test 14: Non select procedures
3051   Default Character set Name = UTF8
3052   Metadata
# Line 2555 | Line 3074 | Nullable
3074   Size = 128
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   Repeat with a different execute transaction
3080  
3081   ROWID = 1
3082 < TITLE = Testing (Charset Id = 4 Codepage = 65001 Byte Length = 7)
3082 > TITLE = Testing (Charset Id = 4 Codepage = 65001)
3083  
3084   Repeat with a original transaction
3085  
3086   ROWID = 1
3087 < TITLE = Testing (Charset Id = 4 Codepage = 65001 Byte Length = 7)
3087 > TITLE = Testing (Charset Id = 4 Codepage = 65001)
3088  
3089  
3090 + ------------------------------------------------------
3091   Running Test 15: Blob Handling and BPBs
3092  
3093   Testdata
3094  
3095   ROWID = 1
3096 < TITLE = Blob Test (Charset Id = 4 Codepage = 65001 Byte Length = 9)
3096 > TITLE = Blob Test (Charset Id = 4 Codepage = 65001)
3097   BLOBDATA = (blob), Length = 92514
3098  
3099 + ROWID = 2
3100 + TITLE = Blob Test with binary string (Charset Id = 4 Codepage = 65001)
3101 + BLOBDATA = (blob), Length = 13
3102 + 0 9 A C9 63 6F 75 74 65 20 6D 6F 69
3103  
3104   Testdata 2
3105  
3106   ROWID = 1
3107 < TITLE = Blob Test (Charset Id = 4 Codepage = 65001 Byte Length = 9)
3107 > TITLE = Blob Test (Charset Id = 4 Codepage = 65001)
3108   BLOBDATA (Charset Id = 4 Codepage = 65001)
3109  
3110   Écoute moi
3111  
3112  
3113  
3114 + ------------------------------------------------------
3115   Running Test 16: Error handling
3116   Invalid Database Name Test
3117 < Error Handled:
2593 < I/O error during "open" operation for file "Malformed Name"
3117 > Error Handled: I/O error during "open" operation for file "Malformed Name"
3118   -Error while trying to open file
3119   -No such file or directory
3120   Invalid User Name Test
3121 < Error Handled:
2598 < Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3121 > Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3122   Invalid password Test
3123 < Error Handled:
2601 < Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3123 > Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3124   Invalid Prepare SQL Test
3125 < Error Handled:
2604 < Dynamic SQL Error
3125 > Error Handled: Dynamic SQL Error
3126   -SQL error code = -206
3127   -Column unknown
3128   -UNKNOWN_DATE
3129   -At line 1, column 21 When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ?
3130   Invalid Open Cursor SQL Test
3131 < Error Handled:
2611 < Dynamic SQL Error
3131 > Error Handled: Dynamic SQL Error
3132   -SQL error code = -206
3133   -Column unknown
3134   -X
# Line 2620 | Line 3140 | Error Handled: Field "EMP_NO" not found
3140   Case sensitive Param SQL  Test
3141   Error Handled: Field "EMP_NO" not found
3142   Invalid Server Name Test
3143 < Error Handled:
2624 < Unable to complete network request to host "unknown".
3143 > Error Handled: Unable to complete network request to host "unknown".
3144   -Failed to locate host machine.
3145   -The specified name was not found in the hosts file or Domain Name Services
3146   Invalid User Name Test
3147 < Error Handled:
2629 < Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3147 > Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3148   Invalid password Test
3149 < Error Handled:
3150 < Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3149 > Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3150 >
3151 >
3152 > ------------------------------------------------------
3153 > Running Test 17: Date/Time tests and Firebird 4 extensions
3154 > FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.5.33220 Firebird 3.0"
3155 > Has Local TZ DB = FALSE
3156 >
3157 > Testdata
3158 >
3159 > Metadata
3160 > SQLType =SQL_LONG
3161 > sub type = 0
3162 > Table = TESTDATA
3163 > Owner = SYSDBA
3164 > Column Name = ROWID
3165 > Alias Name = ROWID
3166 > Field Name = ROWID
3167 > Scale = 0
3168 > Charset id = 0
3169 > Not Null
3170 > Size = 4
3171 >
3172 > SQLType =SQL_TYPE_DATE
3173 > sub type = 0
3174 > Table = TESTDATA
3175 > Owner = SYSDBA
3176 > Column Name = DATECOL
3177 > Alias Name = DATECOL
3178 > Field Name = DATECOL
3179 > Scale = 0
3180 > Charset id = 0
3181 > Nullable
3182 > Size = 4
3183 >
3184 > SQLType =SQL_TYPE_TIME
3185 > sub type = 0
3186 > Table = TESTDATA
3187 > Owner = SYSDBA
3188 > Column Name = TIMECOL
3189 > Alias Name = TIMECOL
3190 > Field Name = TIMECOL
3191 > Scale = 0
3192 > Charset id = 0
3193 > Nullable
3194 > Size = 4
3195 >
3196 > SQLType =SQL_TIMESTAMP
3197 > sub type = 0
3198 > Table = TESTDATA
3199 > Owner = SYSDBA
3200 > Column Name = TIMESTAMPCOL
3201 > Alias Name = TIMESTAMPCOL
3202 > Field Name = TIMESTAMPCOL
3203 > Scale = 0
3204 > Charset id = 0
3205 > Nullable
3206 > Size = 8
3207 >
3208 > ROWID = 1
3209 > DATECOL = 2019/04/01
3210 > TIMECOL = 11:31:05.0001
3211 > TIMESTAMPCOL = 2016/02/29 22:02:35.0001
3212 > ROWID = 2
3213 > DATECOL = 1939/09/03
3214 > TIMECOL = 15:40:00.0002
3215 > TIMESTAMPCOL = 1918/11/11 11:11:00.0000
3216 > ROWID = 3
3217 > DATECOL = 1066/10/14
3218 > TIMECOL = 23:59:59.9994
3219 > TIMESTAMPCOL = 1918/11/11 11:11:00.0000
3220 > ROWID = 4
3221 > DATECOL = 1815/06/18
3222 > TIMECOL = 00:01:40.1115
3223 > TIMESTAMPCOL = 1945/05/08 22:10:00.0010
3224 >
3225 >
3226 > Testdata - second pass
3227 >
3228 > 1, 01/4/2019, 11:31:05, 29/2/2016 22:02:35
3229 > 2, 03/9/1939, 15:40:00.000, 11/11/1918 11:11:00
3230 > 3, 14/10/1066, 23:59:59.999, 11/11/1918 11:11:00
3231 > 4, 18/6/1815, 00:01:40.112, 08/5/1945 22:10:00
3232 > Sys Time = 1945, 5, 8, 2, 22, 10, 0, 1
3233 > Skipping Firebird 4 and later test part
3234 >
3235 >
3236 > ------------------------------------------------------
3237 > Running Test 18: Firebird 4 Decfloat extensions
3238 > FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.5.33220 Firebird 3.0"
3239 > Skipping test for Firebird 4 and later
3240 >
3241 >
3242 > ------------------------------------------------------
3243 > Running Test 19: Batch Update and Insert Queries
3244 > Opening inet://localhost/employee
3245 > Skipping test for Firebird 4 and later
3246 >
3247 >
3248 > ------------------------------------------------------
3249 > Running Test 20: Stress Test IBatch interface
3250 > FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.5.33220 Firebird 3.0"
3251 > Skipping test for Firebird 4 and later
3252  
3253  
3254 + ------------------------------------------------------
3255   Test Suite Ends

Diff Legend

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