Avoid data conversion in DB2

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bvijai@gmail.com - 26 Sep 2006 14:27 GMT

Hi,

I am facing a problem whle importing the DEL files ( encoding: Unicode)
into a Unicode database.The DEL files have French Characters.I observed
that the French Character é has been converted to Ã©.
To avoid this conversion, I used MODIFIED BY CODEPAGE=1208 in the
IMPORT statement.
This worked perfectly fine.But now I do not want to modify the IMPORT
statement. Is there any way by which I can achieve this? Is there any
command line option which I can use before I import the data. Also, I
do not want to modify any DEL file encdoing, format,etc.
Iam using DB2 8.2
Thanks in advance,

Vj

Reply to this Message

Phil Sherman - 28 Sep 2006 17:01 GMT

Have you considered using a CODEPAGE parameter on the export? You will
need to set the codepage to the codepage of the system you are using for
the IMPORT command.

Phil Sherman

> Hi,
>
[quoted text clipped - 11 lines]
>
> Vj

Reply to this Message

bvijai@gmail.com - 29 Sep 2006 22:25 GMT

Hi Phil,

Thanks for your reply.
What I did was, I set up the registry variable DB2CODEPAGE =1208 even
before I created the Unicode database using the db2set command.
This solved my problem.

Thanks once again,
Vijay

> Have you considered using a CODEPAGE parameter on the export? You will
> need to set the codepage to the codepage of the system you are using for
[quoted text clipped - 17 lines]
> >
> > Vj

Reply to this Message