Oracle Database character set issue with the audit tables on Debian

Posted by Leonid Shirmanov on Stack Overflow See other posts from Stack Overflow or by Leonid Shirmanov
Published on 2009-06-04T08:03:10Z Indexed on 2010/04/02 20:03 UTC
Read the original article Hit count: 318

Filed under:

Oracle

|

globalization

|

character-encoding

|

audit

I've got Oracle XE installed on Debian linux and the character set is configured to AL32UTF8. There are several client applications that connects to a database from Windows with the different locales - French etc, not English. That's ok with all the client data these applications put into database, nothing converted and text data in French represents correctly.

But texts in audit tables looks like '??????' if contains any not-english character. I suppose this is because audit records go to database in the different locale and it's not dependent on the client's globalization/locale settings.

How this globalization issue can be fixed? thanks!

© Stack Overflow or respective owner

Related posts about Oracle

E-Business Suite Technology Sessions at OpenWorld 2012

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Oracle OpenWorld 2012 is almost here! We're looking forward to updating you on our products, strategy, and roadmaps. This year, the E-Business Suite Applications Technology Group (ATG) will participate in 25 speaker sessions, two Meet the Experts round-table discussions, five demoground booths and… >>> More
26 Days: Countdown to Oracle OpenWorld 2012

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Welcome to our countdown to Oracle OpenWorld! Oracle OpenWorld 2012 is just around the corner. In less than 26 days, San Francisco will be invaded by an expected 50,000 people from all over the world. Here on the Oracle WebCenter team, we’ve all been working to help make the experience a great… >>> More
OTN ???? ?????? ???????

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Database ?? Database ??????? Database ?????????? Java WebLogic Server/????????·???? SOA/BPM/????? ???????/???? ID??/?????? ?????EPM/BI EPM/BI ??????? EPM/BI ???? OS/??? ???? ????? MySQL Database ?? ???? ?? ????????? ??? ?? ORACLE MASTER… >>> More
SOA PARTNER COMMUNITY NEWSLETTER JULY 2012

as seen on Oracle Blogs - Search for 'Oracle Blogs'
SOA PARTNER COMMUNITY NEWSLETTER JULY 2012 Dear SOA partner community member To provide our community members the best of our knowledge, we want your feedback on our SOA Partner community. Thus we are organizing SOA Partner Community Survey 2012. We… >>> More
Oracle ADF Coverage at OOW

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Below is the schedule for all ADF related sessions at a glance. Note the Meet and greet session added for Wednesday Octiber 3rd from 4.30 pm to 5:30. Oracle ADF and Fusion Development General Session Mon 1 Oct,… >>> More

Related posts about globalization

Script globalization of MicrosoftAjax.js in ASP.NET MVC

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, Could you write where I can find (or where you found ;)) globalization files (e.g. zu-ZA.js), I can't find that files in Microsoft AJAX Library 3.5. Best regards, Michal >>> More
jQuery Globalization Plugin from Microsoft

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Last month I blogged about how Microsoft is starting to make code contributions to jQuery, and about some of the first code contributions we were working on: jQuery Templates and Data Linking support. Today, we released a prototype of a new jQuery Globalization Plugin that enables you to add globalization… >>> More
Supply Chain Globalization and the changes in the world of Manufacturing

as seen on Oracle Blogs - Search for 'Oracle Blogs'
John Barcus, Senior Director, Supply Chain Applications talks with Fred about the important current trends for Manufacturers, supply chain globalization as well as the role of technology in the Manufacturing space. >>> More
Globalization in WPF or Silverlight

as seen on Code Project - Search for 'Code Project'
Dynamic globalization for WPF and Silverlight apps without breaking design time. >>> More
Globalization Challenges and Opportunities: A Conversation with The Boston Consulting Group's Hal Si

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Hal Sirkin, Globalization Practice Manager at The Boston Consulting Group and author of the new book Globality, talks with Folia Grace, Oracle's Vice President of ERP Product Marketing, about the seven struggles all companies face as global competition intensifies, and the strategies you can adopt… >>> More