On Feb 29, 10:05 am, Captain Paralytic <paul_laut...@yahoo.com> wrote:
> 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"!

I get the old "invalid syntax in sql statement", and it gives the
piece of the sql statement immediately after the Ascii 146. I'm
guessing that the SQL parser for MySql thinks the Ascii 146 is a quote
mark, since it looks like one, and that is causing the failure, but
thought someone could shed more light for me. Apparently MS SQL
Server is does not have the problem.