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.