VARCHAR ARRAY of UTF8 Charset fails
-----------------------------------
Key: CORE-3765
URL: http://tracker.firebirdsql.org/browse/CORE-3765
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.5.1
Environment: Win 7 64 bit and 32 bit
Reporter: Jason Wharton
Priority: Critical
When I connect via UTF8 Charset I get an error:
(From the IBO SQL trace monitor)
/*---
GET SLICE
ARRAY ID (129, 501)
ARRAY DTYPE 37
ARRAY SCALE 0
ARRAY LENGTH 15
ARRAY DIMENSIONS 1
ARRAY RELATION 'JOB'
ARRAY FIELD 'LANGUAGE_REQ'
SLICE DATA LENGTH 310
SLICE DATA:
1: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
~~~~~~~~~~~~~~~~~
2: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
~~~~~~~~~~~~~~~~~
3: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
~~~~~~~~~~~~~~~~~
4: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
~~~~~~~~~~~~~~~~~
5: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
~~~~~~~~~~~~~~~~~
6: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
~~~~~~~~~~~~~~~~~
7: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
~~~~~~~~~~~~~~~~~
8: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
~~~~~~~~~~~~~~~~~
9: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
~~~~~~~~~~~~~~~~~
10: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
~~~~~~~~~~~~~~~~~
11: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
~~~~~~~~~~~~~~~~~
12: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
~~~~~~~~~~~~~~~~~
13: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
~~~~~~~~~~~~~~~~~
14: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
~~~~~~~~~~~~~~~~~
15: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
~~~~~~~~~~~~~~~~~
16: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
~~~~~~~~~~~~~~~~~
17: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
~~~~~~~~~~~~~~~~~
18: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
~~~~~~~~~~~~~~~~~
19: 0 0 0 0 ~~~~
ERRCODE = 335544321
----*/
/*---
INTERPRET BUFFER =
ERRCODE = 60
----*/
/*---
INTERPRET BUFFER = arithmetic exception, numeric overflow, or string truncation
ERRCODE = 23
----*/
/*---
INTERPRET BUFFER = string right truncation
ERRCODE = -1
----*/
This is against the Employee.gdb database that comes standard with earlier
versions of InterBase. If I change to Charset ASCII then I have no problem
getting the data. Somehow something inside the engine is tripping up when it
comes to handling UTF8 (MBCS) in array columns.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
