• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: What a bunch of characters
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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 "&#8804&#8805&#946&#8730&#945&#947&#948".

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

References: 
 >What a bunch of characters (From: Calven Eggert <email@hidden>)
 >Re: What a bunch of characters (From: Miguel Arroz <email@hidden>)
 >Re: What a bunch of characters (From: Calven Eggert <email@hidden>)
 >Re: What a bunch of characters (From: "Daniele Corti" <email@hidden>)
 >Re: What a bunch of characters (From: Calven Eggert <email@hidden>)
 >Re: What a bunch of characters (From: "Daniele Corti" <email@hidden>)
 >Re: What a bunch of characters (From: Calven Eggert <email@hidden>)

  • Prev by Date: Re: What a bunch of characters
  • Next by Date: Re: What a bunch of characters
  • Previous by thread: Re: What a bunch of characters
  • Next by thread: Re: What a bunch of characters
  • Index(es):
    • Date
    • Thread