Re: Utf8 Oracle

Here is how UTF8 encoding works

The number of bytes needed for one character depends on the character's Unicode code:

1 byte if it is in range 0000-007f,
2 bytes if it is in range 0080-07ff,
3 bytes if it is in range 0800-ffff.

Thus with UTF8 any character beyond 007f (ASCII 127) will be converted to 2 bytes and those beyond 00ff (ASCII 255) will be converted to 3 bytes.

So as long as you are inserting characters that are within ASCII 127 you should not have any problems at all.

Although UTF8 is sometimes default characterset in Oracle 8i, I would suggest that if your database is strictly for English, you might as well stick to US7ASCII. If it is bilingual but does not require supporting multi-byte Asian characters, WE8ISO8859P15 can be your characterset of choice.

//tc

"willevolve" <member27377_at_dbforums.com> wrote in message news:2711083.1049127559_at_dbforums.com...
>
> in oracle 8.1.6 my charset is utf8, how many bytes is letter A?
>
> if I set column to varchar2(5), can I save word with 5 letters?
>
>
> I do not understand meaning of utf8 as caracterset.
>
>
> in oracle 9i are some differences...
>
>
>
> bye
>
> --
> Posted via http://dbforums.com
Received on Mon Mar 31 2003 - 19:42:05 CEST