ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/public/ibx/trunk/fbintf/testsuite/reference.log
Revision: 263
Committed: Thu Dec 6 15:55:01 2018 UTC (5 years, 4 months ago) by tony
File size: 69145 byte(s)
Log Message: 
Release 2.3.2 committed

File Contents

# Content
1 Firebird API Test Suite
2 Copyright MWA Software 2016
3
4 Starting Tests
5 Client API Version = 3.768
6 Running Test 1: Create and Drop a Database
7 Creating a Database with empty parameters
8 Create Database fails (as expected): I/O error during "open O_CREAT" operation for file ""
9 Error while trying to create file
10 No such file or directory
11 Creating a Database using an SQL Statement
12 Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = mint18-FB3
13 SQL Dialect = 3
14 DB Connect String = localhost:/tmp/fbintf-testsuite/testsuite1.fdb
15 DB Charset ID = 0
16 DB SQL Dialect = 3
17 DB Remote Protocol = TCPv4
18 DB ODS Major Version = 12
19 DB ODS Minor Version = 0
20 User Authentication Method = Srp
21 Firebird Library Path = /usr/lib/libfbclient.so
22 DB Client Implementation Version = 3.768
23 DPB
24 Count = 3
25 28 = SYSDBA
26 29 = masterkey
27 65 = 3
28
29 Dropping Database
30 Creating a Database with a DPD
31 DB Connect String = localhost:/tmp/fbintf-testsuite/testsuite1.fdb
32 DB Charset ID = 4
33 DB SQL Dialect = 3
34 DB Remote Protocol = TCPv4
35 DB ODS Major Version = 12
36 DB ODS Minor Version = 0
37 User Authentication Method = Srp
38 Firebird Library Path = /usr/lib/libfbclient.so
39 DB Client Implementation Version = 3.768
40 Dropping Database
41 DPB
42 Count = 4
43 28 = SYSDBA
44 29 = masterkey
45 48 = UTF8
46 65 = 3
47
48 Creating a Database with a DPD
49 Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = mint18-FB3
50 ODS major = 12
51 ODS minor = 0
52 DB Connect String = localhost:/tmp/fbintf-testsuite/testsuite1.fdb
53 DB Charset ID = 4
54 DB SQL Dialect = 3
55 DB Remote Protocol = TCPv4
56 DB ODS Major Version = 12
57 DB ODS Minor Version = 0
58 User Authentication Method = Srp
59 Firebird Library Path = /usr/lib/libfbclient.so
60 DB Client Implementation Version = 3.768
61 RDB$DESCRIPTION =
62 RDB$RELATION_ID = 128
63 RDB$SECURITY_CLASS = SQL$363
64 RDB$CHARACTER_SET_NAME = UTF8
65 RDB$LINGER =
66 Dropping Database
67
68
69 Running Test 2: Open the employee database and run a query
70 Opening localhost:employee
71 Database Open, SQL Dialect = 3
72 Metadata
73 SQLType =SQL_SHORT
74 sub type = 0
75 Table = EMPLOYEE
76 Owner = SYSDBA
77 Column Name = EMP_NO
78 Alias Name = EMP_NO
79 Field Name = EMP_NO
80 Scale = 0
81 Charset id = 0
82 Not Null
83 Size = 2
84
85 SQLType =SQL_VARYING
86 sub type = 0
87 Table = EMPLOYEE
88 Owner = SYSDBA
89 Column Name = FIRST_NAME
90 Alias Name = FIRST_NAME
91 Field Name = FIRST_NAME
92 Scale = 0
93 Charset id = 0
94 Not Null
95 Size = 15
96
97 SQLType =SQL_VARYING
98 sub type = 0
99 Table = EMPLOYEE
100 Owner = SYSDBA
101 Column Name = LAST_NAME
102 Alias Name = LAST_NAME
103 Field Name = LAST_NAME
104 Scale = 0
105 Charset id = 0
106 Not Null
107 Size = 20
108
109 SQLType =SQL_VARYING
110 sub type = 0
111 Table = EMPLOYEE
112 Owner = SYSDBA
113 Column Name = PHONE_EXT
114 Alias Name = PHONE_EXT
115 Field Name = PHONE_EXT
116 Scale = 0
117 Charset id = 0
118 Nullable
119 Size = 4
120
121 SQLType =SQL_TIMESTAMP
122 sub type = 0
123 Table = EMPLOYEE
124 Owner = SYSDBA
125 Column Name = HIRE_DATE
126 Alias Name = HIRE_DATE
127 Field Name = HIRE_DATE
128 Scale = 0
129 Charset id = 0
130 Not Null
131 Size = 8
132
133 SQLType =SQL_TEXT
134 sub type = 0
135 Table = EMPLOYEE
136 Owner = SYSDBA
137 Column Name = DEPT_NO
138 Alias Name = DEPT_NO
139 Field Name = DEPT_NO
140 Scale = 0
141 Charset id = 0
142 Not Null
143 Size = 3
144
145 SQLType =SQL_VARYING
146 sub type = 0
147 Table = EMPLOYEE
148 Owner = SYSDBA
149 Column Name = JOB_CODE
150 Alias Name = JOB_CODE
151 Field Name = JOB_CODE
152 Scale = 0
153 Charset id = 0
154 Not Null
155 Size = 5
156
157 SQLType =SQL_SHORT
158 sub type = 0
159 Table = EMPLOYEE
160 Owner = SYSDBA
161 Column Name = JOB_GRADE
162 Alias Name = JOB_GRADE
163 Field Name = JOB_GRADE
164 Scale = 0
165 Charset id = 0
166 Not Null
167 Size = 2
168
169 SQLType =SQL_VARYING
170 sub type = 0
171 Table = EMPLOYEE
172 Owner = SYSDBA
173 Column Name = JOB_COUNTRY
174 Alias Name = JOB_COUNTRY
175 Field Name = JOB_COUNTRY
176 Scale = 0
177 Charset id = 0
178 Not Null
179 Size = 15
180
181 SQLType =SQL_INT64
182 sub type = 0
183 Table = EMPLOYEE
184 Owner = SYSDBA
185 Column Name = SALARY
186 Alias Name = SALARY
187 Field Name = SALARY
188 Scale = -2
189 Charset id = 0
190 Not Null
191 Size = 8
192
193 SQLType =SQL_VARYING
194 sub type = 0
195 Table = EMPLOYEE
196 Owner = SYSDBA
197 Column Name = FULL_NAME
198 Alias Name = FULL_NAME
199 Field Name = FULL_NAME
200 Scale = 0
201 Charset id = 0
202 Nullable
203 Size = 37
204
205 Plan =
206 Select Expression
207 -> First N Records
208 -> Table "EMPLOYEE" Full Scan
209 Select First 3 * from EMPLOYEE
210
211 EMP_NO = 2
212 FIRST_NAME = Robert
213 LAST_NAME = Nelson
214 PHONE_EXT = 250
215 HIRE_DATE = 28/12/1988 00:00:00.000
216 DEPT_NO = 600
217 JOB_CODE = VP
218 JOB_GRADE = 2
219 JOB_COUNTRY = USA
220 SALARY = 105,900.00
221 FULL_NAME = Nelson, Robert
222 EMP_NO = 4
223 FIRST_NAME = Bruce
224 LAST_NAME = Young
225 PHONE_EXT = 233
226 HIRE_DATE = 28/12/1988 00:00:00.000
227 DEPT_NO = 621
228 JOB_CODE = Eng
229 JOB_GRADE = 2
230 JOB_COUNTRY = USA
231 SALARY = 97,500.00
232 FULL_NAME = Young, Bruce
233 EMP_NO = 5
234 FIRST_NAME = Kim
235 LAST_NAME = Lambert
236 PHONE_EXT = 22
237 HIRE_DATE = 6/2/1989 00:00:00.000
238 DEPT_NO = 130
239 JOB_CODE = Eng
240 JOB_GRADE = 2
241 JOB_COUNTRY = USA
242 SALARY = 102,750.00
243 FULL_NAME = Lambert, Kim
244
245 Select * from EMPLOYEE Where EMP_NO = ?
246 SQL Params
247 SQLType =SQL_SHORT
248 sub type = 0
249 Field Name =
250 Scale = 0
251 Charset id = 0
252 Not Null
253 Size = 2
254
255 EMP_NO = 8
256 FIRST_NAME = Leslie
257 LAST_NAME = Johnson
258 PHONE_EXT = 410
259 HIRE_DATE = 5/4/1989 00:00:00.000
260 DEPT_NO = 180
261 JOB_CODE = Mktg
262 JOB_GRADE = 3
263 JOB_COUNTRY = USA
264 SALARY = 64,635.00
265 FULL_NAME = Johnson, Leslie
266
267 With param names
268 Select * from EMPLOYEE Where EMP_NO = :EMP_NO
269 SQL Params
270 SQLType =SQL_SHORT
271 sub type = 0
272 Field Name = EMP_NO
273 Scale = 0
274 Charset id = 0
275 Not Null
276 Size = 2
277
278 EMP_NO = 8
279 FIRST_NAME = Leslie
280 LAST_NAME = Johnson
281 PHONE_EXT = 410
282 HIRE_DATE = 5/4/1989 00:00:00.000
283 DEPT_NO = 180
284 JOB_CODE = Mktg
285 JOB_GRADE = 3
286 JOB_COUNTRY = USA
287 SALARY = 64,635.00
288 FULL_NAME = Johnson, Leslie
289
290
291
292 Running Test 3: ad hoc queries
293 Opening localhost:employee
294 Database Open
295 Employee Count = 42
296 Employee Count = 41
297 Employee Count = 42
298 Employee Count = 41
299 Employee Count = 42
300 Constrained Employee Count = 3
301 "Johnson" Employee Count = 2
302 "Yanowski" Employee Count = 1
303
304
305 Running Test 4: Update, Insert and Delete Queries
306 Opening localhost:employee
307 Database Open
308 Select Count = 1 InsertCount = 0 UpdateCount = 1 DeleteCount = 0
309 EMP_NO = 8
310 FIRST_NAME = Leslie
311 LAST_NAME = Johnson
312 PHONE_EXT = 410
313 HIRE_DATE = 5/4/1989 00:00:00.000
314 DEPT_NO = 180
315 JOB_CODE = Mktg
316 JOB_GRADE = 3
317 JOB_COUNTRY = USA
318 SALARY = 64,635.00
319 FULL_NAME = Johnson, Leslie
320
321 Current memory = 19604216
322 Delta memory = 4280
323 Max memory = 19666136
324 Elapsed time= 0.000 sec
325 Cpu = 0.000 sec
326 Buffers = 2048
327 Reads = 0
328 Writes = 0
329 Fetches = 4
330 Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
331 Relation Name = EMPLOYEE
332 Metadata
333 SQLType =SQL_SHORT
334 sub type = 0
335 Table = EMPLOYEE
336 Owner = SYSDBA
337 Column Name = EMP_NO
338 Alias Name = EMP_NO
339 Field Name = EMP_NO
340 Scale = 0
341 Charset id = 0
342 Not Null
343 Size = 2
344
345 SQLType =SQL_VARYING
346 sub type = 0
347 Table = EMPLOYEE
348 Owner = SYSDBA
349 Column Name = FIRST_NAME
350 Alias Name = FIRST_NAME
351 Field Name = FIRST_NAME
352 Scale = 0
353 Charset id = 0
354 Not Null
355 Size = 15
356
357 SQLType =SQL_VARYING
358 sub type = 0
359 Table = EMPLOYEE
360 Owner = SYSDBA
361 Column Name = LAST_NAME
362 Alias Name = LAST_NAME
363 Field Name = LAST_NAME
364 Scale = 0
365 Charset id = 0
366 Not Null
367 Size = 20
368
369 SQLType =SQL_VARYING
370 sub type = 0
371 Table = EMPLOYEE
372 Owner = SYSDBA
373 Column Name = PHONE_EXT
374 Alias Name = PHONE_EXT
375 Field Name = PHONE_EXT
376 Scale = 0
377 Charset id = 0
378 Nullable
379 Size = 4
380
381 SQLType =SQL_TIMESTAMP
382 sub type = 0
383 Table = EMPLOYEE
384 Owner = SYSDBA
385 Column Name = HIRE_DATE
386 Alias Name = HIRE_DATE
387 Field Name = HIRE_DATE
388 Scale = 0
389 Charset id = 0
390 Not Null
391 Size = 8
392
393 SQLType =SQL_TEXT
394 sub type = 0
395 Table = EMPLOYEE
396 Owner = SYSDBA
397 Column Name = DEPT_NO
398 Alias Name = DEPT_NO
399 Field Name = DEPT_NO
400 Scale = 0
401 Charset id = 0
402 Not Null
403 Size = 3
404
405 SQLType =SQL_VARYING
406 sub type = 0
407 Table = EMPLOYEE
408 Owner = SYSDBA
409 Column Name = JOB_CODE
410 Alias Name = JOB_CODE
411 Field Name = JOB_CODE
412 Scale = 0
413 Charset id = 0
414 Not Null
415 Size = 5
416
417 SQLType =SQL_SHORT
418 sub type = 0
419 Table = EMPLOYEE
420 Owner = SYSDBA
421 Column Name = JOB_GRADE
422 Alias Name = JOB_GRADE
423 Field Name = JOB_GRADE
424 Scale = 0
425 Charset id = 0
426 Not Null
427 Size = 2
428
429 SQLType =SQL_VARYING
430 sub type = 0
431 Table = EMPLOYEE
432 Owner = SYSDBA
433 Column Name = JOB_COUNTRY
434 Alias Name = JOB_COUNTRY
435 Field Name = JOB_COUNTRY
436 Scale = 0
437 Charset id = 0
438 Not Null
439 Size = 15
440
441 SQLType =SQL_INT64
442 sub type = 0
443 Table = EMPLOYEE
444 Owner = SYSDBA
445 Column Name = SALARY
446 Alias Name = SALARY
447 Field Name = SALARY
448 Scale = -2
449 Charset id = 0
450 Not Null
451 Size = 8
452
453 SQLType =SQL_VARYING
454 sub type = 0
455 Table = EMPLOYEE
456 Owner = SYSDBA
457 Column Name = FULL_NAME
458 Alias Name = FULL_NAME
459 Field Name = FULL_NAME
460 Scale = 0
461 Charset id = 0
462 Nullable
463 Size = 37
464
465 EMP_NO = 150
466 FIRST_NAME = John
467 LAST_NAME = Doe
468 PHONE_EXT =
469 HIRE_DATE = 1/4/2015 00:00:00.000
470 DEPT_NO = 600
471 JOB_CODE = Eng
472 JOB_GRADE = 4
473 JOB_COUNTRY = England
474 SALARY = 41,000.89
475 FULL_NAME = Doe, John
476
477 Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
478 EMP_NO = 151
479 FIRST_NAME = Major
480 LAST_NAME = Major
481 PHONE_EXT =
482 HIRE_DATE = 1/4/2015 00:00:00.000
483 DEPT_NO = 600
484 JOB_CODE = Eng
485 JOB_GRADE = 4
486 JOB_COUNTRY = England
487 SALARY = 40,000.59
488 FULL_NAME = Major, Major
489
490 Now Delete the rows
491 Select Count = 1 InsertCount = 0 UpdateCount = 0 DeleteCount = 1
492 Select Count = 1 InsertCount = 0 UpdateCount = 0 DeleteCount = 1
493 Inserting
494 Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
495 EMP_NO = 150
496 FIRST_NAME = Jane
497 LAST_NAME = Doe
498 PHONE_EXT = NULL
499 HIRE_DATE = 1/4/2015 00:00:00.000
500 DEPT_NO = 600
501 JOB_CODE = Eng
502 JOB_GRADE = 4
503 JOB_COUNTRY = England
504 SALARY = 41,000.89
505 FULL_NAME = Doe, Jane
506
507 Employee Count = 43
508 Prepare Query again
509
510 EMP_NO = 150
511 FIRST_NAME = Jane
512 LAST_NAME = Doe
513 PHONE_EXT = NULL
514 HIRE_DATE = 1/4/2015 00:00:00.000
515 DEPT_NO = 600
516 JOB_CODE = Eng
517 JOB_GRADE = 4
518 JOB_COUNTRY = England
519 SALARY = 41,000.89
520 FULL_NAME = Doe, Jane
521
522 Prepare Query again with a different transaction
523
524 EMP_NO = 8
525 FIRST_NAME = Leslie
526 LAST_NAME = Johnson
527 PHONE_EXT = 410
528 HIRE_DATE = 5/4/1989 00:00:00.000
529 DEPT_NO = 180
530 JOB_CODE = Mktg
531 JOB_GRADE = 3
532 JOB_COUNTRY = USA
533 SALARY = 64,635.00
534 FULL_NAME = Johnson, Leslie
535
536 Open Cursor with a different transaction
537
538 EMP_NO = 8
539 FIRST_NAME = Leslie
540 LAST_NAME = Johnson
541 PHONE_EXT = 410
542 HIRE_DATE = 5/4/1989 00:00:00.000
543 DEPT_NO = 180
544 JOB_CODE = Mktg
545 JOB_GRADE = 3
546 JOB_COUNTRY = USA
547 SALARY = 64,635.00
548 FULL_NAME = Johnson, Leslie
549 Same Statement - updated params
550 EMP_NO = 9
551 FIRST_NAME = Phil
552 LAST_NAME = Forest
553 PHONE_EXT = 229
554 HIRE_DATE = 17/4/1989 00:00:00.000
555 DEPT_NO = 622
556 JOB_CODE = Mngr
557 JOB_GRADE = 3
558 JOB_COUNTRY = USA
559 SALARY = 75,060.00
560 FULL_NAME = Forest, Phil
561
562 Test using Execute Block
563 Select Count = 1 InsertCount = 0 UpdateCount = 1 DeleteCount = 0
564 EMP_NO = 8
565 FIRST_NAME = Leslie
566 LAST_NAME = Johnson
567 PHONE_EXT = 410
568 HIRE_DATE = 31/1/2015 00:00:00.000
569 DEPT_NO = 180
570 JOB_CODE = Mktg
571 JOB_GRADE = 3
572 JOB_COUNTRY = USA
573 SALARY = 64,635.00
574 FULL_NAME = Johnson, Leslie
575
576
577
578 Running Test 5: Update Returning and Activity Check
579 Opening localhost:employee
580 Database Open
581 Database Closed
582 Database Open
583 Select Count = 1 InsertCount = 0 UpdateCount = 1 DeleteCount = 0
584 Last Name = Johnson
585 EMP_NO = 8
586 FIRST_NAME = Leslie
587 LAST_NAME = Johnson
588 PHONE_EXT = 410
589 HIRE_DATE = 31/1/2016 00:00:00.000
590 DEPT_NO = 180
591 JOB_CODE = Mktg
592 JOB_GRADE = 3
593 JOB_COUNTRY = USA
594 SALARY = 64,635.00
595 FULL_NAME = Johnson, Leslie
596
597 Inserting
598 Full Name = Doe, John
599 Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
600 Database Activity = TRUE
601 Transaction Activity = TRUE
602 Database Activity = FALSE
603 Transaction Activity = FALSE
604 Employee Count = 43
605 Database Activity = TRUE
606 Transaction Activity = TRUE
607 Transaction Active
608 Transaction inactive
609
610
611 Running Test 6: Blob Handling
612 Metadata
613 SQLType =SQL_TEXT
614 sub type = 0
615 Table = RDB$CHARACTER_SETS
616 Owner = SYSDBA
617 Column Name = RDB$CHARACTER_SET_NAME
618 Alias Name = RDB$CHARACTER_SET_NAME
619 Field Name = RDB$CHARACTER_SET_NAME
620 Scale = 0
621 Charset id = 4
622 Nullable
623 Size = 124
624
625 SQLType =SQL_SHORT
626 sub type = 0
627 Table = RDB$CHARACTER_SETS
628 Owner = SYSDBA
629 Column Name = RDB$CHARACTER_SET_ID
630 Alias Name = RDB$CHARACTER_SET_ID
631 Field Name = RDB$CHARACTER_SET_ID
632 Scale = 0
633 Charset id = 0
634 Nullable
635 Size = 2
636
637 RDB$CHARACTER_SET_NAME = NONE (Charset Id = 4 Codepage = 65001)
638 RDB$CHARACTER_SET_ID = 0
639 RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 4 Codepage = 65001)
640 RDB$CHARACTER_SET_ID = 1
641 RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 4 Codepage = 65001)
642 RDB$CHARACTER_SET_ID = 2
643 RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 4 Codepage = 65001)
644 RDB$CHARACTER_SET_ID = 3
645 RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 4 Codepage = 65001)
646 RDB$CHARACTER_SET_ID = 4
647 RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 4 Codepage = 65001)
648 RDB$CHARACTER_SET_ID = 5
649 RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 4 Codepage = 65001)
650 RDB$CHARACTER_SET_ID = 6
651 RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 4 Codepage = 65001)
652 RDB$CHARACTER_SET_ID = 9
653 RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 4 Codepage = 65001)
654 RDB$CHARACTER_SET_ID = 10
655 RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 4 Codepage = 65001)
656 RDB$CHARACTER_SET_ID = 11
657 RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 4 Codepage = 65001)
658 RDB$CHARACTER_SET_ID = 12
659 RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 4 Codepage = 65001)
660 RDB$CHARACTER_SET_ID = 13
661 RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 4 Codepage = 65001)
662 RDB$CHARACTER_SET_ID = 14
663 RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 4 Codepage = 65001)
664 RDB$CHARACTER_SET_ID = 15
665 RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 4 Codepage = 65001)
666 RDB$CHARACTER_SET_ID = 16
667 RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 4 Codepage = 65001)
668 RDB$CHARACTER_SET_ID = 17
669 RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 4 Codepage = 65001)
670 RDB$CHARACTER_SET_ID = 18
671 RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 4 Codepage = 65001)
672 RDB$CHARACTER_SET_ID = 19
673 RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 4 Codepage = 65001)
674 RDB$CHARACTER_SET_ID = 21
675 RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 4 Codepage = 65001)
676 RDB$CHARACTER_SET_ID = 22
677 RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 4 Codepage = 65001)
678 RDB$CHARACTER_SET_ID = 23
679 RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 4 Codepage = 65001)
680 RDB$CHARACTER_SET_ID = 34
681 RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 4 Codepage = 65001)
682 RDB$CHARACTER_SET_ID = 35
683 RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 4 Codepage = 65001)
684 RDB$CHARACTER_SET_ID = 36
685 RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 4 Codepage = 65001)
686 RDB$CHARACTER_SET_ID = 37
687 RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 4 Codepage = 65001)
688 RDB$CHARACTER_SET_ID = 38
689 RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 4 Codepage = 65001)
690 RDB$CHARACTER_SET_ID = 39
691 RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 4 Codepage = 65001)
692 RDB$CHARACTER_SET_ID = 40
693 RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 4 Codepage = 65001)
694 RDB$CHARACTER_SET_ID = 44
695 RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 4 Codepage = 65001)
696 RDB$CHARACTER_SET_ID = 45
697 RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 4 Codepage = 65001)
698 RDB$CHARACTER_SET_ID = 46
699 RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 4 Codepage = 65001)
700 RDB$CHARACTER_SET_ID = 47
701 RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 4 Codepage = 65001)
702 RDB$CHARACTER_SET_ID = 48
703 RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 4 Codepage = 65001)
704 RDB$CHARACTER_SET_ID = 49
705 RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 4 Codepage = 65001)
706 RDB$CHARACTER_SET_ID = 50
707 RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 4 Codepage = 65001)
708 RDB$CHARACTER_SET_ID = 51
709 RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 4 Codepage = 65001)
710 RDB$CHARACTER_SET_ID = 52
711 RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 4 Codepage = 65001)
712 RDB$CHARACTER_SET_ID = 53
713 RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 4 Codepage = 65001)
714 RDB$CHARACTER_SET_ID = 54
715 RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 4 Codepage = 65001)
716 RDB$CHARACTER_SET_ID = 55
717 RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 4 Codepage = 65001)
718 RDB$CHARACTER_SET_ID = 56
719 RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 4 Codepage = 65001)
720 RDB$CHARACTER_SET_ID = 57
721 RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 4 Codepage = 65001)
722 RDB$CHARACTER_SET_ID = 58
723 RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 4 Codepage = 65001)
724 RDB$CHARACTER_SET_ID = 59
725 RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 4 Codepage = 65001)
726 RDB$CHARACTER_SET_ID = 60
727 RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 4 Codepage = 65001)
728 RDB$CHARACTER_SET_ID = 63
729 RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 4 Codepage = 65001)
730 RDB$CHARACTER_SET_ID = 64
731 RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 4 Codepage = 65001)
732 RDB$CHARACTER_SET_ID = 65
733 RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 4 Codepage = 65001)
734 RDB$CHARACTER_SET_ID = 66
735 RDB$CHARACTER_SET_NAME = GBK (Charset Id = 4 Codepage = 65001)
736 RDB$CHARACTER_SET_ID = 67
737 RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 4 Codepage = 65001)
738 RDB$CHARACTER_SET_ID = 68
739 RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 4 Codepage = 65001)
740 RDB$CHARACTER_SET_ID = 69
741
742 Metadata
743 SQLType =SQL_LONG
744 sub type = 0
745 Table = TESTDATA
746 Owner = SYSDBA
747 Column Name = ROWID
748 Alias Name = ROWID
749 Field Name = ROWID
750 Scale = 0
751 Charset id = 0
752 Not Null
753 Size = 4
754
755 SQLType =SQL_LONG
756 sub type = 0
757 Table = TESTDATA
758 Owner = SYSDBA
759 Column Name = FIXEDPOINT
760 Alias Name = FIXEDPOINT
761 Field Name = FIXEDPOINT
762 Scale = -2
763 Charset id = 0
764 Nullable
765 Size = 4
766
767 SQLType =SQL_DOUBLE
768 sub type = 0
769 Table = TESTDATA
770 Owner = SYSDBA
771 Column Name = FLOATINGPOINT
772 Alias Name = FLOATINGPOINT
773 Field Name = FLOATINGPOINT
774 Scale = 0
775 Charset id = 0
776 Nullable
777 Size = 8
778
779 SQLType =SQL_VARYING
780 sub type = 0
781 Table = TESTDATA
782 Owner = SYSDBA
783 Column Name = TITLE
784 Alias Name = TITLE
785 Field Name = TITLE
786 Scale = 0
787 Charset id = 4
788 Nullable
789 Size = 128
790
791 SQLType =SQL_BLOB
792 sub type = 1
793 Table = TESTDATA
794 Owner = SYSDBA
795 Column Name = BLOBDATA
796 Alias Name = BLOBDATA
797 Field Name = BLOBDATA
798 Scale = 0
799 Charset id = 4
800 Nullable
801 Size = 8
802
803 Blob Meta Data
804 SQL SubType =1
805 Table = TESTDATA
806 Column = BLOBDATA
807 CharSetID = 4
808 Segment Size = 80
809
810
811 SQL Params
812 SQLType =SQL_LONG
813 sub type = 0
814 Field Name = ROWID
815 Scale = 0
816 Charset id = 0
817 Not Null
818 Size = 4
819
820 SQLType =SQL_VARYING
821 sub type = 0
822 Field Name = TITLE
823 Scale = 0
824 Charset id = 4
825 Nullable
826 Size = 128
827
828 SQLType =SQL_LONG
829 sub type = 0
830 Field Name = FP
831 Scale = -2
832 Charset id = 0
833 Nullable
834 Size = 4
835
836 SQLType =SQL_DOUBLE
837 sub type = 0
838 Field Name = DP
839 Scale = 0
840 Charset id = 0
841 Nullable
842 Size = 8
843
844 ROWID = 1
845 FIXEDPOINT = 20.28
846 FLOATINGPOINT = 3.14
847 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
848 BLOBDATA = NULL
849
850 SQL Params
851 SQLType =SQL_BLOB
852 sub type = 1
853 Field Name =
854 Scale = 0
855 Charset id = 4
856 Nullable
857 Size = 8
858
859 SQLType =SQL_LONG
860 sub type = 0
861 Field Name =
862 Scale = 0
863 Charset id = 0
864 Not Null
865 Size = 4
866
867 ROWID = 1
868 FIXEDPOINT = 20.28
869 FLOATINGPOINT = 3.14
870 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
871 BLOBDATA (Charset Id = 4 Codepage = 65001)
872
873 To be or not to be-that is the question:
874 Whether 'tis nobler in the mind to suffer
875 The slings and arrows of outrageous fortune,
876 Or to take arms against a sea of troubles,
877 And, by opposing, end them. To die, to sleep-
878 No more-and by a sleep to say we end
879 The heartache and the thousand natural shocks
880 That flesh is heir to-'tis a consummation
881 Devoutly to be wished. To die, to sleep-
882 To sleep, perchance to dream. Aye, there's the rub,
883 For in that sleep of death what dreams may come,
884 When we have shuffled off this mortal coil,
885 Must give us pause. There's the respect
886 That makes calamity of so long life.
887 For who would bear the whips and scorns of time,
888 Th' oppressor's wrong, the proud man's contumely,
889 The pangs of despised love, the law’s delay,
890 The insolence of office, and the spurns
891 That patient merit of the unworthy takes,
892 When he himself might his quietus make
893 With a bare bodkin? Who would fardels bear,
894 To grunt and sweat under a weary life,
895 But that the dread of something after death,
896 The undiscovered country from whose bourn
897 No traveler returns, puzzles the will
898 And makes us rather bear those ills we have
899 Than fly to others that we know not of?
900 Thus conscience does make cowards of us all,
901 And thus the native hue of resolution
902 Is sicklied o'er with the pale cast of thought,
903 And enterprises of great pitch and moment,
904 With this regard their currents turn awry,
905 And lose the name of action.-Soft you now,
906 The fair Ophelia.-Nymph, in thy orisons
907 Be all my sins remembered
908
909
910 SQL Params
911 SQLType =SQL_LONG
912 sub type = 0
913 Field Name = ROWID
914 Scale = 0
915 Charset id = 0
916 Not Null
917 Size = 4
918
919 SQLType =SQL_VARYING
920 sub type = 0
921 Field Name = TITLE
922 Scale = 0
923 Charset id = 4
924 Nullable
925 Size = 128
926
927 SQLType =SQL_LONG
928 sub type = 0
929 Field Name = FP
930 Scale = -2
931 Charset id = 0
932 Nullable
933 Size = 4
934
935 SQLType =SQL_DOUBLE
936 sub type = 0
937 Field Name = DP
938 Scale = 0
939 Charset id = 0
940 Nullable
941 Size = 8
942
943 ROWID = 1
944 FIXEDPOINT = 20.28
945 FLOATINGPOINT = 3.14
946 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
947 BLOBDATA (Charset Id = 4 Codepage = 65001)
948
949 To be or not to be-that is the question:
950 Whether 'tis nobler in the mind to suffer
951 The slings and arrows of outrageous fortune,
952 Or to take arms against a sea of troubles,
953 And, by opposing, end them. To die, to sleep-
954 No more-and by a sleep to say we end
955 The heartache and the thousand natural shocks
956 That flesh is heir to-'tis a consummation
957 Devoutly to be wished. To die, to sleep-
958 To sleep, perchance to dream. Aye, there's the rub,
959 For in that sleep of death what dreams may come,
960 When we have shuffled off this mortal coil,
961 Must give us pause. There's the respect
962 That makes calamity of so long life.
963 For who would bear the whips and scorns of time,
964 Th' oppressor's wrong, the proud man's contumely,
965 The pangs of despised love, the law’s delay,
966 The insolence of office, and the spurns
967 That patient merit of the unworthy takes,
968 When he himself might his quietus make
969 With a bare bodkin? Who would fardels bear,
970 To grunt and sweat under a weary life,
971 But that the dread of something after death,
972 The undiscovered country from whose bourn
973 No traveler returns, puzzles the will
974 And makes us rather bear those ills we have
975 Than fly to others that we know not of?
976 Thus conscience does make cowards of us all,
977 And thus the native hue of resolution
978 Is sicklied o'er with the pale cast of thought,
979 And enterprises of great pitch and moment,
980 With this regard their currents turn awry,
981 And lose the name of action.-Soft you now,
982 The fair Ophelia.-Nymph, in thy orisons
983 Be all my sins remembered
984
985 ROWID = 2
986 FIXEDPOINT = NULL
987 FLOATINGPOINT = NULL
988 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
989 BLOBDATA (Charset Id = 4 Codepage = 65001)
990
991 To be or not to be-that is the question:
992 Whether 'tis nobler in the mind to suffer
993 The slings and arrows of outrageous fortune,
994 Or to take arms against a sea of troubles,
995 And, by opposing, end them. To die, to sleep-
996 No more-and by a sleep to say we end
997 The heartache and the thousand natural shocks
998 That flesh is heir to-'tis a consummation
999 Devoutly to be wished. To die, to sleep-
1000 To sleep, perchance to dream. Aye, there's the rub,
1001 For in that sleep of death what dreams may come,
1002 When we have shuffled off this mortal coil,
1003 Must give us pause. There's the respect
1004 That makes calamity of so long life.
1005 For who would bear the whips and scorns of time,
1006 Th' oppressor's wrong, the proud man's contumely,
1007 The pangs of despised love, the law’s delay,
1008 The insolence of office, and the spurns
1009 That patient merit of the unworthy takes,
1010 When he himself might his quietus make
1011 With a bare bodkin? Who would fardels bear,
1012 To grunt and sweat under a weary life,
1013 But that the dread of something after death,
1014 The undiscovered country from whose bourn
1015 No traveler returns, puzzles the will
1016 And makes us rather bear those ills we have
1017 Than fly to others that we know not of?
1018 Thus conscience does make cowards of us all,
1019 And thus the native hue of resolution
1020 Is sicklied o'er with the pale cast of thought,
1021 And enterprises of great pitch and moment,
1022 With this regard their currents turn awry,
1023 And lose the name of action.-Soft you now,
1024 The fair Ophelia.-Nymph, in thy orisons
1025 Be all my sins remembered
1026
1027
1028 Testing Blob as stored proc parameter
1029 Metadata
1030 SQLType =SQL_BLOB
1031 sub type = 1
1032 Table = TESTPROC
1033 Owner = SYSDBA
1034 Column Name = BLOBDATA
1035 Alias Name = BLOBDATA
1036 Field Name = BLOBDATA
1037 Scale = 0
1038 Charset id = 4
1039 Nullable
1040 Size = 8
1041
1042 Blob Meta Data
1043 SQL SubType =1
1044 Table = TESTPROC
1045 Column = BLOBDATA
1046 CharSetID = 4
1047 Segment Size = 80
1048
1049
1050 BLOBDATA (Charset Id = 4 Codepage = 65001)
1051
1052 To be or not to be-that is the question:
1053 Whether 'tis nobler in the mind to suffer
1054 The slings and arrows of outrageous fortune,
1055 Or to take arms against a sea of troubles,
1056 And, by opposing, end them. To die, to sleep-
1057 No more-and by a sleep to say we end
1058 The heartache and the thousand natural shocks
1059 That flesh is heir to-'tis a consummation
1060 Devoutly to be wished. To die, to sleep-
1061 To sleep, perchance to dream. Aye, there's the rub,
1062 For in that sleep of death what dreams may come,
1063 When we have shuffled off this mortal coil,
1064 Must give us pause. There's the respect
1065 That makes calamity of so long life.
1066 For who would bear the whips and scorns of time,
1067 Th' oppressor's wrong, the proud man's contumely,
1068 The pangs of despised love, the law’s delay,
1069 The insolence of office, and the spurns
1070 That patient merit of the unworthy takes,
1071 When he himself might his quietus make
1072 With a bare bodkin? Who would fardels bear,
1073 To grunt and sweat under a weary life,
1074 But that the dread of something after death,
1075 The undiscovered country from whose bourn
1076 No traveler returns, puzzles the will
1077 And makes us rather bear those ills we have
1078 Than fly to others that we know not of?
1079 Thus conscience does make cowards of us all,
1080 And thus the native hue of resolution
1081 Is sicklied o'er with the pale cast of thought,
1082 And enterprises of great pitch and moment,
1083 With this regard their currents turn awry,
1084 And lose the name of action.-Soft you now,
1085 The fair Ophelia.-Nymph, in thy orisons
1086 Be all my sins remembered
1087
1088 Metadata
1089 SQLType =SQL_TEXT
1090 sub type = 0
1091 Table = RDB$CHARACTER_SETS
1092 Owner = SYSDBA
1093 Column Name = RDB$CHARACTER_SET_NAME
1094 Alias Name = RDB$CHARACTER_SET_NAME
1095 Field Name = RDB$CHARACTER_SET_NAME
1096 Scale = 0
1097 Charset id = 53
1098 Nullable
1099 Size = 31
1100
1101 SQLType =SQL_SHORT
1102 sub type = 0
1103 Table = RDB$CHARACTER_SETS
1104 Owner = SYSDBA
1105 Column Name = RDB$CHARACTER_SET_ID
1106 Alias Name = RDB$CHARACTER_SET_ID
1107 Field Name = RDB$CHARACTER_SET_ID
1108 Scale = 0
1109 Charset id = 0
1110 Nullable
1111 Size = 2
1112
1113 RDB$CHARACTER_SET_NAME = NONE (Charset Id = 53 Codepage = 1252)
1114 RDB$CHARACTER_SET_ID = 0
1115 RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 53 Codepage = 1252)
1116 RDB$CHARACTER_SET_ID = 1
1117 RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 53 Codepage = 1252)
1118 RDB$CHARACTER_SET_ID = 2
1119 RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 53 Codepage = 1252)
1120 RDB$CHARACTER_SET_ID = 3
1121 RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 53 Codepage = 1252)
1122 RDB$CHARACTER_SET_ID = 4
1123 RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 53 Codepage = 1252)
1124 RDB$CHARACTER_SET_ID = 5
1125 RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 53 Codepage = 1252)
1126 RDB$CHARACTER_SET_ID = 6
1127 RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 53 Codepage = 1252)
1128 RDB$CHARACTER_SET_ID = 9
1129 RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 53 Codepage = 1252)
1130 RDB$CHARACTER_SET_ID = 10
1131 RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 53 Codepage = 1252)
1132 RDB$CHARACTER_SET_ID = 11
1133 RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 53 Codepage = 1252)
1134 RDB$CHARACTER_SET_ID = 12
1135 RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 53 Codepage = 1252)
1136 RDB$CHARACTER_SET_ID = 13
1137 RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 53 Codepage = 1252)
1138 RDB$CHARACTER_SET_ID = 14
1139 RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 53 Codepage = 1252)
1140 RDB$CHARACTER_SET_ID = 15
1141 RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 53 Codepage = 1252)
1142 RDB$CHARACTER_SET_ID = 16
1143 RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 53 Codepage = 1252)
1144 RDB$CHARACTER_SET_ID = 17
1145 RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 53 Codepage = 1252)
1146 RDB$CHARACTER_SET_ID = 18
1147 RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 53 Codepage = 1252)
1148 RDB$CHARACTER_SET_ID = 19
1149 RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 53 Codepage = 1252)
1150 RDB$CHARACTER_SET_ID = 21
1151 RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 53 Codepage = 1252)
1152 RDB$CHARACTER_SET_ID = 22
1153 RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 53 Codepage = 1252)
1154 RDB$CHARACTER_SET_ID = 23
1155 RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 53 Codepage = 1252)
1156 RDB$CHARACTER_SET_ID = 34
1157 RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 53 Codepage = 1252)
1158 RDB$CHARACTER_SET_ID = 35
1159 RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 53 Codepage = 1252)
1160 RDB$CHARACTER_SET_ID = 36
1161 RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 53 Codepage = 1252)
1162 RDB$CHARACTER_SET_ID = 37
1163 RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 53 Codepage = 1252)
1164 RDB$CHARACTER_SET_ID = 38
1165 RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 53 Codepage = 1252)
1166 RDB$CHARACTER_SET_ID = 39
1167 RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 53 Codepage = 1252)
1168 RDB$CHARACTER_SET_ID = 40
1169 RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 53 Codepage = 1252)
1170 RDB$CHARACTER_SET_ID = 44
1171 RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 53 Codepage = 1252)
1172 RDB$CHARACTER_SET_ID = 45
1173 RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 53 Codepage = 1252)
1174 RDB$CHARACTER_SET_ID = 46
1175 RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 53 Codepage = 1252)
1176 RDB$CHARACTER_SET_ID = 47
1177 RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 53 Codepage = 1252)
1178 RDB$CHARACTER_SET_ID = 48
1179 RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 53 Codepage = 1252)
1180 RDB$CHARACTER_SET_ID = 49
1181 RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 53 Codepage = 1252)
1182 RDB$CHARACTER_SET_ID = 50
1183 RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 53 Codepage = 1252)
1184 RDB$CHARACTER_SET_ID = 51
1185 RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 53 Codepage = 1252)
1186 RDB$CHARACTER_SET_ID = 52
1187 RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 53 Codepage = 1252)
1188 RDB$CHARACTER_SET_ID = 53
1189 RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 53 Codepage = 1252)
1190 RDB$CHARACTER_SET_ID = 54
1191 RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 53 Codepage = 1252)
1192 RDB$CHARACTER_SET_ID = 55
1193 RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 53 Codepage = 1252)
1194 RDB$CHARACTER_SET_ID = 56
1195 RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 53 Codepage = 1252)
1196 RDB$CHARACTER_SET_ID = 57
1197 RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 53 Codepage = 1252)
1198 RDB$CHARACTER_SET_ID = 58
1199 RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 53 Codepage = 1252)
1200 RDB$CHARACTER_SET_ID = 59
1201 RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 53 Codepage = 1252)
1202 RDB$CHARACTER_SET_ID = 60
1203 RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 53 Codepage = 1252)
1204 RDB$CHARACTER_SET_ID = 63
1205 RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 53 Codepage = 1252)
1206 RDB$CHARACTER_SET_ID = 64
1207 RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 53 Codepage = 1252)
1208 RDB$CHARACTER_SET_ID = 65
1209 RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 53 Codepage = 1252)
1210 RDB$CHARACTER_SET_ID = 66
1211 RDB$CHARACTER_SET_NAME = GBK (Charset Id = 53 Codepage = 1252)
1212 RDB$CHARACTER_SET_ID = 67
1213 RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 53 Codepage = 1252)
1214 RDB$CHARACTER_SET_ID = 68
1215 RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 53 Codepage = 1252)
1216 RDB$CHARACTER_SET_ID = 69
1217
1218 Metadata
1219 SQLType =SQL_LONG
1220 sub type = 0
1221 Table = TESTDATA
1222 Owner = SYSDBA
1223 Column Name = ROWID
1224 Alias Name = ROWID
1225 Field Name = ROWID
1226 Scale = 0
1227 Charset id = 0
1228 Not Null
1229 Size = 4
1230
1231 SQLType =SQL_LONG
1232 sub type = 0
1233 Table = TESTDATA
1234 Owner = SYSDBA
1235 Column Name = FIXEDPOINT
1236 Alias Name = FIXEDPOINT
1237 Field Name = FIXEDPOINT
1238 Scale = -2
1239 Charset id = 0
1240 Nullable
1241 Size = 4
1242
1243 SQLType =SQL_DOUBLE
1244 sub type = 0
1245 Table = TESTDATA
1246 Owner = SYSDBA
1247 Column Name = FLOATINGPOINT
1248 Alias Name = FLOATINGPOINT
1249 Field Name = FLOATINGPOINT
1250 Scale = 0
1251 Charset id = 0
1252 Nullable
1253 Size = 8
1254
1255 SQLType =SQL_VARYING
1256 sub type = 0
1257 Table = TESTDATA
1258 Owner = SYSDBA
1259 Column Name = TITLE
1260 Alias Name = TITLE
1261 Field Name = TITLE
1262 Scale = 0
1263 Charset id = 53
1264 Nullable
1265 Size = 32
1266
1267 SQLType =SQL_BLOB
1268 sub type = 1
1269 Table = TESTDATA
1270 Owner = SYSDBA
1271 Column Name = BLOBDATA
1272 Alias Name = BLOBDATA
1273 Field Name = BLOBDATA
1274 Scale = 0
1275 Charset id = 53
1276 Nullable
1277 Size = 8
1278
1279 Blob Meta Data
1280 SQL SubType =1
1281 Table = TESTDATA
1282 Column = BLOBDATA
1283 CharSetID = 53
1284 Segment Size = 80
1285
1286
1287 SQL Params
1288 SQLType =SQL_LONG
1289 sub type = 0
1290 Field Name = ROWID
1291 Scale = 0
1292 Charset id = 0
1293 Not Null
1294 Size = 4
1295
1296 SQLType =SQL_VARYING
1297 sub type = 0
1298 Field Name = TITLE
1299 Scale = 0
1300 Charset id = 53
1301 Nullable
1302 Size = 32
1303
1304 SQLType =SQL_LONG
1305 sub type = 0
1306 Field Name = FP
1307 Scale = -2
1308 Charset id = 0
1309 Nullable
1310 Size = 4
1311
1312 SQLType =SQL_DOUBLE
1313 sub type = 0
1314 Field Name = DP
1315 Scale = 0
1316 Charset id = 0
1317 Nullable
1318 Size = 8
1319
1320 ROWID = 1
1321 FIXEDPOINT = 20.28
1322 FLOATINGPOINT = 3.14
1323 TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1324 BLOBDATA = NULL
1325
1326 SQL Params
1327 SQLType =SQL_BLOB
1328 sub type = 1
1329 Field Name =
1330 Scale = 0
1331 Charset id = 53
1332 Nullable
1333 Size = 8
1334
1335 SQLType =SQL_LONG
1336 sub type = 0
1337 Field Name =
1338 Scale = 0
1339 Charset id = 0
1340 Not Null
1341 Size = 4
1342
1343 ROWID = 1
1344 FIXEDPOINT = 20.28
1345 FLOATINGPOINT = 3.14
1346 TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1347 BLOBDATA (Charset Id = 53 Codepage = 1252)
1348
1349 To be or not to be-that is the question:
1350 Whether 'tis nobler in the mind to suffer
1351 The slings and arrows of outrageous fortune,
1352 Or to take arms against a sea of troubles,
1353 And, by opposing, end them. To die, to sleep-
1354 No more-and by a sleep to say we end
1355 The heartache and the thousand natural shocks
1356 That flesh is heir to-'tis a consummation
1357 Devoutly to be wished. To die, to sleep-
1358 To sleep, perchance to dream. Aye, there's the rub,
1359 For in that sleep of death what dreams may come,
1360 When we have shuffled off this mortal coil,
1361 Must give us pause. There's the respect
1362 That makes calamity of so long life.
1363 For who would bear the whips and scorns of time,
1364 Th' oppressor's wrong, the proud man's contumely,
1365 The pangs of despised love, the law’s delay,
1366 The insolence of office, and the spurns
1367 That patient merit of the unworthy takes,
1368 When he himself might his quietus make
1369 With a bare bodkin? Who would fardels bear,
1370 To grunt and sweat under a weary life,
1371 But that the dread of something after death,
1372 The undiscovered country from whose bourn
1373 No traveler returns, puzzles the will
1374 And makes us rather bear those ills we have
1375 Than fly to others that we know not of?
1376 Thus conscience does make cowards of us all,
1377 And thus the native hue of resolution
1378 Is sicklied o'er with the pale cast of thought,
1379 And enterprises of great pitch and moment,
1380 With this regard their currents turn awry,
1381 And lose the name of action.-Soft you now,
1382 The fair Ophelia.-Nymph, in thy orisons
1383 Be all my sins remembered
1384
1385
1386 SQL Params
1387 SQLType =SQL_LONG
1388 sub type = 0
1389 Field Name = ROWID
1390 Scale = 0
1391 Charset id = 0
1392 Not Null
1393 Size = 4
1394
1395 SQLType =SQL_VARYING
1396 sub type = 0
1397 Field Name = TITLE
1398 Scale = 0
1399 Charset id = 53
1400 Nullable
1401 Size = 32
1402
1403 SQLType =SQL_LONG
1404 sub type = 0
1405 Field Name = FP
1406 Scale = -2
1407 Charset id = 0
1408 Nullable
1409 Size = 4
1410
1411 SQLType =SQL_DOUBLE
1412 sub type = 0
1413 Field Name = DP
1414 Scale = 0
1415 Charset id = 0
1416 Nullable
1417 Size = 8
1418
1419 ROWID = 1
1420 FIXEDPOINT = 20.28
1421 FLOATINGPOINT = 3.14
1422 TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1423 BLOBDATA (Charset Id = 53 Codepage = 1252)
1424
1425 To be or not to be-that is the question:
1426 Whether 'tis nobler in the mind to suffer
1427 The slings and arrows of outrageous fortune,
1428 Or to take arms against a sea of troubles,
1429 And, by opposing, end them. To die, to sleep-
1430 No more-and by a sleep to say we end
1431 The heartache and the thousand natural shocks
1432 That flesh is heir to-'tis a consummation
1433 Devoutly to be wished. To die, to sleep-
1434 To sleep, perchance to dream. Aye, there's the rub,
1435 For in that sleep of death what dreams may come,
1436 When we have shuffled off this mortal coil,
1437 Must give us pause. There's the respect
1438 That makes calamity of so long life.
1439 For who would bear the whips and scorns of time,
1440 Th' oppressor's wrong, the proud man's contumely,
1441 The pangs of despised love, the law’s delay,
1442 The insolence of office, and the spurns
1443 That patient merit of the unworthy takes,
1444 When he himself might his quietus make
1445 With a bare bodkin? Who would fardels bear,
1446 To grunt and sweat under a weary life,
1447 But that the dread of something after death,
1448 The undiscovered country from whose bourn
1449 No traveler returns, puzzles the will
1450 And makes us rather bear those ills we have
1451 Than fly to others that we know not of?
1452 Thus conscience does make cowards of us all,
1453 And thus the native hue of resolution
1454 Is sicklied o'er with the pale cast of thought,
1455 And enterprises of great pitch and moment,
1456 With this regard their currents turn awry,
1457 And lose the name of action.-Soft you now,
1458 The fair Ophelia.-Nymph, in thy orisons
1459 Be all my sins remembered
1460
1461 ROWID = 2
1462 FIXEDPOINT = NULL
1463 FLOATINGPOINT = NULL
1464 TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1465 BLOBDATA (Charset Id = 53 Codepage = 1252)
1466
1467 To be or not to be-that is the question:
1468 Whether 'tis nobler in the mind to suffer
1469 The slings and arrows of outrageous fortune,
1470 Or to take arms against a sea of troubles,
1471 And, by opposing, end them. To die, to sleep-
1472 No more-and by a sleep to say we end
1473 The heartache and the thousand natural shocks
1474 That flesh is heir to-'tis a consummation
1475 Devoutly to be wished. To die, to sleep-
1476 To sleep, perchance to dream. Aye, there's the rub,
1477 For in that sleep of death what dreams may come,
1478 When we have shuffled off this mortal coil,
1479 Must give us pause. There's the respect
1480 That makes calamity of so long life.
1481 For who would bear the whips and scorns of time,
1482 Th' oppressor's wrong, the proud man's contumely,
1483 The pangs of despised love, the law’s delay,
1484 The insolence of office, and the spurns
1485 That patient merit of the unworthy takes,
1486 When he himself might his quietus make
1487 With a bare bodkin? Who would fardels bear,
1488 To grunt and sweat under a weary life,
1489 But that the dread of something after death,
1490 The undiscovered country from whose bourn
1491 No traveler returns, puzzles the will
1492 And makes us rather bear those ills we have
1493 Than fly to others that we know not of?
1494 Thus conscience does make cowards of us all,
1495 And thus the native hue of resolution
1496 Is sicklied o'er with the pale cast of thought,
1497 And enterprises of great pitch and moment,
1498 With this regard their currents turn awry,
1499 And lose the name of action.-Soft you now,
1500 The fair Ophelia.-Nymph, in thy orisons
1501 Be all my sins remembered
1502
1503
1504 Testing Blob as stored proc parameter
1505 Metadata
1506 SQLType =SQL_BLOB
1507 sub type = 1
1508 Table = TESTPROC
1509 Owner = SYSDBA
1510 Column Name = BLOBDATA
1511 Alias Name = BLOBDATA
1512 Field Name = BLOBDATA
1513 Scale = 0
1514 Charset id = 53
1515 Nullable
1516 Size = 8
1517
1518 Blob Meta Data
1519 SQL SubType =1
1520 Table = TESTPROC
1521 Column = BLOBDATA
1522 CharSetID = 53
1523 Segment Size = 80
1524
1525
1526 BLOBDATA (Charset Id = 53 Codepage = 1252)
1527
1528 To be or not to be-that is the question:
1529 Whether 'tis nobler in the mind to suffer
1530 The slings and arrows of outrageous fortune,
1531 Or to take arms against a sea of troubles,
1532 And, by opposing, end them. To die, to sleep-
1533 No more-and by a sleep to say we end
1534 The heartache and the thousand natural shocks
1535 That flesh is heir to-'tis a consummation
1536 Devoutly to be wished. To die, to sleep-
1537 To sleep, perchance to dream. Aye, there's the rub,
1538 For in that sleep of death what dreams may come,
1539 When we have shuffled off this mortal coil,
1540 Must give us pause. There's the respect
1541 That makes calamity of so long life.
1542 For who would bear the whips and scorns of time,
1543 Th' oppressor's wrong, the proud man's contumely,
1544 The pangs of despised love, the law’s delay,
1545 The insolence of office, and the spurns
1546 That patient merit of the unworthy takes,
1547 When he himself might his quietus make
1548 With a bare bodkin? Who would fardels bear,
1549 To grunt and sweat under a weary life,
1550 But that the dread of something after death,
1551 The undiscovered country from whose bourn
1552 No traveler returns, puzzles the will
1553 And makes us rather bear those ills we have
1554 Than fly to others that we know not of?
1555 Thus conscience does make cowards of us all,
1556 And thus the native hue of resolution
1557 Is sicklied o'er with the pale cast of thought,
1558 And enterprises of great pitch and moment,
1559 With this regard their currents turn awry,
1560 And lose the name of action.-Soft you now,
1561 The fair Ophelia.-Nymph, in thy orisons
1562 Be all my sins remembered
1563
1564 Metadata
1565 SQLType =SQL_TEXT
1566 sub type = 0
1567 Table = RDB$CHARACTER_SETS
1568 Owner = SYSDBA
1569 Column Name = RDB$CHARACTER_SET_NAME
1570 Alias Name = RDB$CHARACTER_SET_NAME
1571 Field Name = RDB$CHARACTER_SET_NAME
1572 Scale = 0
1573 Charset id = 3
1574 Nullable
1575 Size = 93
1576
1577 SQLType =SQL_SHORT
1578 sub type = 0
1579 Table = RDB$CHARACTER_SETS
1580 Owner = SYSDBA
1581 Column Name = RDB$CHARACTER_SET_ID
1582 Alias Name = RDB$CHARACTER_SET_ID
1583 Field Name = RDB$CHARACTER_SET_ID
1584 Scale = 0
1585 Charset id = 0
1586 Nullable
1587 Size = 2
1588
1589 RDB$CHARACTER_SET_NAME = NONE (Charset Id = 3 Codepage = 65001)
1590 RDB$CHARACTER_SET_ID = 0
1591 RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 3 Codepage = 65001)
1592 RDB$CHARACTER_SET_ID = 1
1593 RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 3 Codepage = 65001)
1594 RDB$CHARACTER_SET_ID = 2
1595 RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 3 Codepage = 65001)
1596 RDB$CHARACTER_SET_ID = 3
1597 RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 3 Codepage = 65001)
1598 RDB$CHARACTER_SET_ID = 4
1599 RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 3 Codepage = 65001)
1600 RDB$CHARACTER_SET_ID = 5
1601 RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 3 Codepage = 65001)
1602 RDB$CHARACTER_SET_ID = 6
1603 RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 3 Codepage = 65001)
1604 RDB$CHARACTER_SET_ID = 9
1605 RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 3 Codepage = 65001)
1606 RDB$CHARACTER_SET_ID = 10
1607 RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 3 Codepage = 65001)
1608 RDB$CHARACTER_SET_ID = 11
1609 RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 3 Codepage = 65001)
1610 RDB$CHARACTER_SET_ID = 12
1611 RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 3 Codepage = 65001)
1612 RDB$CHARACTER_SET_ID = 13
1613 RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 3 Codepage = 65001)
1614 RDB$CHARACTER_SET_ID = 14
1615 RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 3 Codepage = 65001)
1616 RDB$CHARACTER_SET_ID = 15
1617 RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 3 Codepage = 65001)
1618 RDB$CHARACTER_SET_ID = 16
1619 RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 3 Codepage = 65001)
1620 RDB$CHARACTER_SET_ID = 17
1621 RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 3 Codepage = 65001)
1622 RDB$CHARACTER_SET_ID = 18
1623 RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 3 Codepage = 65001)
1624 RDB$CHARACTER_SET_ID = 19
1625 RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 3 Codepage = 65001)
1626 RDB$CHARACTER_SET_ID = 21
1627 RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 3 Codepage = 65001)
1628 RDB$CHARACTER_SET_ID = 22
1629 RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 3 Codepage = 65001)
1630 RDB$CHARACTER_SET_ID = 23
1631 RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 3 Codepage = 65001)
1632 RDB$CHARACTER_SET_ID = 34
1633 RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 3 Codepage = 65001)
1634 RDB$CHARACTER_SET_ID = 35
1635 RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 3 Codepage = 65001)
1636 RDB$CHARACTER_SET_ID = 36
1637 RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 3 Codepage = 65001)
1638 RDB$CHARACTER_SET_ID = 37
1639 RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 3 Codepage = 65001)
1640 RDB$CHARACTER_SET_ID = 38
1641 RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 3 Codepage = 65001)
1642 RDB$CHARACTER_SET_ID = 39
1643 RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 3 Codepage = 65001)
1644 RDB$CHARACTER_SET_ID = 40
1645 RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 3 Codepage = 65001)
1646 RDB$CHARACTER_SET_ID = 44
1647 RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 3 Codepage = 65001)
1648 RDB$CHARACTER_SET_ID = 45
1649 RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 3 Codepage = 65001)
1650 RDB$CHARACTER_SET_ID = 46
1651 RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 3 Codepage = 65001)
1652 RDB$CHARACTER_SET_ID = 47
1653 RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 3 Codepage = 65001)
1654 RDB$CHARACTER_SET_ID = 48
1655 RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 3 Codepage = 65001)
1656 RDB$CHARACTER_SET_ID = 49
1657 RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 3 Codepage = 65001)
1658 RDB$CHARACTER_SET_ID = 50
1659 RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 3 Codepage = 65001)
1660 RDB$CHARACTER_SET_ID = 51
1661 RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 3 Codepage = 65001)
1662 RDB$CHARACTER_SET_ID = 52
1663 RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 3 Codepage = 65001)
1664 RDB$CHARACTER_SET_ID = 53
1665 RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 3 Codepage = 65001)
1666 RDB$CHARACTER_SET_ID = 54
1667 RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 3 Codepage = 65001)
1668 RDB$CHARACTER_SET_ID = 55
1669 RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 3 Codepage = 65001)
1670 RDB$CHARACTER_SET_ID = 56
1671 RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 3 Codepage = 65001)
1672 RDB$CHARACTER_SET_ID = 57
1673 RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 3 Codepage = 65001)
1674 RDB$CHARACTER_SET_ID = 58
1675 RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 3 Codepage = 65001)
1676 RDB$CHARACTER_SET_ID = 59
1677 RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 3 Codepage = 65001)
1678 RDB$CHARACTER_SET_ID = 60
1679 RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 3 Codepage = 65001)
1680 RDB$CHARACTER_SET_ID = 63
1681 RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 3 Codepage = 65001)
1682 RDB$CHARACTER_SET_ID = 64
1683 RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 3 Codepage = 65001)
1684 RDB$CHARACTER_SET_ID = 65
1685 RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 3 Codepage = 65001)
1686 RDB$CHARACTER_SET_ID = 66
1687 RDB$CHARACTER_SET_NAME = GBK (Charset Id = 3 Codepage = 65001)
1688 RDB$CHARACTER_SET_ID = 67
1689 RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 3 Codepage = 65001)
1690 RDB$CHARACTER_SET_ID = 68
1691 RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 3 Codepage = 65001)
1692 RDB$CHARACTER_SET_ID = 69
1693
1694 Metadata
1695 SQLType =SQL_LONG
1696 sub type = 0
1697 Table = TESTDATA
1698 Owner = SYSDBA
1699 Column Name = ROWID
1700 Alias Name = ROWID
1701 Field Name = ROWID
1702 Scale = 0
1703 Charset id = 0
1704 Not Null
1705 Size = 4
1706
1707 SQLType =SQL_LONG
1708 sub type = 0
1709 Table = TESTDATA
1710 Owner = SYSDBA
1711 Column Name = FIXEDPOINT
1712 Alias Name = FIXEDPOINT
1713 Field Name = FIXEDPOINT
1714 Scale = -2
1715 Charset id = 0
1716 Nullable
1717 Size = 4
1718
1719 SQLType =SQL_DOUBLE
1720 sub type = 0
1721 Table = TESTDATA
1722 Owner = SYSDBA
1723 Column Name = FLOATINGPOINT
1724 Alias Name = FLOATINGPOINT
1725 Field Name = FLOATINGPOINT
1726 Scale = 0
1727 Charset id = 0
1728 Nullable
1729 Size = 8
1730
1731 SQLType =SQL_VARYING
1732 sub type = 0
1733 Table = TESTDATA
1734 Owner = SYSDBA
1735 Column Name = TITLE
1736 Alias Name = TITLE
1737 Field Name = TITLE
1738 Scale = 0
1739 Charset id = 4
1740 Nullable
1741 Size = 128
1742
1743 SQLType =SQL_BLOB
1744 sub type = 1
1745 Table = TESTDATA
1746 Owner = SYSDBA
1747 Column Name = BLOBDATA
1748 Alias Name = BLOBDATA
1749 Field Name = BLOBDATA
1750 Scale = 0
1751 Charset id = 4
1752 Nullable
1753 Size = 8
1754
1755 Blob Meta Data
1756 SQL SubType =1
1757 Table = TESTDATA
1758 Column = BLOBDATA
1759 CharSetID = 4
1760 Segment Size = 80
1761
1762
1763 SQL Params
1764 SQLType =SQL_LONG
1765 sub type = 0
1766 Field Name = ROWID
1767 Scale = 0
1768 Charset id = 0
1769 Not Null
1770 Size = 4
1771
1772 SQLType =SQL_VARYING
1773 sub type = 0
1774 Field Name = TITLE
1775 Scale = 0
1776 Charset id = 4
1777 Nullable
1778 Size = 128
1779
1780 SQLType =SQL_LONG
1781 sub type = 0
1782 Field Name = FP
1783 Scale = -2
1784 Charset id = 0
1785 Nullable
1786 Size = 4
1787
1788 SQLType =SQL_DOUBLE
1789 sub type = 0
1790 Field Name = DP
1791 Scale = 0
1792 Charset id = 0
1793 Nullable
1794 Size = 8
1795
1796 ROWID = 1
1797 FIXEDPOINT = 20.28
1798 FLOATINGPOINT = 3.14
1799 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1800 BLOBDATA = NULL
1801
1802 SQL Params
1803 SQLType =SQL_BLOB
1804 sub type = 1
1805 Field Name =
1806 Scale = 0
1807 Charset id = 4
1808 Nullable
1809 Size = 8
1810
1811 SQLType =SQL_LONG
1812 sub type = 0
1813 Field Name =
1814 Scale = 0
1815 Charset id = 0
1816 Not Null
1817 Size = 4
1818
1819 ROWID = 1
1820 FIXEDPOINT = 20.28
1821 FLOATINGPOINT = 3.14
1822 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1823 BLOBDATA (Charset Id = 4 Codepage = 65001)
1824
1825 To be or not to be-that is the question:
1826 Whether 'tis nobler in the mind to suffer
1827 The slings and arrows of outrageous fortune,
1828 Or to take arms against a sea of troubles,
1829 And, by opposing, end them. To die, to sleep-
1830 No more-and by a sleep to say we end
1831 The heartache and the thousand natural shocks
1832 That flesh is heir to-'tis a consummation
1833 Devoutly to be wished. To die, to sleep-
1834 To sleep, perchance to dream. Aye, there's the rub,
1835 For in that sleep of death what dreams may come,
1836 When we have shuffled off this mortal coil,
1837 Must give us pause. There's the respect
1838 That makes calamity of so long life.
1839 For who would bear the whips and scorns of time,
1840 Th' oppressor's wrong, the proud man's contumely,
1841 The pangs of despised love, the law’s delay,
1842 The insolence of office, and the spurns
1843 That patient merit of the unworthy takes,
1844 When he himself might his quietus make
1845 With a bare bodkin? Who would fardels bear,
1846 To grunt and sweat under a weary life,
1847 But that the dread of something after death,
1848 The undiscovered country from whose bourn
1849 No traveler returns, puzzles the will
1850 And makes us rather bear those ills we have
1851 Than fly to others that we know not of?
1852 Thus conscience does make cowards of us all,
1853 And thus the native hue of resolution
1854 Is sicklied o'er with the pale cast of thought,
1855 And enterprises of great pitch and moment,
1856 With this regard their currents turn awry,
1857 And lose the name of action.-Soft you now,
1858 The fair Ophelia.-Nymph, in thy orisons
1859 Be all my sins remembered
1860
1861
1862 SQL Params
1863 SQLType =SQL_LONG
1864 sub type = 0
1865 Field Name = ROWID
1866 Scale = 0
1867 Charset id = 0
1868 Not Null
1869 Size = 4
1870
1871 SQLType =SQL_VARYING
1872 sub type = 0
1873 Field Name = TITLE
1874 Scale = 0
1875 Charset id = 4
1876 Nullable
1877 Size = 128
1878
1879 SQLType =SQL_LONG
1880 sub type = 0
1881 Field Name = FP
1882 Scale = -2
1883 Charset id = 0
1884 Nullable
1885 Size = 4
1886
1887 SQLType =SQL_DOUBLE
1888 sub type = 0
1889 Field Name = DP
1890 Scale = 0
1891 Charset id = 0
1892 Nullable
1893 Size = 8
1894
1895 ROWID = 1
1896 FIXEDPOINT = 20.28
1897 FLOATINGPOINT = 3.14
1898 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1899 BLOBDATA (Charset Id = 4 Codepage = 65001)
1900
1901 To be or not to be-that is the question:
1902 Whether 'tis nobler in the mind to suffer
1903 The slings and arrows of outrageous fortune,
1904 Or to take arms against a sea of troubles,
1905 And, by opposing, end them. To die, to sleep-
1906 No more-and by a sleep to say we end
1907 The heartache and the thousand natural shocks
1908 That flesh is heir to-'tis a consummation
1909 Devoutly to be wished. To die, to sleep-
1910 To sleep, perchance to dream. Aye, there's the rub,
1911 For in that sleep of death what dreams may come,
1912 When we have shuffled off this mortal coil,
1913 Must give us pause. There's the respect
1914 That makes calamity of so long life.
1915 For who would bear the whips and scorns of time,
1916 Th' oppressor's wrong, the proud man's contumely,
1917 The pangs of despised love, the law’s delay,
1918 The insolence of office, and the spurns
1919 That patient merit of the unworthy takes,
1920 When he himself might his quietus make
1921 With a bare bodkin? Who would fardels bear,
1922 To grunt and sweat under a weary life,
1923 But that the dread of something after death,
1924 The undiscovered country from whose bourn
1925 No traveler returns, puzzles the will
1926 And makes us rather bear those ills we have
1927 Than fly to others that we know not of?
1928 Thus conscience does make cowards of us all,
1929 And thus the native hue of resolution
1930 Is sicklied o'er with the pale cast of thought,
1931 And enterprises of great pitch and moment,
1932 With this regard their currents turn awry,
1933 And lose the name of action.-Soft you now,
1934 The fair Ophelia.-Nymph, in thy orisons
1935 Be all my sins remembered
1936
1937 ROWID = 2
1938 FIXEDPOINT = NULL
1939 FLOATINGPOINT = NULL
1940 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1941 BLOBDATA (Charset Id = 4 Codepage = 65001)
1942
1943 To be or not to be-that is the question:
1944 Whether 'tis nobler in the mind to suffer
1945 The slings and arrows of outrageous fortune,
1946 Or to take arms against a sea of troubles,
1947 And, by opposing, end them. To die, to sleep-
1948 No more-and by a sleep to say we end
1949 The heartache and the thousand natural shocks
1950 That flesh is heir to-'tis a consummation
1951 Devoutly to be wished. To die, to sleep-
1952 To sleep, perchance to dream. Aye, there's the rub,
1953 For in that sleep of death what dreams may come,
1954 When we have shuffled off this mortal coil,
1955 Must give us pause. There's the respect
1956 That makes calamity of so long life.
1957 For who would bear the whips and scorns of time,
1958 Th' oppressor's wrong, the proud man's contumely,
1959 The pangs of despised love, the law’s delay,
1960 The insolence of office, and the spurns
1961 That patient merit of the unworthy takes,
1962 When he himself might his quietus make
1963 With a bare bodkin? Who would fardels bear,
1964 To grunt and sweat under a weary life,
1965 But that the dread of something after death,
1966 The undiscovered country from whose bourn
1967 No traveler returns, puzzles the will
1968 And makes us rather bear those ills we have
1969 Than fly to others that we know not of?
1970 Thus conscience does make cowards of us all,
1971 And thus the native hue of resolution
1972 Is sicklied o'er with the pale cast of thought,
1973 And enterprises of great pitch and moment,
1974 With this regard their currents turn awry,
1975 And lose the name of action.-Soft you now,
1976 The fair Ophelia.-Nymph, in thy orisons
1977 Be all my sins remembered
1978
1979
1980 Testing Blob as stored proc parameter
1981 Metadata
1982 SQLType =SQL_BLOB
1983 sub type = 1
1984 Table = TESTPROC
1985 Owner = SYSDBA
1986 Column Name = BLOBDATA
1987 Alias Name = BLOBDATA
1988 Field Name = BLOBDATA
1989 Scale = 0
1990 Charset id = 4
1991 Nullable
1992 Size = 8
1993
1994 Blob Meta Data
1995 SQL SubType =1
1996 Table = TESTPROC
1997 Column = BLOBDATA
1998 CharSetID = 4
1999 Segment Size = 80
2000
2001
2002 BLOBDATA (Charset Id = 4 Codepage = 65001)
2003
2004 To be or not to be-that is the question:
2005 Whether 'tis nobler in the mind to suffer
2006 The slings and arrows of outrageous fortune,
2007 Or to take arms against a sea of troubles,
2008 And, by opposing, end them. To die, to sleep-
2009 No more-and by a sleep to say we end
2010 The heartache and the thousand natural shocks
2011 That flesh is heir to-'tis a consummation
2012 Devoutly to be wished. To die, to sleep-
2013 To sleep, perchance to dream. Aye, there's the rub,
2014 For in that sleep of death what dreams may come,
2015 When we have shuffled off this mortal coil,
2016 Must give us pause. There's the respect
2017 That makes calamity of so long life.
2018 For who would bear the whips and scorns of time,
2019 Th' oppressor's wrong, the proud man's contumely,
2020 The pangs of despised love, the law’s delay,
2021 The insolence of office, and the spurns
2022 That patient merit of the unworthy takes,
2023 When he himself might his quietus make
2024 With a bare bodkin? Who would fardels bear,
2025 To grunt and sweat under a weary life,
2026 But that the dread of something after death,
2027 The undiscovered country from whose bourn
2028 No traveler returns, puzzles the will
2029 And makes us rather bear those ills we have
2030 Than fly to others that we know not of?
2031 Thus conscience does make cowards of us all,
2032 And thus the native hue of resolution
2033 Is sicklied o'er with the pale cast of thought,
2034 And enterprises of great pitch and moment,
2035 With this regard their currents turn awry,
2036 And lose the name of action.-Soft you now,
2037 The fair Ophelia.-Nymph, in thy orisons
2038 Be all my sins remembered
2039
2040
2041
2042 Running Test 7: Create and read back an Array
2043 Metadata
2044 SQLType =SQL_LONG
2045 sub type = 0
2046 Table = TESTDATA
2047 Owner = SYSDBA
2048 Column Name = ROWID
2049 Alias Name = ROWID
2050 Field Name = ROWID
2051 Scale = 0
2052 Charset id = 0
2053 Not Null
2054 Size = 4
2055
2056 SQLType =SQL_VARYING
2057 sub type = 0
2058 Table = TESTDATA
2059 Owner = SYSDBA
2060 Column Name = TITLE
2061 Alias Name = TITLE
2062 Field Name = TITLE
2063 Scale = 0
2064 Charset id = 4
2065 Nullable
2066 Size = 128
2067
2068 SQLType =SQL_TIMESTAMP
2069 sub type = 0
2070 Table = TESTDATA
2071 Owner = SYSDBA
2072 Column Name = DATED
2073 Alias Name = DATED
2074 Field Name = DATED
2075 Scale = 0
2076 Charset id = 0
2077 Nullable
2078 Size = 8
2079
2080 SQLType =SQL_VARYING
2081 sub type = 0
2082 Table = TESTDATA
2083 Owner = SYSDBA
2084 Column Name = NOTES
2085 Alias Name = NOTES
2086 Field Name = NOTES
2087 Scale = 0
2088 Charset id = 4
2089 Nullable
2090 Size = 256
2091
2092 SQLType =SQL_ARRAY
2093 sub type = 0
2094 Table = TESTDATA
2095 Owner = SYSDBA
2096 Column Name = MYARRAY
2097 Alias Name = MYARRAY
2098 Field Name = MYARRAY
2099 Scale = 0
2100 Charset id = 0
2101 Nullable
2102 Size = 8
2103 Array Meta Data:
2104 SQLType =SQL_LONG
2105 Scale = 0
2106 Charset id = 0
2107 Size = 4
2108 Table = TESTDATA
2109 Column = MYARRAY
2110 Dimensions = 1
2111 Bounds: (0:16)
2112
2113 SQL Params
2114 SQLType =SQL_LONG
2115 sub type = 0
2116 Field Name = ROWID
2117 Scale = 0
2118 Charset id = 0
2119 Not Null
2120 Size = 4
2121
2122 SQLType =SQL_VARYING
2123 sub type = 0
2124 Field Name = TITLE
2125 Scale = 0
2126 Charset id = 4
2127 Nullable
2128 Size = 128
2129
2130 SQLType =SQL_TIMESTAMP
2131 sub type = 0
2132 Field Name = DATED
2133 Scale = 0
2134 Charset id = 0
2135 Nullable
2136 Size = 8
2137
2138 SQLType =SQL_VARYING
2139 sub type = 0
2140 Field Name = NOTES
2141 Scale = 0
2142 Charset id = 4
2143 Nullable
2144 Size = 256
2145
2146 Param Name = ROWID
2147 Param Name = TITLE
2148 Param Name = DATED
2149 Param Name = NOTES
2150 ROWID = 1
2151 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2152 DATED = 1/4/2016 09:30:00.100
2153 NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
2154 MYARRAY = NULL
2155
2156 SQL Params
2157 SQLType =SQL_ARRAY
2158 sub type = 0
2159 Field Name = MYARRAY
2160 Scale = 0
2161 Charset id = 0
2162 Nullable
2163 Size = 8
2164
2165 ROWID = 1
2166 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2167 DATED = 1/4/2016 09:30:00.100
2168 NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
2169 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)
2170
2171 Shrink to 2:10
2172 Array: (2: 98) (3: 97) (4: 96) (5: 95) (6: 94) (7: 93) (8: 92) (9: 91) (10: 90)
2173 Write updated reduced slice
2174 Show update array
2175 ROWID = 1
2176 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2177 DATED = 1/4/2016 09:30:00.100
2178 NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
2179 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)
2180
2181
2182
2183 Running Test 8: Create and read back an Array with 2 dimensions
2184 Metadata
2185 SQLType =SQL_LONG
2186 sub type = 0
2187 Table = TESTDATA
2188 Owner = SYSDBA
2189 Column Name = ROWID
2190 Alias Name = ROWID
2191 Field Name = ROWID
2192 Scale = 0
2193 Charset id = 0
2194 Not Null
2195 Size = 4
2196
2197 SQLType =SQL_VARYING
2198 sub type = 0
2199 Table = TESTDATA
2200 Owner = SYSDBA
2201 Column Name = TITLE
2202 Alias Name = TITLE
2203 Field Name = TITLE
2204 Scale = 0
2205 Charset id = 4
2206 Nullable
2207 Size = 128
2208
2209 SQLType =SQL_ARRAY
2210 sub type = 0
2211 Table = TESTDATA
2212 Owner = SYSDBA
2213 Column Name = MYARRAY
2214 Alias Name = MYARRAY
2215 Field Name = MYARRAY
2216 Scale = 0
2217 Charset id = 4
2218 Nullable
2219 Size = 8
2220 Array Meta Data:
2221 SQLType =SQL_VARYING
2222 Scale = 0
2223 Charset id = 4
2224 Size = 16
2225 Table = TESTDATA
2226 Column = MYARRAY
2227 Dimensions = 2
2228 Bounds: (0:16) (-1:7)
2229
2230 SQL Params
2231 SQLType =SQL_LONG
2232 sub type = 0
2233 Field Name = ROWID
2234 Scale = 0
2235 Charset id = 0
2236 Not Null
2237 Size = 4
2238
2239 SQLType =SQL_VARYING
2240 sub type = 0
2241 Field Name = TITLE
2242 Scale = 0
2243 Charset id = 4
2244 Nullable
2245 Size = 128
2246
2247 ROWID = 1
2248 TITLE = 2D Array (Charset Id = 4 Codepage = 65001)
2249 MYARRAY = NULL
2250
2251 ROWID = 1
2252 TITLE = 2D Array (Charset Id = 4 Codepage = 65001)
2253 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)
2254
2255
2256
2257 Running Test 9: Database Information tests
2258 Database ID = 4 FB = /opt/firebird/examples/empbuild/employee.fdb SN = mint18-FB3
2259 Pages =307
2260 Base Level = 13,4,0,3,
2261 Implementation = 11,7,0,3,66,1,66,
2262 Reserved = 0
2263 ODS minor = 0
2264 ODS major = 12
2265 Page Size = 8192
2266 Version = 1: LI-V6.3.1.32609 Firebird 3.0
2267 Database is Read/Write
2268 Database Created: 27/9/2016 12:08:46
2269 Pages Used = 297
2270 Pages Free = 10
2271 Server Memory = 19122464
2272 Forced Writes = 1
2273 Max Memory = 19242808
2274 Num Buffers = 2048
2275 Sweep Interval = 20000
2276 Logged in Users: SYSDBA,
2277 Active Transaction Count = 0
2278 Fetches = 552
2279 Writes = 8
2280 Reads = 54
2281 Page Writes = 5
2282 Record Version Removals Operation Counts
2283
2284 Deletes Operation Counts
2285
2286 Expunge Count Operation Counts
2287
2288 Insert Count Operation Counts
2289
2290 Purge Count Countites Operation Counts
2291
2292 Indexed Reads Count Operation Counts
2293 Table ID = 4
2294 Count = 28
2295 Table ID = 6
2296 Count = 15
2297 Table ID = 9
2298 Count = 3
2299 Table ID = 11
2300 Count = 1
2301 Table ID = 12
2302 Count = 15
2303 Table ID = 28
2304 Count = 1
2305 Table ID = 29
2306 Count = 1
2307
2308 Sequential Table Scans Operation Counts
2309 Table ID = 0
2310 Count = 94
2311 Table ID = 1
2312 Count = 2
2313
2314 Update Count Operation Counts
2315
2316 Page Size = 8192
2317
2318
2319 Running Test 10: Event Handling
2320 Call Async Wait
2321 Async Wait Called
2322 Event Signalled
2323 First Event - usually ignored
2324 Signal Event
2325 Event Counts: TESTEVENT, Count = 1
2326 Two more events
2327 Call Async Wait
2328 Async Wait Called
2329 Event Signalled
2330 Event Signalled
2331 Deferred Events Caught
2332 Event Counts: TESTEVENT, Count = 2
2333 Signal Event
2334 Event Counts: TESTEVENT, Count = 1
2335 Async Wait: Test Cancel
2336 Event Signalled
2337 Async Wait Called
2338 Event Cancelled
2339 Time Out - Cancel Worked!
2340 Sync wait
2341 Event Signalled
2342 Event Counts: TESTEVENT, Count = 1
2343
2344
2345 Running Test 11: Services API
2346 Service Manager Version = 2
2347 Server Version = LI-V3.0.1.32609 Firebird 3.0
2348 Implementation = Firebird/Linux/AMD/Intel/x64
2349
2350 Lock Directory = /tmp/firebird/
2351 Message File = /opt/firebird/
2352 Security File = /opt/firebird/security3.fdb
2353
2354 DB Attachments
2355 No. of Attachments = 0
2356 Databases In Use = 0
2357
2358 Sec. Database User
2359 User Name = SYSDBA
2360 First Name =
2361 Middle Name =
2362 Last Name =
2363 User ID = 0
2364 Group ID = 0
2365 User Name = ALICE
2366 First Name =
2367 Middle Name =
2368 Last Name =
2369 User ID = 0
2370 Group ID = 0
2371
2372
2373 Licence Info: feature is not supported
2374 feature is not supported
2375
2376 Licence Mask Info: feature is not supported
2377
2378 Capabilities = 6
2379
2380
2381 Get Limbo transactions
2382
2383 Limbo Transactions
2384
2385
2386 Local Backup
2387
2388
2389
2390 Local Backup Complete
2391
2392 Local Restore
2393
2394
2395
2396
2397
2398
2399 Local Restore Complete
2400
2401 Open Database Check
2402 Database OK
2403 Database Dropped
2404
2405
2406 Running Test 12: Character Sets
2407 SQL Params
2408 SQLType =SQL_LONG
2409 sub type = 0
2410 Field Name = ROWID
2411 Scale = 0
2412 Charset id = 0
2413 Not Null
2414 Size = 4
2415
2416 SQLType =SQL_VARYING
2417 sub type = 0
2418 Field Name = TITLE
2419 Scale = 0
2420 Charset id = 4
2421 Nullable
2422 Size = 128
2423
2424 SQLType =SQL_VARYING
2425 sub type = 0
2426 Field Name = NOTES
2427 Scale = 0
2428 Charset id = 4
2429 Nullable
2430 Size = 256
2431
2432 SQLType =SQL_BLOB
2433 sub type = 1
2434 Field Name = BLOBDATA
2435 Scale = 0
2436 Charset id = 4
2437 Nullable
2438 Size = 8
2439
2440 SQLType =SQL_BLOB
2441 sub type = 1
2442 Field Name = BLOBDATA2
2443 Scale = 0
2444 Charset id = 4
2445 Nullable
2446 Size = 8
2447
2448 SQLType =SQL_VARYING
2449 sub type = 0
2450 Field Name = INCLEAR
2451 Scale = 0
2452 Charset id = 1
2453 Nullable
2454 Size = 16
2455
2456 Connection Character Set UTF8
2457 ROWID = 1
2458 TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001)
2459 NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001)
2460 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)
2461 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)
2462 INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535)
2463
2464 Connection Character Set NONE
2465 ROWID = 1
2466 TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001)
2467 NOTES = C9 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 21 Codepage = 28591)
2468 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)
2469 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)
2470 INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535)
2471
2472 Connection Character Set WIN1252
2473 ROWID = 1
2474 TITLE = 42 6C 6F 62 20 54 65 73 74 20 A9 80 (Charset Id = 53 Codepage = 1252)
2475 NOTES = C9 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 53 Codepage = 1252)
2476 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)
2477 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)
2478 INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535)
2479
2480
2481
2482 Running Test 13: Transaction over two databases
2483 Init Database 1
2484 ROWID = 1
2485 TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001)
2486 NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001)
2487 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)
2488 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)
2489 INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535)
2490
2491 Init Database 2
2492 ROWID = 1
2493 TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001)
2494 NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001)
2495 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)
2496 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)
2497 INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535)
2498
2499 ROWID = 1
2500 TITLE = 44 61 74 61 62 61 73 65 31 (Charset Id = 4 Codepage = 65001)
2501 NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001)
2502 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)
2503 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)
2504 INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535)
2505
2506 ROWID = 1
2507 TITLE = 44 61 74 61 62 61 73 65 32 (Charset Id = 4 Codepage = 65001)
2508 NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001)
2509 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)
2510 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)
2511 INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535)
2512
2513
2514
2515 Running Test 14: Non select procedures
2516 Default Character set Name = UTF8
2517 Metadata
2518 SQLType =SQL_LONG
2519 sub type = 0
2520 Table = SHOWDATA
2521 Owner = SYSDBA
2522 Column Name = ROWID
2523 Alias Name = ROWID
2524 Field Name = ROWID
2525 Scale = 0
2526 Charset id = 0
2527 Nullable
2528 Size = 4
2529
2530 SQLType =SQL_VARYING
2531 sub type = 0
2532 Table = SHOWDATA
2533 Owner = SYSDBA
2534 Column Name = TITLE
2535 Alias Name = TITLE
2536 Field Name = TITLE
2537 Scale = 0
2538 Charset id = 4
2539 Nullable
2540 Size = 128
2541
2542 ROWID = 1
2543 TITLE = Testing (Charset Id = 4 Codepage = 65001)
2544
2545 Repeat with a different execute transaction
2546
2547 ROWID = 1
2548 TITLE = Testing (Charset Id = 4 Codepage = 65001)
2549
2550 Repeat with a original transaction
2551
2552 ROWID = 1
2553 TITLE = Testing (Charset Id = 4 Codepage = 65001)
2554
2555
2556 Running Test 15: Blob Handling and BPBs
2557
2558 Testdata
2559
2560 ROWID = 1
2561 TITLE = Blob Test (Charset Id = 4 Codepage = 65001)
2562 BLOBDATA = (blob), Length = 92514
2563
2564
2565 Testdata 2
2566
2567 ROWID = 1
2568 TITLE = Blob Test (Charset Id = 4 Codepage = 65001)
2569 BLOBDATA (Charset Id = 4 Codepage = 65001)
2570
2571 Écoute moi
2572
2573
2574
2575 Running Test 16: Error handling
2576 Invalid Database Name Test
2577 Error Handled: I/O error during "open" operation for file "Malformed Name"
2578 Error while trying to open file
2579 No such file or directory
2580 Invalid User Name Test
2581 Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
2582 Invalid password Test
2583 Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
2584 Invalid Prepare SQL Test
2585 Error Handled: Dynamic SQL Error
2586 SQL error code = -206
2587 Column unknown
2588 UNKNOWN_DATE
2589 At line 1, column 21 When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ?
2590 Invalid Open Cursor SQL Test
2591 Error Handled: Dynamic SQL Error
2592 SQL error code = -206
2593 Column unknown
2594 X
2595 At line 1, column 8 When Executing: Select X,count(*) As Counter from EMPLOYEE
2596 Transaction not started Test
2597 Error Handled: Transaction is not active
2598 Invalid Param SQL Type Test
2599 Error Handled: Field "EMP_NO" not found
2600 Invalid Server Name Test
2601 Error Handled: Unable to complete network request to host "unknown".
2602 Failed to establish a connection
2603 Invalid User Name Test
2604 Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
2605 Invalid password Test
2606 Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
2607
2608
2609 Test Suite Ends