<HTML><HEAD>
<META content="text/html; charset=utf-8" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18928"></HEAD>
<BODY style="MARGIN: 4px 4px 1px; FONT: 10pt Tahoma">
<DIV>If you work from an MS-Access database, you can use the eVis-plugin to draw the table as points. </DIV>
<DIV> </DIV>
<DIV>Have a look at</DIV>
<DIV><A href="http://biodiversityinformatics.amnh.org/open_source/evis/documentation.php#d0e715">http://biodiversityinformatics.amnh.org/open_source/evis/documentation.php#d0e715</A><BR></DIV>
<DIV>I don't know if this solve your problem with characters ...</DIV>
<DIV>But so you don't have to export your data to another file.</DIV>
<DIV> </DIV>
<DIV>Regards,</DIV>
<DIV>Asmus Harder</DIV>
<DIV><BR>2011/10/25 Koos Hagg <<A href="mailto:hagg.koos@gmail.com">hagg.koos@gmail.com</A>>:<BR>> Hi Everyone,<BR>><BR>> Is there a way to force the Delimited text plugin to read/process UTF8<BR>> encoded .csv's?<BR>><BR>> I am working with Vietnamese characters, which display fine encoded UTF8.<BR>> Working from an access database, I export my queries/tables/whatever and<BR>> save them as a csv, in UTF8 with OpenOffice. That works fine. If I then open<BR>> my csv with notepad++ or similar, the characters are preserved- great! But<BR>> when I bring the file in with the Delimited text plugin, the characters are<BR>> messed up. Why is this? how can I fix it?<BR>><BR>> Alternatively:<BR>> I can save the tables I want as dbf, which actually load nicely into QGIS as<BR>> a table, no problems with characters. My tables have Lat & Long columns.<BR>><BR>> How can I tell QGIS to draw points/create a spatial layer based on those 2<BR>> columns? Is there a plugin for that that I have missed?<BR>><BR>> Right now my work-around is to load both a csv and a dbf, and then join the<BR>> dbf to the csv points layer, and save as shapefile, deleting the fields that<BR>> are no good. It works but it is a little cumbersome.<BR>><BR>> Thanks!<BR>> Koos Hagg<BR>><BR>> Oh, using QGIS 1.8+ on Windows 7 (64 bit)<BR></DIV><BR>
<div>
<font color="#009999" size="6" face="Arial"><b>LEHMANN</b></font><b><font color="#99cc00" size="7" face="Arial">
+</font></b><font size="1" face="Arial"><br></font><font color="#009999" size="5" face="Arial"><b>
PARTNER</b></font><font size="1" face="Arial"><br></font><font color="#99cc00" size="1" face="Arial"><b>
───────────────────────── </b></font><font size="1" face="Arial"><br></font><font color="#009999" size="2" face="Arial"><b>
DIE STRASSENGUTACHTER</b></font><b><font color="#009999" size="1" face="Arial">
</font></b><font color="#000000" size="1" face="Arial"><br><br>LEHMANN
+ PARTNER GmbH, Schwerborner Straße 1, D-99086 Erfurt<br>Telefon:
+49 (0) 361 51804 300 Fax: +49 (0) 361 51804 399</font><font size="1" face="Arial"><br>
E-Mail: info@lehmann-partner.de Internet: http://www.die-strassengutachter.de<br>
Geschäftsführer: Dr. Dirk Ebersbach, Jens Morawietz<br>Amtsgericht:
Jena HRB 100220 USt-IdNr.: DE 160 115 425<br></font>
</div>
</BODY></HTML>