Just to let you all know, it actually did work on our end, however
tango had a file limitation .. GEzra, I'll go ahead and email you
pictures off list.
~K
____________________________________________________
Kaustav Acharya
Web Developer
U. Inc.
12250 El Camino Real, Suite #100
San Diego, CA. 92130
Office: (858) 847-3350 x1004
Fax: (858) 847-3340
email: [email protected]
http://www.colleges.com
____________________________________________________
Power to the People - http://www.campaign.com
____________________________________________________
Important Note: This e-mail may contain privileged, undisclosed or
confidential information. If you have received this e-mail in error,
you are hereby notified
that any review, copying or distribution of it is strictly
prohibited. Please inform [email protected] Immediately and
permanently destroy the original transmittal.
Begin forwarded message:
From: Kaustav Acharya <[email protected]>
Date: February 19, 2009 3:56:58 PM PST
To: [email protected]
Subject: Re: Witango-Talk: UTF-8
Hi GEzra,
John had me test our the problem you were having and see if I could
replicate in our system that's set up with Tiny MCE.
check out the following text as displayed via a webpage:
Here is the source code that MCE put into the DB (note the URL
encoding for the special characters:
I would try using TinyMCE but not use the copy from word function.
I copied it using the web page you gave us.
Hope that helps,
____________________________________________________
Kaustav Acharya
Web Developer
U. Inc.
12250 El Camino Real, Suite #100
San Diego, CA. 92130
Office: (858) 847-3350 x1004
Fax: (858) 847-3340
email: [email protected]
http://www.colleges.com
____________________________________________________
Power to the People - http://www.campaign.com
____________________________________________________
Important Note: This e-mail may contain privileged, undisclosed or
confidential information. If you have received this e-mail in
error, you are hereby notified
that any review, copying or distribution of it is strictly
prohibited. Please inform [email protected] Immediately and
permanently destroy the original transmittal.
On Feb 19, 2009, at 3:36 PM, GEzra wrote:
Hi John,
Running Oracle 10g R2 on WinXP. Witango is Xserve (non-intel),
connection is made using OCI.
Just as a test try copying the contents of this press release:
http://www.fujitsu.com/br/news/pr/20070531.html
Especially the quotations (TinyMCE's MS copy/paste will fix this)
but the words "Para maiores informações, veja também" (Eng/
Brazilian mix?) breaks it.
Also, URLENCODE breaks for instance if you try to copy over a
certain length (try copying and pasting couple of paragraphs
twice); empty field in the database.
I did look into TinyMCE and used it for its MS copy/paste
function, its a great tool.
On 19-Feb-09, at 6:22 PM, John Carrieri wrote:
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
_____________________________________________________________________
___
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
