Special Characters in SQLPlus?

From: <brettcalvin_at_my-dejanews.com>
Date: Mon, 26 Apr 1999 23:14:20 GMT
Message-ID: <7g2s08$bpp$1_at_nnrp1.dejanews.com>



[Quoted] I have some setup tables that a program of mine loads data from, and I need to put some special characters (e.g. one that shows up in a TT font as the "cross of lorraine") into some varchar2 columns in them.

I know the database / tables will handle them, as I can input the data via my program (using RogueWave's DBTools) and the chars go in and come out just fine.

However, when I enter them via SQLPlus or SQL Worksheet, they get replaced by question marks. :-(

I will write a special program to provide UI for configuration, if I have to, but I'd rather just use a generic data-entry tool. Are there any that will work with these special characters, or is there something special I can do to SQLPlus or SQL Worksheet that will make them accept these?

TIA for any ideas or leads ...

Brett Stonier
bretts_at_sight-n-sound.com
Software Engineer
Sight & Sound Software, Inc.

[Quoted] -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Apr 27 1999 - 01:14:20 CEST

Original text of this message