On Fri, 29 Feb 2008 06:38:56 -0800 (PST), bruce 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.

As a differnt question, why reinvent the wheel? There are several
conversion tools listed about half-way down on

http://dev.mysql.com/tech-resources/...microsoft.html

which may save you time and hassle. The rest of the page is a worthwhile
reaqd as well, since it will probably answer the next dozen or so
questions you'll have about how things work differently.

--
People who are willing to rely on the government to keep them safe are
pretty much standing on Darwin's mat, pounding on the door, screaming,
'Take me, take me!'
-- Carl Jacobs in the Monastery