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

I think I'll go back to getting blood from stones. It is many times
easier than getting information out of you!

Post a sample statement and the full error message!