My name is Hazem Ameen. I’m an Oracle DBA with 13 years of experience. I’ve been living and working in Riyadh, Saudi Arabia since 2003. Prior to that, I lived and worked in Chicago Illinois. Through this blog, I plan on sharing some technical tips and life experience in Saudi Arabia. Those who moved to KSA or planning on doing so might find some useful info here.
I could be emailed at hazem.ameen@gmail.com
About Me
4 Comments »
RSS feed for comments on this post. TrackBack URI
Dear Mr Ameen
I am facing a problem and I would like your help.
We are using Oracle 10g database (AL32UTF8).
We have loaded some data into a table from a csv(comma seperated variable) file.
We are able to see the Arabic characters from the table in Oracle SQL developer, but we are not able see the data in the application.
Our application is a Java based web application and we are using Oracle 10G application server.
If we enter data in the application (Internet Explorer front end) and save it, we are able to retrieve and view the Arabic characters.
I can provide other information to help you understand this issue.
Please help us by giving some idea as to why we are facing this problem.
Thanks a lot in advance
Vadi
Comment by Vadi — October 6, 2008 @ 12:15 pm |
Vadi,
Please use the dump function (ex. select dump(arabic_column, 1016) from table_name) on data you uploaded (csv) and data entered via IE. Do see a difference in the encoding between the 2 sets of data? Are both dumps UTF8?
Also, what is your NLS_LANG setting when you were uploading csv? is it the same as your application server.
Comment by ksadba — October 7, 2008 @ 4:03 pm |
Hi Ameen,
I visited your site Recently while seraching some tips for oracle db and found it is very helpfull. Your language and explanation is impressisve and understanadable for a normal person like me where my main work area is in Unix & Linux administartion.
Thanks brother and all the best.
Comment by Manoj — May 1, 2009 @ 9:08 pm |
Thanks Manoj, appreciate your comment
Comment by ksadba — May 2, 2009 @ 1:54 am |