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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Select UNICODE (UTF8) data as octets from database Options

Re: Select UNICODE (UTF8) data as octets from database Options

From: OracleServer <helge.hauan_at_applica.no>
Date: 4 May 2007 13:46:11 -0700
Message-ID: <1178311571.749427.38670@l77g2000hsb.googlegroups.com>


On 18 Apr, 20:35, Mark D Powell <Mark.Pow..._at_eds.com> wrote:
> On Apr 18, 6:30 am, OracleServer <helge.ha..._at_applica.no> wrote:
>
>
>
>
>
> > Hi.
> > My database (10g) has been created with database character set to
> > "Unicode standard UTF-8 AL32UTF8".
>
> > The data has been stored correctly. Used select dump(name, 1016)
> > from...
> > Query returned:
> > Len = 3 CharacterSet=AL32UTF8: e4, b8, 84
> > UTF-8 encoding of Unicode character (Traditional Chinese): 丁
>
> > Can someone tell me how to select this col into a ProC VARCHAR2
> > variable? The query in my ProC code returns this a value, but the
> > lenght is equal to 1. How can I get all the 3 octets into my VARCHAR2
> > variable?
> > Does it depends on any compilation option, or the PC locale?
>
> > BR,
> > Helge Hauan
>
> Is length returning bytes or characters?  Dump returns internal
> storage.
>
> >From the SQL manual >>
>
> The "length" functions return the length of char. LENGTH calculates
> length using characters as defined by the input character set. LENGTHB
> uses bytes instead of characters. LENGTHC uses Unicode complete
> characters. LENGTH2 uses UCS2 codepoints. LENGTH4 uses UCS4
> codepoints.
> <<
>
> HTH -- Mark D Powell --– Skjul sitert tekst –
>
> – Vis sitert tekst –

Hi again.
What I want is to get all the octets that represents the character(s) selected into a Pro*C variable. Do You know how to do it?

/Helge Received on Fri May 04 2007 - 15:46:11 CDT

Original text of this message

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