[Bmfo-devel] [ bmfo-Support Requests-1519870 ] Loading Meter.dbf

[SourceForge.net <no...@so...>]

Support Requests item #1519870, was opened at 2006-07-10 10:19
Message generated for change (Comment added) made by ahmad2005
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=533723&aid=1519870&group_id=72204

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
Status: Open
Priority: 5
Submitted By: ahmad2005 (ahmad2005)
Assigned to: ahmad2005 (ahmad2005)
Summary: Loading Meter.dbf

Initial Comment:
i'm trying to load meter.dbf with filling 
ARABICLOCATION field arabic names. but when i'm 
trying to load this file the insert statement appear 
like :- 
insert into meter 
(AdministrativeArea,FacilityID,LocationDescription,Lif
ecycleStatus,ArabicLocationDescription,Elevation,Subty
pe,WaterType,OperationalArea,Diameter,FlowRange,Measur
ement1,Rotation,PressureRating,Owner,Subscription,Use,
Aggregation,AgencyCode) values (10010,'AB1323','HANIA 
MOH`D ALSABAWI','','쟫ﬠꥪ? ?髠㟭
溺'','','',10010,'','','','','','','','','AB1323','Waj'
)
so arabic character appears in the database like 
these unreadable language.

oracle characterset in my pc. is AR8ISO8859P6 


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

>Comment By: ahmad2005 (ahmad2005)
Date: 2006-07-10 11:39

Message:
Logged In: YES 
user_id=1254709

now i'm trying to find a tools that allow me to convert 
DBF file to SQL statement and i found (DBF Viewer 2000)
program which can allow me to covert DBF file to SQL 
insert statement so i can loading it as insert statement 
in oracle database.

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

Comment By: Steffen Macke (sdteffen)
Date: 2006-07-10 10:27

Message:
Logged In: YES 
user_id=30248

I see two basic approaches:

* Use the WINDOWS-1256 encoding as recommended in the BMFO
Administration Guide - I guess this will require creation of
a new ORACLE database or even ORACLE reinstallation.
Tweaking of registry settings is not recommended as the
administration guide says.

* Use a tool like iconv to recode your shapefile (I assume
it is WINDOWS-1256 encoded, please confirm) to ISO8859-6. If
this would be PostgreSQL, recoding could be done on the fly
by simply setting the PGCLIENTENCODING environment variable.
However, I'm not aware of such an option for ORACLE.

Please indicate which approach you prefer.

Does this problem also apply to your production system? I
hope that at least there the recommendation from the
administration guide was implemented.

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

Comment By: abdulqader jaradat (jaradat_abed)
Date: 2006-07-10 10:24

Message:
Logged In: YES 
user_id=697097

Ahmad regarding this problem you should drop the oracle 
database and re-create it with ar8mswin1256 character set.

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

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=533723&aid=1519870&group_id=72204