Hi, I have a problem with the interaction between Orbeon xforms and Oracle DataBase when I use accented characters. For example, in the xforms input fields I write à but in my database table I read à and if I put into another input field the value from the database it is à and not à. I think the problem is the incompatibility of charset, Orbeon uses UTF-8 and Oracle uses WE8MSWIN1252 so the characters encoding is different, is it possible?? Can I change the charset used by Orbeon?? -- You receive this message as a subscriber of the [hidden email] mailing list. To unsubscribe: mailto:[hidden email] For general help: mailto:[hidden email]?subject=help OW2 mailing lists service home page: http://www.ow2.org/wws |
Any replies to this? One thing that comes to mind is using xslt to change the character set. The <output> element has attribute "encoding" : http://www.w3schools.com/xsl/el_output.asp which can be set to an IANA recognized character set: http://www.columbia.edu/kermit/csettables.html in your case I suppose "windows-1252" Another step each time you want to push some data. Caveat: I have not tried this yet. Regards, Hank On Dec 17, 2009, at 6:46 AM, <[hidden email]> <[hidden email]> wrote: > > Hi, I have a problem with the interaction between Orbeon xforms and > Oracle > DataBase when I use accented characters. > For example, in the xforms input fields I write à but in my > database table I > read à and if I put into another input field the value from the > database it is > à and not à. > I think the problem is the incompatibility of charset, Orbeon uses > UTF-8 and > Oracle uses WE8MSWIN1252 so the characters encoding is different, > is it > possible?? > Can I change the charset used by Orbeon?? > > -- > You receive this message as a subscriber of the [hidden email] > mailing list. > To unsubscribe: mailto:[hidden email] > For general help: mailto:[hidden email]?subject=help > OW2 mailing lists service home page: http://www.ow2.org/wws NEES@UCSB Institute for Crustal Studies, University of California, Santa Barbara 805-893-8042 -- You receive this message as a subscriber of the [hidden email] mailing list. To unsubscribe: mailto:[hidden email] For general help: mailto:[hidden email]?subject=help OW2 mailing lists service home page: http://www.ow2.org/wws |
Administrator
|
In reply to this post by agnesedalmonte
Do you still have this issue? We have clients in Europe who regularly
use characters with accents, and they are using Orbeon Forms with Oracle, so this should work ;). If you still have this issue, how are you writing to Oracle? Are you using Form Runner with the Oracle persistence layer, or directly the SQL processor, or some other way? Alex On Thu, Dec 17, 2009 at 6:46 AM, <[hidden email]> wrote: > > Hi, I have a problem with the interaction between Orbeon xforms and Oracle > DataBase when I use accented characters. > For example, in the xforms input fields I write à but in my database table I > read à and if I put into another input field the value from the database it is > à and not à. > I think the problem is the incompatibility of charset, Orbeon uses UTF-8 and > Oracle uses WE8MSWIN1252 so the characters encoding is different, is it > possible?? > Can I change the charset used by Orbeon?? > > > -- > You receive this message as a subscriber of the [hidden email] mailing list. > To unsubscribe: mailto:[hidden email] > For general help: mailto:[hidden email]?subject=help > OW2 mailing lists service home page: http://www.ow2.org/wws > > -- Orbeon Forms - Web forms, open-source, for the Enterprise Orbeon's Blog: http://www.orbeon.com/blog/ My Twitter: http://twitter.com/avernet -- You receive this message as a subscriber of the [hidden email] mailing list. To unsubscribe: mailto:[hidden email] For general help: mailto:[hidden email]?subject=help OW2 mailing lists service home page: http://www.ow2.org/wws
--
Follow Orbeon on Twitter: @orbeon Follow me on Twitter: @avernet |
Free forum by Nabble | Edit this page |