Timeline for MySQL Character set and Collation Issue.?
Current License: CC BY-SA 3.0
10 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Apr 27, 2012 at 4:57 | vote | accept | Abdul Manaf | ||
Apr 25, 2012 at 10:16 | answer | added | Craig Efrein | timeline score: 1 | |
Apr 24, 2012 at 14:30 | comment | added | Matt Fenwick | I assume you're running these queries from the terminal. It may be possible that the data and the database are fine, but your terminal isn't reading and displaying the characters properly. | |
Apr 24, 2012 at 8:54 | comment | added | Abdul Manaf | @golimar: there are no differences. | |
Apr 24, 2012 at 8:43 | comment | added | golimar | check both tables in the "information_schema.tables" table or with "show create table xxx" and see the differences between both tables | |
Apr 24, 2012 at 7:13 | history | edited | Abdul Manaf | CC BY-SA 3.0 |
deleted 3 characters in body
|
Apr 24, 2012 at 7:13 | comment | added | Abdul Manaf | that is same i just edited the column name for some purpose but forgot to edit here. | |
Apr 24, 2012 at 6:52 | comment | added | gbn | Your query shows "TSCStartDate" but the metadata shows "StartDate". Is this the problem? | |
Apr 24, 2012 at 5:10 | history | edited | Abdul Manaf | CC BY-SA 3.0 |
added 134 characters in body
|
Apr 24, 2012 at 5:05 | history | asked | Abdul Manaf | CC BY-SA 3.0 |