Hello,
I'm creating a database on my LOCAL machine I'm having issues when
trying to enter characters like: á é í ó ú ñ

When i enter this manually in the console, the characters appear OK:
INSERT INTO album VALUES(NULL, 'Olé', '1993-01-01');

But when i enter the same values using a data file (in the console, I
type source c:/disco.data). i get a weird looking character. Here's
how the data file looks like:

DROP DATABASE if exists discography;
CREATE DATABASE discography;
USE discography;

CREATE TABLE album(
albumID TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
albumName CHAR(75) NOT NULL,
albumReleaseDate DATE NOT NULL,
PRIMARY KEY(albumID)
) TYPE= MyISAM;

INSERT INTO album VALUES(NULL, 'Olé', '1993-01-01');

How come the data file can't interpet the character corectly but when
i enter it manually it can?

I've tried doing the same thing, but in my godaddy server account (not
in my local machine). I've use the data file and, at my surprise, it
works ok and can see the characters correctly.

I've com to the conclusion that maybe the issue is my sql
configuration and not the way i construct the database with the data
file. But, what could it be?

I need you help coz' i have no idea what to look for and what to
configure.

Thanks
SM