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: Change charset of database

Re: Change charset of database

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Mon, 10 Jun 2002 07:18:48 +1000
Message-ID: <ae0goi$89v$1@lust.ihug.co.nz>

"Norman Dunbar" <oracle_at_bountifulsolutions.co.uk> wrote in message news:MPG.176d87209fa585ea989682_at_news.demon.co.uk...
> Beware of a bug with UTF8 charsets. I'm at home just now and don't have
> the bug number, but it goes something like this :
>
> if you use 817 and UTF8 then there is a problem whereby you cannot exceed
> 2000 bytes (not UTF characters) in the bind variable values in an SQL
> statement. Also, none of the individual bind varaible values can exceed
> 600 bytes.
>

Well, Oracle has always used byte semantics, not character ones. Create table blah (col1 char(5)) means that column 1 will be 5 bytes long -and has always meant that so far as I'm aware.

In 9i, you get the chance to specify "...col1 char(5) byte" or "...col1 char(5) char", so now it's explicit, though byte is still the default. So I would have thought that the first 'bug' you report isn't a bug at all.

Regards
HJR
> We have a customer who is using UTF8 charset and when we run our
> application against a UTF8 setup, we hit the error. If we change back to
> WE8DECxxxx it works fine.
>
> This is not fixed i 8.1.7.3.0 yet either as that is the patch level we
> are using. I'm not sure if it is HP specific or all platforms, but our
> setup is HP 32 bit.
>
> regards,
>
> Norman Dunbar.
Received on Sun Jun 09 2002 - 16:18:48 CDT

Original text of this message

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