GRAPHIC data type support

sushma007 · #1 (**permalink**) 03-26-08, 06:24

I am new to DB2 ,I am trying to create a Table with GRAPHIC data type , When i execute the query

Quote:

CREATE TABLE mytab(col1 GRAPHIC(3))

An error is thrown

sql1216N graphic data and graphic functions are not supported for this database

Please let me know how to over come it

sansaniwal25 · #2 (**permalink**) 03-26-08, 08:19

The code page of the database does not support graphic data. we have to recreate the database with correct code page.

guyprzytula · #3 (**permalink**) 03-26-08, 08:31

create the db with code page utf-8 and you can use graphic - vargraphic