Can someone help me on how to save "Ã±" in MySQL database?
I have created a program in vb
.net and the backend i used is MySQL Administrator database which resides in another pc. So the development pc i used act as the client pc. I noticed that everytime I saved data from the client to server pc using the program, the text that contains 'Ã±' was truncated. For e.g. the last name i saved was 'AÃ±overt', after I saved the data to database it becomes 'A'. The character Ã± and the letters following it wasn't saved.
What should I do to solve this problem?
Thanks in advance.