I Set up a database with Codeset UTF-8, territory US, to insert some hindi data into the table fields.
I am using that field data type as VARGRAPHIC so that it can contain hindi font as well.
But when I insert some hindi data from the keyboard (By Google transliteration tool) in devnagri font, but it shows blocks. When I try to do it by insert script (e.g. insert into idms_district(DISTRICTID,DISTRICTNAME,DISTRICTCODE,ACTIVESTATUS,CREATEDBY,UPDATEDBY,STATEID,DISTRICTCATID) values(51,'Singroli सिंगरोली',51,1,1,1,23,1);) then error msg comes that "DB21007E End of file reached while reading the command.
Notice: We have upgraded developerWorks Community to the latest version of IBM Connections. For more information, read our upgrade FAQ.
Pinned topic Unable to insert hindi font in table fields
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-05-16T14:05:38Z at 2012-05-16T14:05:38Z by SystemAdmin
pradagar 060000BUDW1 Post
Re: Unable to insert hindi font in table fields2012-05-12T10:48:20ZThis is the accepted answer. This is the accepted answer.Try creating your database using codeset 1252 an territory IN if you are Windows.
Refer this link for more information:
Re: Unable to insert hindi font in table fields2012-05-16T12:40:30ZThis is the accepted answer. This is the accepted answer.
- pradagar 060000BUDW
Re: Unable to insert hindi font in table fields2012-05-16T14:05:38ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK
db2set DB2CODEPAGE=1208 db2 terminate db2stop force db2start db2 connect to <database name> db2 "create table t1(col1 VARCHAR(20))" db2 "insert into test1 values('एक')" db2 "select * from t1" COL1 -------------------- एक 1 record(s) selected.