Server Administration :: Arabic Language Support
Apr 14, 2013
i installed database 10g with English language support and imported a dump file contains tables having columns in arabic
so after search i did these steps
SHUT;
CONN SYS/SYS AS SYSDBA
STARTUP RESTRICT;
Alter database character set INTERNAL_USE AR8ISO8859P6; (for arabic) which we want.
SHUT;
STARTUP
after the previous steps i checked on the nls_characterset from NLS_DATABASE_PARAMETERS and found it changed to AR8ISO8859P6 and that's right after that i can insert any arabic character to the tables but the original data still the same
is there anyway i can do to change the original data to be read in Arabic or i should make another import
View 1 Replies
ADVERTISEMENT
May 4, 2011
Is it possible to extract kannada text from a pdf document using INSO filter ?
Or Does it support only English Language ?
View 5 Replies
View Related
Mar 12, 2012
I want to enter data in Arabic and English through Oracle Forms6i.
View 8 Replies
View Related
Aug 8, 2010
My arabic data appears like ???????
How could I setup Arabic for forms , database?
I have 10G oracle database, forms,reports.
View 13 Replies
View Related
Mar 13, 2011
While generating reports, arabic languages are not exceuting in a normal format.
instead of سيبسيل its appearing as ÈãÇÚÒ íÊÎØÇÁ ÇáÔÇÑÚ æÇÕØÏãÉ æÊæÝÇÁ ÇáãÇÚÒ
[/bold]
1) we have done following changes at DB level.
CONN SYS/SYS@THAI AS SYSDBA;
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
[code]...
2) also installed regional Language.
View 10 Replies
View Related
Apr 18, 2010
Which is changing language in form from English to Arabic and vise versa during run time when I validate from item to another one ..
View 5 Replies
View Related
Dec 16, 2012
I have two requirements that we have an ERP with default language (English US) and now we need :
1) Put Arabic support in our forms and reports
2) Add Rich Text Tool in our forms and reports
View 2 Replies
View Related
Feb 8, 2012
When I transfer the data from Oracle to MS SQL I have one column in a table which is of Arabic Language.The data is fine in Oracle but when I transfer it to MS SQL Server I see that the text in MS SQL server appears as junk.
View 1 Replies
View Related
Jul 16, 2013
I have an Oracle DB's charset configured for Korean language and things in there are English and Korean and they are working fine. If i try to import a txt file with Chinese characters into the DB. It doesn't show correctly on query.
Is there any way I can solve this ? Since I find that there are many charset / NLS language options througout DB. I read from others that they have the following response. Any alternative beside changing the whole DB charset ?
Recreate the database with the correct character set
Convert the database to AL32UTF8. Documentation link
Change the databases National Character Set to AL32UTF8 & change your application to use NVARCHAR2()/NCHAR() datatypes instead of VARCHAR2() (documented at the same link as above)
View 5 Replies
View Related
May 17, 2012
I tried more to write Bangla in Oracle 10gR1, or 10gR2 or Express but failed. When I write bangla in the "emp_name" field for employee name this can be save, But when I execute to see the data again then the data comes with a big change like some symbol for some character.
View 3 Replies
View Related
May 7, 2010
i have to import Data (exported with EXP) from a 8.1.6 Database running with GERMAN_GERMANY.WE8MSWIN1252 language settings. The destination database is running with GERMAN_GERMANY.AL32UTF8.
What do i have to do to import (IMP) the data correctly?
View 2 Replies
View Related
Feb 1, 2012
DECLARE @MainTable TABLE (UniqueID INTEGER, Category VARCHAR(200), WeekDate DATETIME, VALUE INTEGER)
INSERT INTO @MainTable VALUES(123, 'Shirts', '10/07/2011', 5000)
INSERT INTO @MainTable VALUES(123, 'Shirts', '10/14/2011', 8000)
INSERT INTO @MainTable VALUES(124, 'Pants', '10/07/2011', 4000)
INSERT INTO @MainTable VALUES(125, 'Shorts', '10/14/2011', 8000)
INSERT INTO @MainTable VALUES(126, 'Shoes', '10/21/2011', 9000);
--select * from @MainTable;
[code]...
The query works with all the CTEs up to the last select statement. Oracle does not support the OUTER APPLY statement, how should the last piece be written to make it work in Oracle?
View 1 Replies
View Related
Jun 10, 2010
I have a From which take Logical Backup through oracle export utility. This Form work fine when i Start OCJ4 but when i want to take backup after running oracle Forms & Report services its not take backup.
My Question is dose Oracle Forms & Report Services (Standalone) Support data backup through Export (exp) utility. I have install Oracle Forms and Report Services (Standalone) on Window XP (SP-3).
View 1 Replies
View Related
Jan 15, 2013
I am trying to transfer data from Oracle database table into another table resides in a SQL server 2008. A database link is already set, and data can be selected/queried using
select * from a_table@db_link
the thing is when trying to insert Arabic data from Oracle to a SQL server table
insert into a_table@db_link values(
'N''some data in Arabic'' ,
'11-oct-00',
'some data in English'
);
commit;
its inserted alright, but when we try to display the data it shows like this instead of displaying Arabic, the english data is alright, but also date show as garbage?!!
when trying to insert arabic data directly through SQL server its fine though.I suggested that we transfer data through ODBC to flat files like Acess and then to SQL server but the team rejected it since they're going to do it daily and the data is huge( we are talking more than 28000 records).
View 1 Replies
View Related
Aug 18, 2013
AVDF current version 12.1 not support External/SAN storage. my question is, if customer get a huge number of Audit log and DBFW event records, then how max size can Audi Vault server support for online data (not archive data)? and can I use a Hardware server with multiple HDDs for AV Server?
View 0 Replies
View Related
Nov 19, 2012
How to get my profile in oracle support ? i need to know to many license what we have in oracle how to get this ,ex: oracle rac 11g , application server 10g ...etc.
View 13 Replies
View Related
Oct 4, 2010
I wants to ask about CLOB that:
Is Form 6i support CLOB?
and also can we use LONGROW for storing images into database?
what exactly difference between these two data types in usage..
View 1 Replies
View Related
Mar 15, 2011
I read the Website URL....and searching now for an alternative way for a small Oracle DB around 120 - 250 GB Data.I cant find any DRAM SSD that seems to suite the needs of such a small amount of data to a valuable price.
The only Hdd i found is URL... but im not sure if thats the right thing and if its possible to still buy such a device.where do we get such a device in Europe(swiss) and what would be the price for such a device?
Do i need to make a special setup within oracle (11g R2) to get the maximum out of such a DRAM SSD?
View 1 Replies
View Related
Jul 9, 2012
firefox 14.0 can run oracle 10g forms ? and how can run ?
View 7 Replies
View Related
Nov 16, 2011
that windows7 will support oracle 11g and oracle 10 g
View 1 Replies
View Related
Dec 8, 2011
Do Oracle SQL support Domain Concept?
View 3 Replies
View Related
Sep 15, 2009
1-i have exported a database 9i with character set WE8MSWIN1252 which is her original character set;
2- i have created a new database 10G R2 with character set AL32UTF8;
3- i have imported the .dmp file to this new database with imp.exe 9i version configured with WE8MSWIN1252 character set;
-The problem is:
* when i use sqlplus, arabic data displays correctly but, in forms 10G, arabic data displays lick this ?E?? EC???IEC...... HOW CAN I CONFIGURE FORMS TO DISPLAY CORRECTLY ARABIC DATA?
View 3 Replies
View Related
May 26, 2013
As my requirement is that to find week for particular date according to Arabic calender.As per Arabic calender first day for year starts from saturday.
so when i execute query :
select to_char(to_date('05/26/2013','MM/DD/RRRR'),'WW')
from dual;
Then it gives 21,but as per arabic calender it should show 22nd week.
getting result according to Arabic calender as it should return 22,because weak starts from saturday according to Arabic calender.
View 6 Replies
View Related
Mar 17, 2010
problem is that when i call run_product to generate a report from a form i have the name of employee in arabic characters appear in wrong form. yet when i use query from forms directly or from reports directly. name appears correct.
i want the arabic charcters to appear correct when i call to show report from a form..
View 6 Replies
View Related
Oct 12, 2010
oracle 10G who knows why Oracle SQL doesn't support %TYPE when create a table. But it supports it when we use it in PL/SQL.
SQL> create table wg_1
(account_category JNL_WORK_LIST.ACCOUNT_CATEGORY%TYPE)
;
2 3 (account_category JNL_WORK_LIST.ACCOUNT_CATEGORY%TYPE)
*
ERROR at line 2: ORA-00911: invalid character
SQL> desc JNL_WORK_LIST
Name Null? Type
----------------------------------------- -------- ----------------------------
ACCOUNT_NO NOT NULL NUMBER(10)
BILL_REF_NO NOT NULL NUMBER(10)
BILL_REF_RESETS NOT NULL NUMBER(3)
JNL_EARNED_THRU_DT DATE
[code]...
PL/SQL procedure successfully completed.
View 3 Replies
View Related
Mar 2, 2007
I have downloaded oracle 10g express edition. I have tried to connect forms 6i in that in windows xp environment but when i tried to connect it is not connecting and giving "don't send" error.
If there is any patch to connect forms 6i into oracle 10g express edition.
View 3 Replies
View Related
Jan 24, 2012
i have created a listener for my db and register the service to it some 2 years back now i have checked it and it display as follows
LSNRCTL for Solaris: Version 11.2.0.1.0 - Production on 24-JAN-2012 13:49:44
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.x.x.x)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Solaris: Version 11.2.0.1.0 - Production
Start Date 24-JAN-2012 13:45:44
Uptime 0 days 0 hr. 3 min. 59 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
[code]....
now i have stop and then restart but same status? so how can i manually register it again or anyother solution as i cant run netmgr
View 14 Replies
View Related
Jun 30, 2013
DB: 11.2.0.3 & OS: RHEL5 Easy Connect Naming method enhances the host naming method by allowing for a port and service specification. My question is does Oracle 11g support Host naming method?
View 4 Replies
View Related
Sep 2, 2013
We cache oracle 11g2 data in timesten 11.2.2.5.0 ( IMDB ) We can't find any trigonometric functions like cos(x), sin(x) or so in timesten. Does that means timesten doesn't support trigonometric functions?
View 2 Replies
View Related
May 29, 2013
Our API supports Oracle 11.2g but uses OCI v8 yet.This means I cant activate client caching as a new feature ? We should update to OCIv11 ?
View 5 Replies
View Related