Oracle saving arabic numbers as "??"

Asked May 14 '13 at 14:08

Active Nov 02 '15 at 06:32

Viewed 784 times

Working on Winform based app connecting Oracle via OleDbDatareader, when I save any data having arabic number, for instance: اب۸۴۴ it saves it as اب???

I am using varchar type. It is weird it save non numeric data as it is but entering digits in arabic keyboard messes with entire string.

I am using Oracle 10g XE

asked May 14 '13 at 14:08

Volatil3

14,253
38
134
263

[related comment](http://stackoverflow.com/questions/15347563/connect-c-sharp-windows-form-application-to-oracle-db#comment21679096_15347563) (only part 2) – Federico Berasategui May 14 '13 at 14:54
What is your database character set? Are you using the Unicode version of Oracle XE? – Justin Cave May 14 '13 at 15:00
@JustinCave How can I check it? Also I would like to tell that in production we will be using Oracle Standard Edition – Volatil3 May 14 '13 at 18:19
@HighCore I don't know what kind of related code your are asking for, It is a simple select and isnert query, data type is Varchar2 – Volatil3 May 14 '13 at 18:23
What does `select value from v$nls_parameters where parameter = 'NLS_CHARACTERSET'` return? – Justin Cave May 14 '13 at 19:27
it returns *AL32UTF8* on executing the query – Volatil3 May 15 '13 at 03:38
@JustinCave any idea please? – Volatil3 May 16 '13 at 05:51
If you `select dump(column_name) from table_name where some_condition`, that will show you the actual code points stored in the database. Is the data being stored correctly (indicating the the problem is a display issue)? Or is the data being stored incorrectly (indicating that the problem occurs while writing the data)? – Justin Cave May 17 '13 at 19:14
It is not being store correctly either – Volatil3 May 17 '13 at 19:15
did you find the solution @Volatil3 please write it here – FarOoOosa May 29 '18 at 08:34

Oracle saving arabic numbers as "??"

0 Answers0