What version of Oracle are you using? What platform are you on? IF you want to take this off list you can email me some of the utf-8 text as an example of give me a page to go to to get it. I can do some tests here where we might be able to find a solution. If so, we can then post the solution back to the list.
We just did a test and copied utf-8 into our db without any problems. Also you can use a free utility TinyMCE which would urlencode any special characters when they are entered. http://tinymce.moxiecode.com/ Sincerely, John On 2/19/09 3:04 PM, "GEzra" <[email protected]> wrote: > > Good question! Clients are starting to copy/paste stuff from their > websites (utf-8 encoded pages) into our database, turns out as garbage > on Oracle with 8859-1 encoding. Therefore, I created a test instance > with AL32UTF8 encoding and inserted some data using SQLDeveloper, > works great but not so good when inserted or read from Witango/OCI. > Also tested with a Witango/jdbc connection, same thing. However, I am > told that its possible to tell jdbc which is using what so it will > translate but not able to find any info that. > > > On 19-Feb-09, at 5:37 PM, John Carrieri wrote: > >> 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 >> > ________________________________________________________________________ > 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
