strange character in MySQL table
Posted: Fri Aug 05, 2011 2:14 pm
I have a table called adult_student that basically references the relation between an adult and a student in this application I'm writing for my kids HS band.
I populated the table with data I massaged in an excel spreadsheet that was saved as a .csv. When I do a in MySQL workbench I see father, mother, etc. with a little rectangle at the end. I can't even paste into this topic. All it does is return down to the next line. I can paste it into notepad so I'm going to attach a file with the strange character. Is this some bug with workbench or did I enter the data in incorrectly?
edit: well I was going to attach the file but this board doesn't allow .txt or .doc. I'm not sure how to show the artifact. When I open it in word or wordpad it just shows an extra line under father. Is it a carriage return?
Code: Select all
mysql> describe adult_student;
+------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| adult_ID | int(11) | NO | PRI | NULL | |
| student_ID | int(11) | NO | PRI | NULL | |
| relation | varchar(45) | YES | | NULL | |
+------------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
mysql>Code: Select all
SELECT * FROM adult_student;edit: well I was going to attach the file but this board doesn't allow .txt or .doc. I'm not sure how to show the artifact. When I open it in word or wordpad it just shows an extra line under father. Is it a carriage return?