|
|
|
| Hello There!
mobilink: 902.3044
ultralite 9.0.1
i have a problem with synchronizing hebrew characters.
when i insert it into the ultralite it's ok, but when i want
to synchronize it through the mobilink into Oracle, i have a
problem in the mobilink the hebrew characters comes out in
question marks (?)
does any body have an idea??
can i configure the mobilink codepage??(856)
have a nice weekend,
Omri ziv
| |
| David Fishburn 2005-10-31, 7:24 am |
| Omri wrote in news:4360f21f.76f9.1681692777@sybase.com
of sybase.public.sqlanywhere.mobilink:
O> mobilink: 902.3044
O> ultralite 9.0.1
O> i have a problem with synchronizing hebrew characters.
O> when i insert it into the ultralite it's ok, but when i want
O> to synchronize it through the mobilink into Oracle, i have a
O> problem in the mobilink the hebrew characters comes out in
O> question marks (?)
O> does any body have an idea??
O> can i configure the mobilink codepage??(856)
How did you create the UL database?
Did you use ULGEN, ULINIT, UltraLite Schema Painter?
What command line did you use?
What code page is the Oracle server?
What ODBC Driver (and version #) are you using to connect ML to Oracle?
Please start ML using -v+ -ot ml.txt and post the output.
--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).
EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm
Developer Community / Whitepapers
http://www.ianywhere.com/developer
CaseXpress - to report bugs
http://casexpress.sybase.com
CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]
| |
|
| Hi David!
i found the solution!
i program in c#, the hebrew in the ppc is unicode so i had
to translate it to ascii and then to insert to the ultralite
only then the mobilink got it and the oracle as well.
good day
Omri
| |
| David Fishburn 2005-11-01, 9:23 am |
| Omri wrote in news:43675f2e.4403.1681692777@sybase.com
of sybase.public.sqlanywhere.mobilink:
O> i found the solution!
O> i program in c#, the hebrew in the ppc is unicode so i had
O> to translate it to ascii and then to insert to the ultralite
O> only then the mobilink got it and the oracle as well.
That should not be necessary.
If you are using a compatible character set between the UL database and
the Oracle database, no conversions should be necessary.
Your reponse tells me the UL and Oracle databases are using two
different and incompatible character sets.
--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).
EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm
Developer Community / Whitepapers
http://www.ianywhere.com/developer
CaseXpress - to report bugs
http://casexpress.sybase.com
CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]
| |
| Greg Fenton 2005-11-01, 9:23 am |
| David Fishburn wrote:
>
> Your reponse tells me the UL and Oracle databases are using two
> different and incompatible character sets.
Or that something between the two (e.g. the Oracle ODBC driver) is
mis-converting the data.
Which ODBC driver are you using for the MobiLink connection to the
consolidated?
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
| |
|
| > That should not be necessary.
>
> If you are using a compatible character set between the UL
> database and the Oracle database, no conversions should be
> necessary.
>
> Your reponse tells me the UL and Oracle databases are
> using two different and incompatible character sets.
> --
1) how do i configure charcter set in the UL using schema
painter?
2) the UL and the Oracl is not the problem th ML is!
in the ul i can see the characters fine and also in the
oracle, only in the ML the question marks are shown.
thanks alot anyway
Omri
| |
| Greg Fenton 2005-11-01, 8:48 pm |
| Omri wrote:
> 2) the UL and the Oracl is not the problem th ML is!
> in the ul i can see the characters fine and also in the
> oracle, only in the ML the question marks are shown.
ML itself does not do character set translation.
As I asked in my previous post, what ODBC driver (and version) are you
using for ML's connection to the consolidated?
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
| |
|
| Greg wrote!
> ML itself does not do character set translation.
> As I asked in my previous post, what ODBC driver (and
> version) are you using for ML's connection to the
> consolidated?
>
> greg.fenton
Hi Greg!
the ODBC driver that i'm using for th ML is :
iAnywhere solutions 9 Oracle wire protocol .
and again how can i config codepage in the UL.
have a great day
Omri
| |
|
| > UL Schema Painter
> -----------------
> If you are using the UL Schema Painter from the menu
> File->New, this is where you provide the filename for the
> UDB. It is also the dialog where you choose the correct
> code page.
>
OK you right!
a did it and i forgot i did it!
now there is two questions:
1) there is two hebrew codepage 856 and 862 (no 1255)
what is the right one and what the diffrences between
the two.
2) can i change the code page after i finish building the
UDB .
good day ,
Omri
| |
| David Fishburn 2005-11-03, 8:29 pm |
| Omri wrote in news:4369b38f.12f6.1681692777@sybase.com
of sybase.public.sqlanywhere.mobilink:
O>> UL Schema Painter
O>> -----------------
O>> If you are using the UL Schema Painter from the menu
O>> File->New, this is where you provide the filename for the
O>> USM. It is also the dialog where you choose the correct
O>> code page.
O>>
O> OK you right!
O> a did it and i forgot i did it!
O> now there is two questions:
O> 1) there is two hebrew codepage 856 and 862 (no 1255) what is the
O> right one and what the diffrences between the two.
Well that is something you are going to have to answer since I know
nothing about hebrew :-)
You can use the " %ASANY9%\win32\dbcol
lat.exe" utility to assist you.
I haven't really used it, but I think you do this:
dbinit -zs 1st_collation 1st_collation.db
dbinit -zs 2nd_collation 2nd_collation.db
dbcollat -c uid=dba;pwd=sql;dbf=
1st_collation.db -d 1st_collation.sql
dbcollat -c uid=dba;pwd=sql;dbf=
2nd_collation.db -d 2nd_collation.sql
Now open each file with an editor and see what is different.
I think this is something reasonably easy to do.
O> 2) can i change the code page after i finish building the
O> USM .
You can use " %ASANY9%\win32\ulxml
.exe" to convert your existing USM to
an XML file.
ulxml -toxml your_old.usm your_old.xml
Edit that file and you will see the following at the top:
<ul:ulschema xmlns:ul="urn:ultralite">
<collation name="1252LATIN1" case_sensitive="no"/>
So, use the UL Schema Painter to create a new USM with the code page you
want. Convert it to XML. Cut and paste the correct one into your old
one. Then use the utility to convert it back:
ulxml -tousm your_changed.xml your_changed.usm
Voila.
Check out the Help file for the various UL utility functions:
UltraLite Database User's Guide
UltraLite Utilities Reference
--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).
EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm
Developer Community / Whitepapers
http://www.ianywhere.com/developer
CaseXpress - to report bugs
http://casexpress.sybase.com
CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]
|
|
|
|