[Zope-DB] Problem Inserting German characters( ? ? ? ? ? ?) using DCOracle

[Debojit Hazarika]

FYI

----- Forwarded by Debojit Hazarika/Zentrale/DeuBaExt on 24/08/04 14:52 -----
                                                                                                                                                   
                      Debojit Hazarika                                                                                                             
                                               To:      Cynthia Kiser <cnk at caltech.edu>@DEUBAINT                                                   
                      24/08/04 13:37           cc:                                                                                                 
                                               Subject: Re: [Zope-DB] Problem Inserting German characters( ? ? ? ? ? ?) using DCOracle(Document    
                                               link: Debojit Hazarika)                                                                             
                                                                                                                                                   



Hello Cynthia,

Many thanks for your response.

Actually you exactly pointed out the area where the problem was. The below environment setting solved the whole problem.

export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1


Regards
Debojit (Deb) Hazarika
Senior Software Engineer
------------------------------------------------------------------
DSL Software Limited [ HCL Technologies - IBTO ]
DSL Tower, Block IV,
No. 123, "Shivalaya" EPIP Phase II,
Whitefield Industrial Area,
Bangalore - 560 066
Website : www.dslsoft.net / www.hcltechnologies.com
------------------------------------------------------------------
Ph :  +91-80- 51385448
Mobile : 09845418238



                                                                                                                                                   
                      Cynthia Kiser                                                                                                                
                      <cnk at caltech.edu>        To:       Debojit Hazarika/Zentrale/DeuBaExt at Zentrale                                               
                                               cc:                                                                                                 
                      24/08/04 12:37           Subject:  Re: [Zope-DB] Problem Inserting German characters( ? ? ? ? ? ?) using DCOracle            
                                                                                                                                                   
                                                                                                                                                   




Sounds like you have a mismatch in character set between your html
forms and the database character set. Try to take the web
server/browser and html forms out of the equation for a moment. Can
you insert the same text into Oracle using DCOracle from the command
line? Is that with or without having NLS_LANG set in your environment?
Do you have the same setting in the script that starts your zope
instance? If all the command line stuff works, then you may need to
play with what characterset the Zope instance is using when displaying
and then processing forms. (I am hoping that just setting NLS_LANG
fixes it so you don't have to untangle that interaction.)

Quoting Debojit Hazarika <debojit.hazarika at db.com>:
> Hello,
>
> I am using DCOracle for a project of mine, its a great product and everything works fine for me, but i encountered a problem
> when i tried inserting some german characters (? ? ? ? ? ?).
> My problem is when i insert these german characters to oracle using DCOracle it gets stored as some unknown symbols.
> Any idea why? do i have to do some settings right. Can anyone please suggest me a solution for this.
>
> Many thanks in advance,
>
> Regards
> Deb
>
>
> --
>
> Diese E-Mail enth?lt vertrauliche und/oder rechtlich gesch?tzte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrt?mlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet.
>
> This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.
>
>
> _______________________________________________
> Zope-DB mailing list
> Zope-DB at zope.org
> http://mail.zope.org/mailman/listinfo/zope-db
>

--
Cynthia Kiser
cnk at caltech.edu
626 395-5710 (work)
626 616-9426 (cell)






--

Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet.

This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.