bruce wrote:
> 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?
>

You're the one asking for help.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================