Re: What a bunch of characters
Re: What a bunch of characters
- Subject: Re: What a bunch of characters
- From: Pascal Robert <email@hidden>
- Date: Fri, 2 Nov 2007 14:13:41 -0400
Yes, I can save those char in our Oracle Database with no problems.
What's happening if you do a INSERT with those characters in SQL
Developer ?
OK, so are you able to store characters like this
"≤≥β√αγδ"? (In case you are not able to read the string,
enclosed is a picture)
If you are, then what do you think is my problem?
<Picture 1.jpg>
On 2-Nov-07, at 1:57 PM, Pascal Robert wrote:
Le 07-11-02 à 13:40, Calven Eggert a écrit :
Here are my values from the database after running the command:
(values are after the comma)
select * from nls_database_parameters;
...
Of particular note, NLS_CHARACTERSET,WE8ISO8859P1 and
NLS_NCHAR_CHARACTERSET,AL16UTF16.
Those are Oracle defaults, we have the same properties in Oracle
9iR2 and I'm not aware of any problems (and we do have a lot of
accentued characters because we are damn French-Canadians :-).
Do these values confirm that the DB is the culprit?
On 2-Nov-07, at 12:16 PM, Daniele Corti wrote:
2007/11/2, Calven Eggert <email@hidden>:
I've looked into my model file and could the problem be here?
"ANSI92_CONFORMANCE" = ANSI92EntryLevel;
"DBMS_NAME" = Oracle;
"DRIVER_NAME" = "Oracle JDBC driver";
"DRIVER_VER" = "8.1.7.0.0";
ehm , don't you have a manager for Oracle? if you have one, open
the properties of you tables, and check the collation and
character set, if character set is setted to, I don't know, US
ASCII, you have found the problem.
On 2-Nov-07, at 11:17 AM, Daniele Corti wrote:
2007/11/2, Calven Eggert <email@hidden >:
The suggestion below worked for the display of the characters.
"≤≥β√αγδ"
However, once I reloaded the record from the database the text
now looks like this "de² ±³´". This is also what it looks
like directly in the database. Oracle
Do I need to do something with the data before/after sending/
receiving to/from the database?
I'm fear this is caused by the collation or the character_set
of the db table. I've never used Oracle, so I don't know how
you can check this.
I've not understand one thing: do you always read the
characters from the WOTextField or also in WOString? Because,
if you have to print them, I suggest you to use html entities
(even if you have encoding UTF-8).
On 2-Nov-07, at 10:44 AM, Miguel Arroz wrote:
Hi
I would recommend to change de meta http charset to UTF 8
and add this to your Application class:
public void appendToResponse(WOResponse response, WOContext
context) {
super.appendToResponse(response, context);
if( _NSUtilities.UTF8StringEncoding.equals
(response.contentEncoding()) && response.headerForKey("Content-
Type").equals("text/html") )
response.setHeader("text/html; charset=UTF-8",
"Content-Type");
}
public WOResponse createResponseInContext( WOContext
wocontext ) {
WOResponse woresponse = super.createResponseInContext
(wocontext);
woresponse.setContentEncoding
( _NSUtilities.UTF8StringEncoding);
return woresponse;
}
public void takeValuesFromRequest(WORequest aRequest,
WOContext aContext) {
aRequest.setDefaultFormValueEncoding
( _NSUtilities.UTF8StringEncoding );
super.takeValuesFromRequest(aRequest, aContext);
}
Unless you really want iso-8859-1, but I don't find any
reason to do so.
Yours
Miguel Arroz
On 2007/11/02, at 14:32, Calven Eggert wrote:
Ok, so I'm about to release a new version of a WO application
and one of the testers says "Hey, when I type the following
characters into a text box, they don't show up correctly
after I save the record. "≤≥β√αγδ"
So I do the same on the Macintosh. I paste the characters
and they look fine. I save the record, exit and reenter the
page and behold, they show up as "???????" where on Windows
they show up like this "≤≥β√αγδ".
What's a lonely WO programmer to do, after doing some google
searches and searching the WO dev list and still hasn't a
clue what to do? I do know that in the html this appears
<META HTTP-EQUIV="Content-Type" CONTENT="text/html;
charset=iso-8859-1">
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden