[Gvsig_english] Cyrillic characters by using ODBC connection

[Francisco José Peñarrubia]

Hi Yvo.

Sorry, no luck. It seems de JDBC-ODBC bridge is not working well and it 
has a bug for different charsets.

http://www.tek-tips.com/viewthread.cfm?qid=1248844

http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=6345277

I think the only solution is to use other database, if possible. 
¿PosgreSQL?, or dbf files.
In my opinion, the problem is in this file:

http://javasourcecode.org/html/open-source/jdk/jdk-6u23/sun/jdbc/odbc/JdbcOdbcResultSet.java.html

but I'm not sure how to fix it.

If you can solve the problem by your own I'll be glad to know how.

Best regards.

Fran.

PS: The tests I've made were by supposing that field was encoded in

ISO8859_5

	

ISO 8859-5, Latin/Cyrillic alphabet


El 12/05/2012 6:36, Yvo Weidmann escribió:
>
> 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 <http://www.geoidee.ch>
>
> *Von:*gvsig_internacional-bounces at listserv.gva.es 
> <mailto:gvsig_internacional-bounces at listserv.gva.es> 
> [mailto:gvsig_internacional-bounces at listserv.gva.es] 
> <mailto:[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 www.geoidee.ch <http://www.geoidee.ch>
>
>
>
>
> _______________________________________________
> Gvsig_internacional mailing list
> Gvsig_internacional at listserv.gva.es  <mailto: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
>
>
>
> -- 
> Fran Peñarrubia
> Scolab
> www.scolab.es  <http://www.scolab.es>
>   
> Asociación gvSIG
> www.gvsig.com  <http://www.gvsig.com>

-- 
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/20120514/9866ac7a/attachment.htm