Thread: Double Byte Character Data [DBC]
07-11-07, 10:23 #1Registered User
- Join Date
- Jul 2007
Unanswered: Double Byte Character Data [DBC]
I am ramesh and am new to DB2 v9.1 as well this group. I need all your help on below mentioned queries
I have come across DBCLOB, GRAPHIC, VARGRAPHIC, LONG VARGRAPHIC data types in DB2 V9.1 LUW which is getting used for DBC support.
And I would like to know how to insert the value into above mentioned data type fileds.
1. There is any specific types of CHARACTER SET needs to be set on Database level / table level side to stores the DBC
2. Is it possible to hold single byte character & double byte character on same table?
3. Through SELECT statement, Can I retrieve the data from DBC?
And I would like to know, if there is any website which talks more about Double Byte Character data in align with IBM DB2 v9.1 LUW context
07-12-07, 03:42 #2Registered User
- Join Date
- Jun 2006
if the db has been created with character set UTF-8 you store single and double byte characters. you can create table with graphic, vargraphic...
store and select data from these tables
many pages talk about this : have a look at
http://www.ibm.com/developerworks/db.../dm-0506chong/Best Regards, Guy Przytula
DB2 UDB LUW certified V6/7/8