Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Sugguestions and Experiences with Character sets

RE: Sugguestions and Experiences with Character sets

From: Weaver, Walt <>
Date: Tue, 31 Oct 2000 12:20:27 -0700
Message-Id: <>

I just moved some Portuguese and Spanish schemae from WE8ISO8859P1 to UTF8. No real horror stories, but data that took up one byte in the WE8IS8859P1 character set takes three in UTF8, due to the accented characters.

I initially had problems exporting and importing the data, due to the increased storage requirements. I wound up recreating the objects in the UTF8 database by creating a database link to the WE* database and doing a "create table abc as select * from abc_at_WEDB where rownum < 1". Doing this created the columns with the right size.

The changes in size didn't break our application.

Next week I get to move a German site...

--Walt Weaver

  Bozeman, Montana, USA

-----Original Message-----

From: Tom Tyson [] Sent: Tuesday, October 31, 2000 11:06 AM To: Multiple recipients of list ORACLE-L Subject: Sugguestions and Experiences with Character sets

Fellow DBA's

Got a question for you, I have a client who is looking to change their database
character set from US7ASCII to <something> to support the following languages:
American English, German, French and Spanish. I was going to suggest to them
to use WE8ISO8859P1 as a database character set, but was inclined to suggest going ahead with UTF-8. I have used UTF-8 on one database, and so far no problems, but wanted to know if anyone has any horror stories or anything to make me feel better about going either way. Any suggestions would be appreciated...

Thanks in Advance...
Tom Tyson

Do You Yahoo!?
Yahoo! Messenger - Talk while you surf! It's FREE.

Please see the official ORACLE-L FAQ:

Author: Tom Tyson
Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Oct 31 2000 - 13:20:27 CST

Original text of this message