|
|
Rank: Newbie
Groups: Member
Joined: 9/17/2007
Posts: 4
Points: 0
|
Hi,
I've a problem importing a SQL file using the "open" button.
When I upload my sql file the system substitute the "à","è" and other letters with
Kak"�"(M)
Example:
In my sql text file I have: Kakà
In the mysql admin after importing the text file I have: Kak�
If I select all the text copy and paste everything is right.
Any suggest?
Thanks a lot for your help!
|
|
Rank: Administration
Groups: Administration
Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
|
Check that your CSV file is saved in UTF-8 and not in Unicode.
|
|
Rank: Newbie
Groups: Member
Joined: 9/17/2007
Posts: 4
Points: 0
|
Hi,
thanks for your answer...
But my file is autogenerated in this way by a external procedure..
There's a way to force UTF-8 during upload?
|
|
Rank: Administration
Groups: Administration
Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
|
the file must be saved in UTF-8 before the upload.
Could you please check that it works as you want with an UTF-8 file?
|
|
Rank: Newbie
Groups: Member
Joined: 9/17/2007
Posts: 4
Points: 0
|
Yes! It works!
But there's a way to do this automatically during upload?
|
|
Rank: Administration
Groups: Administration
Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
|
Upload process does not care about the file format (ansi, utf8, unicode, binary, etc.) The only way is to upload the file in the correct format.
You should add a process between your external procedure and the csv import that would convert your file into utf-8 format.
|
|
Rank: Newbie
Groups: Member
Joined: 9/17/2007
Posts: 4
Points: 0
|
Ok.
Thank You very much for your help!
Bye
|
|
|
Guest |