Re: Utf8 Oracle

From: TC <donotuse_at_donotuse.com>
Date: Sat, 05 Apr 2003 03:06:51 GMT
Message-ID: <fLrja.331379$3D1.178844_at_sccrnsc01>


Absolutely.

Just to reiterate, UTF8 is easy but not necessarily the best practice.

//tc

"Frank" <fvanbortel_at_netscape.net> wrote in message news:3E8DDA1D.2060507_at_netscape.net...
> willevolve wrote:
> > Maybe I trust UTF8 too much, but I do not need Asian, Thai or something
> > else. I want cover languages in global usage Europe, America, maybe I
> > can say expected ones.
> >
> > If I use UTF8 and varchar2 (not nvarchar2) on ORACLE 8.1.7. my storage
> > will still cover different length of characters(?). Middle tier and
> > client are Java (UTF8), no conversions at all (escape from mess), and I
> > think that I will not have any further complications for some time!
> > My documents from application are PDFs, with embedded fonts.
> >
> > On 9i this must work on same way!
> > Do any of You see any problem?
> >
>
> No. Bear in mind UTF8 will use multibyte characters for the
> high-order support of ISO character sets.
>
> Formulated in another way: don't be surprised if a (foreign?)
> name of 30 characters doesn't fit in a varchar2(30).
>
> --
> Regards, Frank van Bortel
>
Received on Sat Apr 05 2003 - 05:06:51 CEST

Original text of this message