Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Change charset of database
"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