Connecting Tech Pros Worldwide Help | Site Map
 
 
LinkBack Thread Tools Search this Thread
  #1  
Old November 12th, 2005, 07:23 AM
zahidal
Guest
 
Posts: n/a
Default Unicode in DB2 7.2

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.
  #2  
Old November 12th, 2005, 07:23 AM
Anton Versteeg
Guest
 
Posts: n/a
Default Re: Unicode in DB2 7.2

Perhaps setting the environment variable db2codepage helps?

db2set -g db2codepage=1208

zahidal wrote:[color=blue]
> 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.[/color]

--
Anton Versteeg
IBM Certified DB2 Specialist
IBM Netherlands

  #3  
Old November 12th, 2005, 07:23 AM
Anton Versteeg
Guest
 
Posts: n/a
Default Re: Unicode in DB2 7.2

Perhaps setting the environment variable db2codepage helps?

db2set -g db2codepage=1208

zahidal wrote:[color=blue]
> 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.[/color]

--
Anton Versteeg
IBM Certified DB2 Specialist
IBM Netherlands

  #4  
Old November 12th, 2005, 07:23 AM
zahidal
Guest
 
Posts: n/a
Default Re: Unicode in DB2 7.2

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>...[color=blue]
> Perhaps setting the environment variable db2codepage helps?
>
> db2set -g db2codepage=1208
>
> zahidal wrote:[color=green]
> > 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.[/color][/color]
  #5  
Old November 12th, 2005, 07:23 AM
zahidal
Guest
 
Posts: n/a
Default Re: Unicode in DB2 7.2

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>...[color=blue]
> Perhaps setting the environment variable db2codepage helps?
>
> db2set -g db2codepage=1208
>
> zahidal wrote:[color=green]
> > 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.[/color][/color]
  #6  
Old November 12th, 2005, 07:23 AM
Anton Versteeg
Guest
 
Posts: n/a
Default Re: Unicode in DB2 7.2

On the client.

zahidal wrote:
[color=blue]
> 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>...
>[color=green]
>>Perhaps setting the environment variable db2codepage helps?
>>
>>db2set -g db2codepage=1208
>>
>>zahidal wrote:
>>[color=darkred]
>>>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.[/color][/color][/color]

--
Anton Versteeg
IBM Certified DB2 Specialist
IBM Netherlands

  #7  
Old November 12th, 2005, 07:23 AM
Anton Versteeg
Guest
 
Posts: n/a
Default Re: Unicode in DB2 7.2

On the client.

zahidal wrote:
[color=blue]
> 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>...
>[color=green]
>>Perhaps setting the environment variable db2codepage helps?
>>
>>db2set -g db2codepage=1208
>>
>>zahidal wrote:
>>[color=darkred]
>>>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.[/color][/color][/color]

--
Anton Versteeg
IBM Certified DB2 Specialist
IBM Netherlands

  #8  
Old November 12th, 2005, 07:24 AM
zahidal
Guest
 
Posts: n/a
Default Re: Unicode in DB2 7.2

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>...[color=blue]
> On the client.
>
> zahidal wrote:
>[color=green]
> > 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>...
> >[color=darkred]
> >>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.[/color][/color][/color]
  #9  
Old November 12th, 2005, 07:24 AM
zahidal
Guest
 
Posts: n/a
Default Re: Unicode in DB2 7.2

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>...[color=blue]
> On the client.
>
> zahidal wrote:
>[color=green]
> > 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>...
> >[color=darkred]
> >>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.[/color][/color][/color]
 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 205,248 network members.