[Gvsig_english] Cyrillic characters by using ODBC connection

[Yvo Weidmann]

Dear Francisco

 

Thank you very much for the quick replay. Please find a small database in
the attachment with mixed (Latin and Cyrillic entries).

 

There is one table containing data:

- tblWatershed with names in English and Tajik (Cyrillic)

 

There are two queries / views containing only English in one and only Tajik
names in the other:

- qryWatershed_En with names in English

- qryWatershed_Tj with names in Tajik

 

Also as attachment two printscreens of the linked table and query in gvSIG.

 

The ODBC connection was established locally with the default ODBC driver for
Microsoft Access. No special settings were used.

 

Hope you can work with this set of information.

 

Looking forward,

Yvo

 

---------------------------------------------------------
Yvo Weidmann
734003, 4 Farkhad Str.
Dushanbe
Republic of Tajikistan
Mobile +992 98 53 11 090
Skype yvo.weidmann

Web www.geoidee.ch

 

Von: gvsig_internacional-bounces at listserv.gva.es
[mailto:gvsig_internacional-bounces at listserv.gva.es] Im Auftrag von
Francisco José Peñarrubia
Gesendet: Freitag, 11. Mai 2012 17:57
An: Users mailing list
Betreff: Re: [Gvsig_english] Cyrillic characters by using ODBC connection

 

Hi Yvo.

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.

Cheers.

Fran.

El 11/05/2012 14:24, Yvo Weidmann escribió: 

Dear gvSIG list

 

I connect successfully an Access-Database by using standard ODBC driver on a
Windows XP machine. Reading tables and queries is working perfectly.

 

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 ‘????’).

 

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?

 

Looking forward to any hint,

Yvo

 

---------------------------------------------------------
Yvo Weidmann
734003, 4 Farkhad Str.
Dushanbe
Republic of Tajikistan
Mobile +992 98 53 11 090
Skype yvo.weidmann

Web  <http://www.geoidee.ch> www.geoidee.ch

 






_______________________________________________
Gvsig_internacional mailing list
 <mailto:Gvsig_internacional at listserv.gva.es>
Gvsig_internacional at listserv.gva.es
 
To see the archives, edit your preferences or unsubscribe from this mailing
list, please access this url:
 
 <http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional>
http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional





-- 
Fran Peñarrubia
Scolab
www.scolab.es
 
Asociación gvSIG
www.gvsig.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserv.gva.es/pipermail/gvsig_internacional/attachments/20120512/0f3d54c8/attachment.htm 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Query.jpg
Type: image/jpeg
Size: 15603 bytes
Desc: not available
Url : http://listserv.gva.es/pipermail/gvsig_internacional/attachments/20120512/0f3d54c8/attachment.jpg 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Table.jpg
Type: image/jpeg
Size: 22224 bytes
Desc: not available
Url : http://listserv.gva.es/pipermail/gvsig_internacional/attachments/20120512/0f3d54c8/attachment-0001.jpg 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: EncodingTest.zip
Type: application/x-zip-compressed
Size: 20400 bytes
Desc: not available
Url : http://listserv.gva.es/pipermail/gvsig_internacional/attachments/20120512/0f3d54c8/attachment.bin