<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi Yvo.<br>
<br>
Sorry, no luck. It seems de JDBC-ODBC bridge is not working well and
it has a bug for different charsets.<br>
<br>
<a href="http://www.tek-tips.com/viewthread.cfm?qid=1248844">http://www.tek-tips.com/viewthread.cfm?qid=1248844</a><br>
<br>
<a href="http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=6345277">http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=6345277</a><br>
<br>
I think the only solution is to use other database, if possible.
¿PosgreSQL?, or dbf files.<br>
In my opinion, the problem is in this file:<br>
<br>
<a
href="http://javasourcecode.org/html/open-source/jdk/jdk-6u23/sun/jdbc/odbc/JdbcOdbcResultSet.java.html">http://javasourcecode.org/html/open-source/jdk/jdk-6u23/sun/jdbc/odbc/JdbcOdbcResultSet.java.html</a><br>
<br>
but I'm not sure how to fix it.<br>
<br>
If you can solve the problem by your own I'll be glad to know how.<br>
<br>
Best regards.<br>
<br>
Fran.<br>
<br>
PS: The tests I've made were by supposing that field was encoded in
<br>
<table style="font-family: 'Times New Roman'; letter-spacing:
normal; orphans: 2; text-indent: 0px; text-transform: none;
widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto;
-webkit-text-stroke-width: 0px; background-color: rgb(255, 255,
255); " border="1">
<tbody>
<tr>
<td width="150">
<p>ISO8859_5</p>
</td>
<td width="500">
<p>ISO 8859-5, Latin/Cyrillic alphabet</p>
</td>
</tr>
</tbody>
</table>
<br>
El 12/05/2012 6:36, Yvo Weidmann escribió:
<blockquote cite="mid:000c01cd2ff8$d83e9f70$88bbde50$@com"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-1">
<meta name="Generator" content="Microsoft Word 12 (filtered
medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Vorformatiert Zchn";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Sprechblasentext Zchn";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";
color:black;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
color:black;}
span.HTMLVorformatiertZchn
{mso-style-name:"HTML Vorformatiert Zchn";
mso-style-priority:99;
mso-style-link:"HTML Vorformatiert";
font-family:Consolas;
color:black;}
span.E-MailFormatvorlage19
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.E-MailFormatvorlage20
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.SprechblasentextZchn
{mso-style-name:"Sprechblasentext Zchn";
mso-style-priority:99;
mso-style-link:Sprechblasentext;
font-family:"Tahoma","sans-serif";
color:black;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:1016347317;
mso-list-type:hybrid;
mso-list-template-ids:736683874 -75050368 134676483 134676485 134676481 134676483 134676485 134676481 134676483 134676485;}
@list l0:level1
{mso-level-start-at:0;
mso-level-number-format:bullet;
mso-level-text:-;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-font-family:Calibri;}
@list l1
{mso-list-id:1866019295;
mso-list-type:hybrid;
mso-list-template-ids:-1556986386 1126213618 134676483 134676485 134676481 134676483 134676485 134676481 134676483 134676485;}
@list l1:level1
{mso-level-start-at:0;
mso-level-number-format:bullet;
mso-level-text:-;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-font-family:Calibri;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal"><span style="color:#1F497D">Dear Francisco<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US">Thank
you very much for the quick replay. Please find a small
database in the attachment with mixed (Latin and Cyrillic
entries).<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US">There
is one table containing data:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US">-
tblWatershed with names in English and Tajik (Cyrillic)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US">There
are two queries / views containing only English in one and
only Tajik names in the other:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US">-
qryWatershed_En with names in English<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US">-
qryWatershed_Tj with names in Tajik<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US">Also
as attachment two printscreens of the linked table and query
in gvSIG.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US">The
ODBC connection was established locally with the default
ODBC driver for Microsoft Access. No special settings were
used.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US">Hope
you can work with this set of information.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US">Looking
forward,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US">Yvo<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span style="color:#1F497D" lang="TG">---------------------------------------------------------<br>
Yvo Weidmann<br>
734003, 4 Farkhad Str.<br>
Dushanbe<br>
Republic of Tajikistan<br>
Mobile +992 98 53 11 090<br>
Skype yvo.weidmann<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Web <a
moz-do-not-send="true" href="http://www.geoidee.ch">www.geoidee.ch</a><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF
1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span
style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext"
lang="DE">Von:</span></b><span
style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext"
lang="DE"> <a moz-do-not-send="true"
href="mailto:gvsig_internacional-bounces@listserv.gva.es">gvsig_internacional-bounces@listserv.gva.es</a>
<a moz-do-not-send="true"
href="mailto:[mailto:gvsig_internacional-bounces@listserv.gva.es]">[mailto:gvsig_internacional-bounces@listserv.gva.es]</a>
<b>Im Auftrag von </b>Francisco José Peñarrubia<br>
<b>Gesendet:</b> Freitag, 11. </span><span
style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext"
lang="EN-US">Mai 2012 17:57<br>
<b>An:</b> Users mailing list<br>
<b>Betreff:</b> Re: [Gvsig_english] Cyrillic characters
by using ODBC connection<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Hi Yvo.<br>
<br>
Do you have an example database in order to make some
tests?. If yes, please, send to us, and I will try to
investigate the problem.<br>
<br>
Cheers.<br>
<br>
Fran.<br>
<br>
El 11/05/2012 14:24, Yvo Weidmann escribió: <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Dear gvSIG list<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">I connect successfully
an Access-Database by using standard ODBC driver on a
Windows XP machine. Reading tables and queries is working
perfectly.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">But in several tables
and queries I have attributes containing Cyrillic letters.
That works perfectly in Access and other ODBC clients (such
as ArcGIS). Unfortunately, the Cyrillic letters are not
correctly encoded in gvSIG ( displayed as ‘????’).<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Is there a way to set
the correct encoding in the JDBC-ODBC bridge? Or is there
another known limitation by using ODBC connections with
non-Latin letters?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Looking forward to any
hint,<o:p></o:p></span></p>
<p class="MsoNormal">Yvo<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal"><span lang="TG">---------------------------------------------------------<br>
Yvo Weidmann<br>
734003, 4 Farkhad Str.<br>
Dushanbe<br>
Republic of Tajikistan<br>
Mobile +992 98 53 11 090<br>
Skype yvo.weidmann</span><span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Web </span><a
moz-do-not-send="true" href="http://www.geoidee.ch"><span
lang="EN-US">www.geoidee.ch</span></a><span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> <o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Times New
Roman","serif"" lang="EN-US"><br>
<br>
<br>
<o:p></o:p></span></p>
<pre><span lang="EN-US">_______________________________________________<o:p></o:p></span></pre>
<pre><span lang="EN-US">Gvsig_internacional mailing list<o:p></o:p></span></pre>
<pre><a moz-do-not-send="true" href="mailto:Gvsig_internacional@listserv.gva.es"><span lang="EN-US">Gvsig_internacional@listserv.gva.es</span></a><span lang="EN-US"><o:p></o:p></span></pre>
<pre><span lang="EN-US"><o:p> </o:p></span></pre>
<pre><span lang="EN-US">To see the archives, edit your preferences or unsubscribe from this mailing list, please access this url:<o:p></o:p></span></pre>
<pre><span lang="EN-US"><o:p> </o:p></span></pre>
<pre><a moz-do-not-send="true" href="http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional"><span lang="EN-US">http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional</span></a><span lang="EN-US"><o:p></o:p></span></pre>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Times New
Roman","serif"" lang="EN-US"><br>
<br>
<o:p></o:p></span></p>
<pre>-- <o:p></o:p></pre>
<pre>Fran Peñarrubia<o:p></o:p></pre>
<pre>Scolab<o:p></o:p></pre>
<pre><a moz-do-not-send="true" href="http://www.scolab.es">www.scolab.es</a><o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>Asociación gvSIG<o:p></o:p></pre>
<pre><a moz-do-not-send="true" href="http://www.gvsig.com">www.gvsig.com</a><o:p></o:p></pre>
</div>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Fran Peñarrubia
Scolab
<a class="moz-txt-link-abbreviated" href="http://www.scolab.es">www.scolab.es</a>
Asociación gvSIG
<a class="moz-txt-link-abbreviated" href="http://www.gvsig.com">www.gvsig.com</a>
</pre>
</body>
</html>