Home » RDBMS Server » Server Utilities » Foreign-language currency symbols, sql*loader and CLOBs
Foreign-language currency symbols, sql*loader and CLOBs [message #72864] Thu, 20 November 2003 15:01 Go to next message
Evan Axelrad
Messages: 1
Registered: November 2003
Junior Member
When I load a data file, via sql*loader, containing foreign-language currency symbols, like the British pound (£), it does not get stored in the dB properly for CLOB data-types?

When I insert the row via sql*plus, it inserts fine..

Help!!!!!? How do I get sql*loader to insert these symbols?

Report message to a moderator

Re: Foreign-language currency symbols, sql*loader and CLOBs [message #72874 is a reply to message #72864] Thu, 27 November 2003 06:07 Go to previous message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Hi,

Ensure you use the correct CHARACTERSET when loading data. See chapter 5 of the Oracle9i Database Utilities Release 2 (9.2) Guide for details.

Best regards.

Frank

Report message to a moderator

Previous Topic: HTML DB
Next Topic: Select Statement in SQL*Loader
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 07:54:57 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.