OraFAQ Forum: SQL & PL/SQL » How to convert char between two charsets?

Home » SQL & PL/SQL » SQL & PL/SQL » How to convert char between two charsets?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to convert char between two charsets? [message #9667]

Fri, 28 November 2003 02:01

pacholik
Messages: 2
Registered: November 2003

Junior Member

I have problem with converting charsets between two oracle databases with two different charsets ( EE8ISO8859P2,WE8DEC). When i write this sql in target database:
SELECT
convert('D�M62327','EE8ISO8859P2','WE8DEC')
FROM zis00.prip_body@to_prodej

it doosn't work. Result is: D?M62327

How to convert char between two databases?
Thanks for answers

Report message to a moderator

Re: How to convert char between two charsets? [message #9677 is a reply to message #9667]

Sun, 30 November 2003 00:46

Frank Naude
Messages: 4579
Registered: April 1998

Senior Member

Hi,

Oracle should automatically convert data to the
current database's character set. Just select the data
from the remote database (via db link) and see if the
data is readable or not.

Best regards.

Frank

Report message to a moderator

Re: How to convert char between two charsets? [message #9680 is a reply to message #9677]

Mon, 01 December 2003 00:10

pacholik
Messages: 2
Registered: November 2003

Junior Member

thanks,
but it doesn't work as you writing. I'm from czech republic and we use special charset, and czech special chars is converted bad.

Report message to a moderator

Previous Topic:	SELECT on a LONG RAW column with text-content
Next Topic:	Regarding triggers

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 01:37:43 CDT 2024