Home » RDBMS Server » Server Administration » About character set translation!!!
About character set translation!!! [message #56435] Mon, 31 March 2003 00:26 Go to next message
oracle8i
Messages: 16
Registered: October 2002
Junior Member
There are two database in our system,one is installed with US7ASCII character set, and the other is installed with hzgbk. They both have a table t1 which has many varchar2 attributes. The problem is that when I copy records from one database to another dababase through dblink, the characters of varchar2 attribute have changed into wrong characters.
How to resolve this problem? thank you.

Report message to a moderator

Re: About character set translation!!! [message #56442 is a reply to message #56435] Mon, 31 March 2003 10:49 Go to previous messageGo to next message
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
Senior Member
hi,
u will have to Update the Character set of the Other database...
try looking at this link..

click here

sai

Report message to a moderator

Re: About character set translation!!! [message #56494 is a reply to message #56435] Thu, 03 April 2003 13:22 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
You have to convert the character set, while copying the data. The ONLY way to convert the character set is export/import.

Export the table adn then import it on the target db.

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Previous Topic: How to connect to oracle9i server
Next Topic: How to convert ISO-8859-1 charset data to UTF-8 charset data?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 07:23:08 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.