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

Instead of getting blood from one, why don't you just crawl back under
it?