On 29 Feb, 14:38, bruce <karc...@optonline.net> wrote:
> 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.

"doesn't work" well that's helpful!

"Why does the insert statement fail?" You tell us. All you have said
is "doesn't work"!