SEO

hello,
i am facing a problem with a db2 database created with utf-8
character set. My db2 server is running on windows 2000 server, client
is on another machine that is also running windows 2000 server.
installation of db2 is default on both client and server. after
creating database i cant insert any japanese/bangla character in the
database. then i test the font settngs of both db2 server and client
from Control centre and found that Arila Unicode MS font cant be set
as font. Then i tried with a Java gui that support unicode data to
insert japanese/bangla character. same gui works for oracle, sql
server, postgres..... in this case i dont find any error message while
saving but after saving if i refresh table data than i found all the
data are lost. i am using COM.ibm.db2.jdbc.net.DB2Driver driver.

i have tested the gui with DB2 8 with the com.ibm.db2.jcc.DB2Driver
driver and it works fine. then i tried to use
com.ibm.db2.jcc.DB2Driver with DB2 7.2 but this driver dosent work
with 7.2

so what i have to do to use my java gui with unicode database in DB2
7.2?

plz help me.

Perhaps setting the environment variable db2codepage helps?

db2set -g db2codepage=1208

zahidal wrote:
> hello,
> i am facing a problem with a db2 database created with utf-8
> character set. My db2 server is running on windows 2000 server, client
> is on another machine that is also running windows 2000 server.
> installation of db2 is default on both client and server. after
> creating database i cant insert any japanese/bangla character in the
> database. then i test the font settngs of both db2 server and client
> from Control centre and found that Arila Unicode MS font cant be set
> as font. Then i tried with a Java gui that support unicode data to
> insert japanese/bangla character. same gui works for oracle, sql
> server, postgres..... in this case i dont find any error message while
> saving but after saving if i refresh table data than i found all the
> data are lost. i am using COM.ibm.db2.jdbc.net.DB2Driver driver.
>
> i have tested the gui with DB2 8 with the com.ibm.db2.jcc.DB2Driver
> driver and it works fine. then i tried to use
> com.ibm.db2.jcc.DB2Driver with DB2 7.2 but this driver dosent work
> with 7.2
>
> so what i have to do to use my java gui with unicode database in DB2
> 7.2?
>
> plz help me.

--
Anton Versteeg
IBM Certified DB2 Specialist
IBM Netherlands

thanks for ur reply.
but how can i execute this command? i am not expert with db2. another
question is should i execute this command in both server and client?

plz help me.

Anton Versteeg <anton_versteeg@nnll.ibm.com> wrote in message news:<c7ng8u$4i8c$1@sp15en20.hursley.ibm.com>...
> Perhaps setting the environment variable db2codepage helps?
>
> db2set -g db2codepage=1208
>
> zahidal wrote:
> > hello,
> > i am facing a problem with a db2 database created with utf-8
> > character set. My db2 server is running on windows 2000 server, client
> > is on another machine that is also running windows 2000 server.
> > installation of db2 is default on both client and server. after
> > creating database i cant insert any japanese/bangla character in the
> > database. then i test the font settngs of both db2 server and client
> > from Control centre and found that Arila Unicode MS font cant be set
> > as font. Then i tried with a Java gui that support unicode data to
> > insert japanese/bangla character. same gui works for oracle, sql
> > server, postgres..... in this case i dont find any error message while
> > saving but after saving if i refresh table data than i found all the
> > data are lost. i am using COM.ibm.db2.jdbc.net.DB2Driver driver.
> >
> > i have tested the gui with DB2 8 with the com.ibm.db2.jcc.DB2Driver
> > driver and it works fine. then i tried to use
> > com.ibm.db2.jcc.DB2Driver with DB2 7.2 but this driver dosent work
> > with 7.2
> >
> > so what i have to do to use my java gui with unicode database in DB2
> > 7.2?
> >
> > plz help me.

On the client.

zahidal wrote:

> thanks for ur reply.
> but how can i execute this command? i am not expert with db2. another
> question is should i execute this command in both server and client?
>
> plz help me.
>
> Anton Versteeg <anton_versteeg@nnll.ibm.com> wrote in message news:<c7ng8u$4i8c$1@sp15en20.hursley.ibm.com>...
>
>>Perhaps setting the environment variable db2codepage helps?
>>
>>db2set -g db2codepage=1208
>>
>>zahidal wrote:
>>
>>>hello,
>>> i am facing a problem with a db2 database created with utf-8
>>>character set. My db2 server is running on windows 2000 server, client
>>>is on another machine that is also running windows 2000 server.
>>>installation of db2 is default on both client and server. after
>>>creating database i cant insert any japanese/bangla character in the
>>>database. then i test the font settngs of both db2 server and client
>>>from Control centre and found that Arila Unicode MS font cant be set
>>>as font. Then i tried with a Java gui that support unicode data to
>>>insert japanese/bangla character. same gui works for oracle, sql
>>>server, postgres..... in this case i dont find any error message while
>>>saving but after saving if i refresh table data than i found all the
>>>data are lost. i am using COM.ibm.db2.jdbc.net.DB2Driver driver.
>>>
>>>i have tested the gui with DB2 8 with the com.ibm.db2.jcc.DB2Driver
>>>driver and it works fine. then i tried to use
>>>com.ibm.db2.jcc.DB2Driver with DB2 7.2 but this driver dosent work
>>>with 7.2
>>>
>>>so what i have to do to use my java gui with unicode database in DB2
>>>7.2?
>>>
>>>plz help me.

--
Anton Versteeg
IBM Certified DB2 Specialist
IBM Netherlands

i did it, but no change. note that i didn't install any fixpak.
another thing is the fonts that can be set for Control Center do not
support japanese, thai or bangla. Arial Unicode MS does support all
these languages. So if i use Bangla then how can i seee them useing
Control Centre?



Anton Versteeg <anton_versteeg@nnll.ibm.com> wrote in message news:<c7q34u$1vpc$2@sp15en20.hursley.ibm.com>...
> On the client.
>
> zahidal wrote:
>
> > thanks for ur reply.
> > but how can i execute this command? i am not expert with db2. another
> > question is should i execute this command in both server and client?
> >
> > plz help me.
> >
> > Anton Versteeg <anton_versteeg@nnll.ibm.com> wrote in message news:<c7ng8u$4i8c$1@sp15en20.hursley.ibm.com>...
> >
> >>Perhaps setting the environment variable db2codepage helps?
> >>
> >>db2set -g db2codepage=1208
> >>
> >>zahidal wrote:
> >>
> >>>hello,
> >>> i am facing a problem with a db2 database created with utf-8
> >>>character set. My db2 server is running on windows 2000 server, client
> >>>is on another machine that is also running windows 2000 server.
> >>>installation of db2 is default on both client and server. after
> >>>creating database i cant insert any japanese/bangla character in the
> >>>database. then i test the font settngs of both db2 server and client
> >>>from Control centre and found that Arila Unicode MS font cant be set
> >>>as font. Then i tried with a Java gui that support unicode data to
> >>>insert japanese/bangla character. same gui works for oracle, sql
> >>>server, postgres..... in this case i dont find any error message while
> >>>saving but after saving if i refresh table data than i found all the
> >>>data are lost. i am using COM.ibm.db2.jdbc.net.DB2Driver driver.
> >>>
> >>>i have tested the gui with DB2 8 with the com.ibm.db2.jcc.DB2Driver
> >>>driver and it works fine. then i tried to use
> >>>com.ibm.db2.jcc.DB2Driver with DB2 7.2 but this driver dosent work
> >>>with 7.2
> >>>
> >>>so what i have to do to use my java gui with unicode database in DB2
> >>>7.2?
> >>>
> >>>plz help me.