473,325 Members | 2,860 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

how to handle utf-8 char in db2 export

Hi,
I am using udb version 8 fixpack 12 installed on Linux.
I need to move a schema from one db to another. All tables in the
target and source schemas are created using 'CCSID UNICODE'.
I used db2move export command from the db2 client on Windows XP.
However, when I import the data into the target schema, I noticed some
special characters were replaced by a right-arrow character.
What do I need to do to keep the data intact during the transfer?

Thanks in advance.

Tom
Mar 10 '08 #1
1 9461
to*****@hotmail.com wrote:
Hi,
I am using udb version 8 fixpack 12 installed on Linux.
I need to move a schema from one db to another. All tables in the
target and source schemas are created using 'CCSID UNICODE'.
I used db2move export command from the db2 client on Windows XP.
However, when I import the data into the target schema, I noticed some
special characters were replaced by a right-arrow character.
What do I need to do to keep the data intact during the transfer?

Thanks in advance.

Tom
I believe that by default DB2 converts data to the client application
codepage. This includes the output of export. Try setting the DB2CODEPAGE
environment variable to 1208 before doing the export. It may also have to
be set prior to import or load.

When using UTF-8, even when using characters that convert correctly you can
get import/load errors due to truncation if the client is not running with
the correct codepage. E.g. Some characters may correctly change from
multi-byte to single byte and a char column will get padded with blanks.
When importing/loading the reverse happens but the blanks may not be
removed and an error is the result.
Colin
Mar 10 '08 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: js | last post by:
Hi, hwo to use ASP to handle chinese characters output? I have try two ways: 1. store the string in a text file(unicode file) 2. store the string in an access database The first method got an...
0
by: Samuel Fung | last post by:
Hi all, Can ASP retrieve UTF-8 encoded data in query string properly, when used with IIS 5.0 on Windows 2000 Pro/Server? With some trial and error, it seems that adding the directive...
1
by: Kelvin | last post by:
Hi, there: I want to know how MSXML handles Asian languages like Chinese and Korean? Bet Regards, Kelvin
1
by: Jack | last post by:
Hi, I am working on a asp page where I am opening a recordset object using an Access stored query named "GMISExpenseCombo". I have to use this resultset with various fields in the page. Howeve,r...
1
by: Mark | last post by:
Assume you have a simple HTML form that submits its form results to a .aspx page. The receiving .aspx page processes the values sent by the form. If the form data contains an accented character...
1
by: Steve | last post by:
I want to ask if .NET cannot handle WSDL with exception <wsdl:fault> element? <wsdl:fault name="CreditCardWizardException"> <soap:fault name="CreditCardWizardException" use="encoded"...
10
by: lamxing | last post by:
Dear all, I've spent a long time to try to get the xmldocument.load method to handle UTF-8 characters, but no luck. Every time it loads a document contains european characters (such as the...
4
by: Rui Maciel | last post by:
I want to support Unicode on a pet project of mine (small markup language parser). I've read a bit about Unicode (didn't delved beyond the basics) and I searched for some info on how to support...
7
by: billsahiker | last post by:
if an xml file specifies an encoding, e.g., utf16, do xml browsers and xml editors read and verify each character in the file to make sure it is utf16? and throw an error if it is not, or. do they...
13
by: =?Utf-8?B?Um9nZXIgTWFydGlu?= | last post by:
This is a follow-up to my post "Silverlight video doesn't work when file is streamed from handler in ASP.net" at...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.