Re: What a bunch of characters
Re: What a bunch of characters
- Subject: Re: What a bunch of characters
- From: Miguel Arroz <email@hidden>
- Date: Fri, 2 Nov 2007 17:51:50 +0000
Hi!
Never worked with Oracle, but yeah, that seems strange. Check the
docs for those two settings, but you should set everything to UTF-8.
Yours
Miguel Arroz
On 2007/11/02, at 17:40, Calven Eggert wrote:
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@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">
Calven
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ( email@hidden)
Help/Unsubscribe/Update your Subscription:
40guiamac.com
This email sent to email@hidden
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@hidden)
Help/Unsubscribe/Update your Subscription:
40gmail.com
This email sent to email@hidden
--
Daniele Corti
AIM: S0CR4TE5
Messenger: email@hidden
--
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@hidden)
Help/Unsubscribe/Update your Subscription:
40gmail.com
This email sent to email@hidden
--
Daniele Corti
AIM: S0CR4TE5
Messenger: email@hidden
--
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@hidden)
Help/Unsubscribe/Update your Subscription:
40guiamac.com
This email sent to email@hidden
Miguel Arroz
http://www.terminalapp.net
http://www.ipragma.com
Attachment:
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________
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