From: Frank Newsgroups: comp.databases.oracle Subject: Re: Utf8 Oracle Date: Fri, 04 Apr 2003 21:16:45 +0200 Organization: @Home Benelux Lines: 24 Message-ID: <3E8DDA1D.2060507@netscape.net> References: <2711083.1049127559@dbforums.com> <2728506.1049443506@dbforums.com> NNTP-Posting-Host: cc28855-a.hnglo1.ov.home.nl Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Trace: news2.tilbu1.nb.home.nl 1049483708 17691 217.121.193.81 (4 Apr 2003 19:15:08 GMT) X-Complaints-To: abuse@home.nl NNTP-Posting-Date: Fri, 4 Apr 2003 19:15:08 +0000 (UTC) User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.0.2) Gecko/20030208 Netscape/7.02 X-Accept-Language: en-us, en 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