Problem with codification when importing from CSV

Classic Servoy
1

I’m making a solution to import the data of the files csv, all works fine, but when the tex have accents or some especial characters don’t import well. Do you know any orm to make the text encoding correct?

2

The following post shows a way to enforce the encoding (in my case UTF8):
viewtopic.php?f=3&t=6485#p94604

Hope this helps

3

Thanks for the info, but i find the way with the plugin file to speify the enconding of the file.

With this instruction

var file = plugins.file.readTXTFile(target, "iso-8859-1");
4

(ack! I edited your post instead of replying [it’s back to the original though], dangerous business being a moderator. Here is the actual reply)

That works too. :)
But do realize that the plugin loads the whole file in memory.
The code I referenced only reads one line at a time so that is preferred for larger imports.