Just a thought, but is this a new database instance that can be recreated? We have used Oracle 8 and Oracle 10 and never had any problems. That must be because the default is 8859-1. Did you specifically want utf-8?
-John On 2/19/09 11:59 AM, "GEzra" <[email protected]> wrote: > Hi Robert! > > new cipher of UTF-8? what is this? > > I tried leaving witango/apache to 8859-1 and oracle/oci to utf-8 but I > don't think that worked, instead of "?" it came out with "?" > surrounded by a diamond! :) Tried some oracle built-in functions as > well but you are right its Witango that's causing this but for the > moment I'm just looking for some workarounds. > > thanks! > > > On 19-Feb-09, at 12:58 PM, Robert Garcia wrote: > >> Witango currently only speaks ISO 8859-1. You can try experimenting >> with new cipher of UTF-8. >> >> Your db driver/mechanism should be translating from 8859-1 from >> witango to utf-8 in oracle, and back out. If you are having an >> issue, the best way to start is see if you can tell the db driver/ >> mechanism that witango is using 8859-1, and so it will do the >> translating. If you try doing the translating on the witango side, >> you may end up pulling your hair out. >> >> -- >> >> Robert Garcia >> President - BigHead Technology >> VP Application Development - eventpix.com >> 13653 West Park Dr >> Magalia, Ca 95954 >> ph: 530.645.4040 x222 fax: 530.645.4040 >> [email protected] - [email protected] >> http://bighead.net/ - http://eventpix.com/ >> >> On Feb 19, 2009, at 6:16 AM, GEzra wrote: >> >>> Hello everyone! :-) (yes, I'm still cooking witango) >>> >>> Oracle is setup as a UTF8 database (incl. local client) >>> When writing/reading data using SQLDeveloper, data shows up fine. >>> Inserting using Witango (osx/apache/oci), data is not inserted nor >>> read properly, its messed up! >>> >>> I have setup nls_lang/charsert on the osx box and html header to >>> utf-8 but still no go. urlencoding/decoding sometimes work (for >>> some characters) but not for all (ex: smart quotes). >>> >>> Any ideas on fixing this? >>> >>> thanks! >>> ________________________________________________________________________ >>> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf >>> >> ________________________________________________________________________ >> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf >> > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > __________________________________________________ John Carrieri Chairman & CEO U. Inc. 12250 El Camino Real, Suite #100 San Diego, Ca. 92130 Office: (858) 847-3350 x1001 email: [email protected] __________________________________________________ #1 in College Search - http://www.colleges.com Power to the People - http://www.campaign.com The Name says it All - http://www.employment.com All the News. No Ink. - http://www.onlinetimes.com (Coming Soon) __________________________________________________ Colleges.com Natural Listings: #1 Google keyword colleges¹ #1 MSN keyword colleges¹ #1 Yahoo keyword colleges¹ #1 AOL keyword colleges¹ #1 Yahoo keyword college¹ #1 Ask keyword colleges¹ #1 Myspace keyword colleges¹ U. Magazine - Largest college magazine: 500,000 circulation #1 on Google keyword college magazine¹ #1 on AOL keyword college magazine¹ #1 on Ask keyword college magazine¹ U. Magazine - Largest college magazine: 500,000 circulation #1 on Google keyword college magazine¹ #1 on AOL keyword college magazine¹ #1 on Ask keyword college magazine¹ ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
