Here are my values from the database after running the command:
(values are after the comma)
select * from nls_database_parameters;
NLS_LANGUAGE,AMERICAN
NLS_TERRITORY,AMERICA
NLS_CURRENCY,$
NLS_ISO_CURRENCY,AMERICA
NLS_NUMERIC_CHARACTERS,.,
NLS_CHARACTERSET,WE8ISO8859P1
NLS_CALENDAR,GREGORIAN
NLS_DATE_FORMAT,DD-MON-RR
NLS_DATE_LANGUAGE,AMERICAN
NLS_SORT,BINARY
NLS_TIME_FORMAT,HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT,DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT,HH.MI.SSXFF AM TZH:TZM
NLS_TIMESTAMP_TZ_FORMAT,DD-MON-RR HH.MI.SSXFF AM TZH:TZM
NLS_DUAL_CURRENCY,$
NLS_COMP,BINARY
NLS_NCHAR_CHARACTERSET,AL16UTF16
NLS_LENGTH_SEMANTICS,BYTE
NLS_SAVED_NCHAR_CS,WE8ISO8859P1
NLS_NCHAR_CONV_EXCP,FALSE
NLS_RDBMS_VERSION,10.2.0.2.0
Of particular note, NLS_CHARACTERSET,WE8ISO8859P1 and
NLS_NCHAR_CHARACTERSET,AL16UTF16.
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 PROTECTED]>:
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 PROTECTED] >:
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">
Calven
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ( Webobjects-
[EMAIL PROTECTED])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/arroz%
40guiamac.com
This email sent to [EMAIL PROTECTED]
Miguel Arroz
http://www.terminalapp.net
http://www.ipragma.com
Calven
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/ildenae%
40gmail.com
This email sent to [EMAIL PROTECTED]
--
Daniele Corti
AIM: S0CR4TE5
Messenger: [EMAIL PROTECTED]
--
Computers are like air conditioners -- they stop working
properly if you open
WINDOWS
--
What about the four lusers of the apocalypse? I nominate:
"advertising", "can't log in", "power switch" and "what backup?"
--Alistair Young
Calven
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/ildenae%
40gmail.com
This email sent to [EMAIL PROTECTED]
--
Daniele Corti
AIM: S0CR4TE5
Messenger: [EMAIL PROTECTED]
--
Computers are like air conditioners -- they stop working
properly if you open
WINDOWS
--
What about the four lusers of the apocalypse? I nominate:
"advertising", "can't log in", "power switch" and "what backup?"
--Alistair Young
Calven
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/award%
40apple.com
This email sent to [EMAIL PROTECTED]
