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" <e...@datatango.com> 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
rgar...@bighead.net - rgar...@eventpix.com
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: jcarri...@colleges.com
__________________________________________________
#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