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

On Apr 18, 6:30Â*am, OracleServer <helge.ha...@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 --

On 18 Apr, 20:35, Mark D Powell <Mark.Pow...@eds.com> wrote:
> On Apr 18, 6:30Â*am, OracleServer <helge.ha...@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