Message-Id: <10666.120769@fatcity.com> From: Tom Tyson Date: Tue, 31 Oct 2000 20:01:33 -0800 (PST) Subject: RE: Sugguestions and Experiences with Character sets Diana Yes your database is what I was referring to :) , I believe I'm just about ready to go live.... I'd like to have a conference call with you to go over a few things before hand, basic db monitoring, backups stuff, etc.. I want to discuss switching all of the backups to RMAN as well, I've got everything scripted and ready to go. Glad to hear your happy with the UTF8 changes that were made to the database. Another DBA here is working with that client to discuss character set alternatives, the only reason I was thinking of suggesting UTF8 is the possibility they would require Japanese in the future. Speaking of exporting and importing.. well thats how all this trouble began, his client attempted to export what they thought was German data out of US7ASCII database and import it into a WE8ISO8859P1 database, didn't work how they expected it... Tom Tyson --- Diana Duncan wrote: > Well, since the database you've used UTF8 on is probably mine... ;-) > > I like it. No problems so far, but I've only tried to load French in this > one so far (other than the English) > > I used UTF8 on a prior project which used pretty much all of the European > languages, and it worked great. Just make sure you are careful when you > export and import. > > Cheers! > Diana > > (BTW, ready for live date, Tom? ;-) > > -----Original Message----- > Sent: Tuesday, October 31, 2000 1:06 PM > To: Multiple recipients of list ORACLE-L > > > Fellow DBA's > > Got a question for you, I have a client who is looking to change their > database > character set from US7ASCII to 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. > http://im.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Tom Tyson > INET: tomtysonjr@yahoo.com > > 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: ListGuru@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). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Diana Duncan > INET: Diana@fileFRENZY.com > > 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: ListGuru@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).