Charset question

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Charset question

agnesedalmonte

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
Reply | Threaded
Open this post in threaded view
|

Re: Charset question

HankRatz

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
Hank Ratzesberger
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
Reply | Threaded
Open this post in threaded view
|

Re: Charset question

Alessandro  Vernet
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