How To Use Swedish CharactersFeb 3, 2012
I have a iPhone app called "Mina utgfter" where i put in data about my expenses.
From this app I export a csv file that I import to mysql database.
All is working just fine exept that when I have a swedish character in the csv file it will not be added in to the db and noting after that as well.
Ex: If i stand in csv file "Lönutrdag" only "L" will be added to db.
I know it has to do with utf-8 format but I can not get it to work.
The only solution i found so far is to open the csv file in notepad, take save as and save it as utf-8 format. Then everything works fine. But the problem with this is that I do this import from a webpage with asp and my users will import the file from there, so I want to skipp letting my users re-save the file in notepad.
I have tested to change the charset in db to latin swedins and ut-8 swedish but same problem. I tried to use ADODB.STREAM object in vb and open the csv file and save it with charset utf-8, but this resulted in that all the swedisn characters in the scv file became rubbish. I have no way to change format from the iPhone app, its just an export csv without and format options.
Tried to set the CHARACTER SET charset_name (utf-8) in the sql as well but same problem.
If I run the SQL "Load data in file..." in the code below in mysql directly I get same problem, so its not an asp error,
Here is my
<!--#include virtual="/Connections/connectionHome.asp" -->
I solved the problem my self.
1. Uninstalled mySQL from my server.
2. Installed MSSQL Express.