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.0Of 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. OracleDo 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:HiI 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 protected]) Help/Unsubscribe/Update your Subscription:http://lists.apple.com/mailman/options/webobjects-dev/arroz% 40guiamac.comThis email sent to [EMAIL PROTECTED]Miguel Arroz http://www.terminalapp.net http://www.ipragma.comCalven _______________________________________________ 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.comThis email sent to [EMAIL PROTECTED] -- Daniele Corti AIM: S0CR4TE5 Messenger: [EMAIL PROTECTED] --Computers are like air conditioners -- they stop working properly if you openWINDOWS -- What about the four lusers of the apocalypse? I nominate: "advertising", "can't log in", "power switch" and "what backup?" --Alistair YoungCalven _______________________________________________ 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.comThis email sent to [EMAIL PROTECTED] -- Daniele Corti AIM: S0CR4TE5 Messenger: [EMAIL PROTECTED] --Computers are like air conditioners -- they stop working properly if you openWINDOWS -- What about the four lusers of the apocalypse? I nominate: "advertising", "can't log in", "power switch" and "what backup?" --Alistair YoungCalven _______________________________________________ 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/arroz% 40guiamac.comThis email sent to [EMAIL PROTECTED]
Miguel Arroz http://www.terminalapp.net http://www.ipragma.com
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ 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/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
