Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Sugguestions and Experiences with Character sets
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 [mailto:tomtysonjr_at_yahoo.com]
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
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (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
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
![]() |
![]() |