MySql newbie, sorry if the question is elementary. I'm trying to
convert sql server database to MySql. Wrote a simple program to read
the MS SQL Server tables, and write to corresponding MySql tables.
Everything is going fine with one exception: the Insert statement
to write to the MySql table doesn't work when I encounter an Ascii
146.
Don't know much about character sets, but when creating the table,
I used the default character set, which is Latin1, I believe. I
thought that would handle non-Ascii characters.
Why does the insert statement fail? Thanks for any help given.