Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Character Set Problems

Re: Character Set Problems

From: sybrandb <sybrandb_at_gmail.com>
Date: Thu, 14 Jun 2007 06:05:50 -0700
Message-ID: <1181826350.583138.237570@o11g2000prd.googlegroups.com>


On Jun 14, 2:05 pm, Paul <paulwragg2..._at_hotmail.com> wrote:
> Hi Sybrand - thanks for the quick response!
>
> I should have stated that this is actually for a customer who are on
> 9.2.0.8. I am just using 9.2.0.1.0 as I had to install 9 in order to
> try and figure out this problem. We tend to use Oracle 10 these days!
> Any ideas how I can tell from SQL Plus whether or not the data is
> stored correctly?
>
> I take your point about changing the storage of the data - at present
> I am just trying to find a workaround for this that does not require
> structural changes to the DB, and if possible does not require the XML
> to be generated in a different encoding format.
>
> One other thing - were LONG columns completely desupported from 8
> onwards? This is a DB that started life on Oracle 7 (or earlier), and
> as I am sure you appreciate new development often takes priority over
> modifying existing things. We are planning to overhaul the DB
> completely at some point, but until then any ideas to fix this for the
> time being would be appreciated.
>
> Paul

As to sql*plus: there is a CONVERT function in sql which converts to various charactersets.
You may have difficulty using a long though. Asktom has several routines to convert longs to varchar2.
This tip is on Metablink:

If you just want to quickly check if a character is correctly stored in a AL32UTF8 database
simply use Oracle SQL Developer, if it shows good in this tool, it's oke in the database.
you can download from here:
http://www.oracle.com/technology/products/database/sql_developer/

I also stumbled upon a note stating in Oracle 11 AL32UTF8 will be the default characterset!

LONGs where declared 'obsolete' in 8.0 and available for backwards compatibility only, with the advice not to use them any longer. Your's is a legacy app, but you need to evaluate the limitations of LONGs compared to the possibilities of LOBs

--
Sybrand Bakker
Senior Oracle DBA
Received on Thu Jun 14 2007 - 08:05:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US