[Geomedia-l] arabic charcters not exported properly

[Ibrahim Hassan]

Hello Scott and Jeff,

 

Regarding the character "?"  when you export from access to oracle it is
normal when you export from Arabic environment to the English environment as
most of the computer are adjusted to the work with English as the defulat
language input and not prepared to allow the Arabic or any other language to
be seen

 

 

Please do the following in desirable machine where the user needs to see the
Arabic

 

 

1.       From Control Panel -> System -> Advanced tab -> Environmental
Variables button

Create a new entry variable called NLS_LANG

 

Set the value to  AMERICAN_AMERICA.AR8MSWIN1256                to receive
prompt and data in English

or 

Set the value to  ARABIC_AMERICA.AR8MSWIN1256                       to
receive prompt and data in Arabic

  

So wait there is more

 

2.       From Control Panel -> regional language settings> 

1-Set the location to any Arabic countries(UAE, Egypt) then go the

2- language tab> click Details> select advanced tab> in the Compatibility
configuration fame check the "extend support of advanced text services to
all programs"

3- Advanced tab> select Arabic(101) for the non-Unicode then check "apply
all the setting to the current user account and to the default user profile"

 

3.       Do restart (recommended) 

 

I hope this will solve the Arabic language problems,  awaiting the results 

 

 

 

Best Regards

Ibrahim Hassan

Experts Computer Consultancies Est.

M: 0503694610

O: 042696983

F: 042691722

 <mailto:eanwar at aldada.com> eanwar at aldada.com

 

From: geomedia-l-bounces at directionsmedia.net
[mailto:geomedia-l-bounces at directionsmedia.net] On Behalf Of
Jeff_Hobbs at sjwater.com
Sent: Friday, July 06, 2007 1:05 AM
To: sfalby at galdosinc.com; geomedia-l at directionsmedia.net
Cc: sdjuricic at galdosinc.com; dandrosevic at galdosinc.com
Subject: RE: [Geomedia-l] arabic charcters not exported properly

 

Scott,

 

Not sure if this helps, but you can export to shapefile using UTF-8. After
you have it exported, you might be able to use the free Oracle Shapefile
Loader tool and then import into Oracle Spatial.

 

Just a thought....

 

Jeff

 

 

 

--------------------------------

Jeff Hobbs

GIS Coordinator

San Jose Water Company (NYSE:SJW)

1265 South Bascom Avenue

San Jose, CA 95128

Voice - (408) 279-7833

Fax - (408) 279-7889

jeff_hobbs at sjwater.com

http://www.sjwater.com <http://www.sjwater.com/> 

 

 

  _____  

From: geomedia-l-bounces at directionsmedia.net
[mailto:geomedia-l-bounces at directionsmedia.net] On Behalf Of Scott Falby
Sent: Thursday, July 05, 2007 09:48
To: geomedia-l at directionsmedia.net
Cc: sdjuricic at galdosinc.com; dandrosevic at galdosinc.com
Subject: [Geomedia-l] arabic charcters not exported properly

I am trying to export my .mdb file to Oracle Object Model.  My database file
contains arabic characters and when I export the data the Arabic characters
are displayed as '?' characters.  I see in the help line that Export utility
generates ASCII files.  Is there an option to switch to UTF-8?  Are there
any other options that I can use to migrate my data to an oracle spatial
database?

 

_______________________________

 

Scott Falby

Senior Software Engineer, Team Lead

Galdos Systems

www.galdosinc.com <http://www.galdosinc.com/> 

(604) 638-5764

 

Be there when the Web and GIS unite! Register now for GeoWeb 2007 at
www.geoweb.org <http://www.geoweb.org/> 

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.directionsmedia.net/pipermail/geomedia-l/attachments/20070706/78c503aa/attachment-0001.html