Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 358838 - New Record Wizard: VARGRAPHIC and GRAPHIC data types in DB2 Express will be converted to unicode, which is unsupported
Summary: New Record Wizard: VARGRAPHIC and GRAPHIC data types in DB2 Express will be c...
Status: CLOSED FIXED
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: EDT (show other bugs)
Version: unspecified   Edit
Hardware: PC Windows XP
: P3 major (vote)
Target Milestone: ---   Edit
Assignee: Zhi Zhu CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-09-25 22:47 EDT by Thomas Wu CLA
Modified: 2017-02-23 14:19 EST (History)
1 user (show)

See Also:

Attachments
unicode error (206.52 KB, image/jpeg)
2011-09-25 22:49 EDT, Thomas Wu CLA 		no flags Details
DBCHAR(x) in RBD (30.18 KB, image/jpeg)
2011-09-26 03:46 EDT, Thomas Wu CLA 		no flags Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Thomas Wu CLA 2011-09-25 22:47:11 EDT 
Build Identifier: 20110923

VARGRAPHIC and GRAPHIC data types in DB2 Express will be converted to unicode, which is unsupported in EDT 0.7

Reproducible: Always

Steps to Reproduce:
1. Install DB2 Express with its sample DB.
2. New an EGL project.
3. Try to convert all tables in the sample DB to egl records file.

Actual results: VARGRAPHIC and GRAPHIC data types in DB2 Express will be converted to unicode, which is not recognized in EDT 0.7.
Comment 1 Thomas Wu CLA 2011-09-25 22:49:52 EDT 
Created attachment 203984 [details]
unicode error
Comment 2 Zhi Zhu CLA 2011-09-26 02:38:08 EDT 
Thomas, could you kindly check in RBD8 VARGRAPHIC and GRAPHIC data types in DB2 are converted to what data types? thanks
Comment 3 Thomas Wu CLA 2011-09-26 03:08:23 EDT 
Hi, Zhi. I couldn't found the "New Records from SQL Database" function in RBD8012.
Comment 4 Zhi Zhu CLA 2011-09-26 03:17:43 EDT 
Please use EGL-->Data Access Application, they play similar roles
Comment 5 Thomas Wu CLA 2011-09-26 03:45:02 EDT 
They will be converted into DBCHAR(x)
Comment 6 Thomas Wu CLA 2011-09-26 03:46:35 EDT 
Created attachment 203993 [details]
DBCHAR(x) in RBD
Comment 7 Zhi Zhu CLA 2011-09-26 20:33:45 EDT 
dbchar is not supported in current release, I suggest delaying fix for this bug
Comment 8 Zhi Zhu CLA 2011-09-27 05:27:35 EDT 
fix it in the future
Comment 9 Zhi Zhu CLA 2011-10-12 04:16:31 EDT 
Will offer warning messages for currently unsupported column data type and skip egl generation for the column
Comment 10 Thomas Wu CLA 2011-10-19 23:23:05 EDT 
Verified in build 20111019
Comment 11 Lisa Lasher CLA 2011-10-20 15:04:42 EDT 
I'm changing the target from Future to 070 Final.  This defect is fixed for now, within the restrictions of 0.7.0 functionality.  Support for additional data types will be tracked as work items for 1.0.