开发者

Migrating data from MSSQL to MySQL

开发者 https://www.devze.com 2023-01-10 10:27 出处:网络
I have a few tables in SQL Server Express that contain data w开发者_如何学编程ith high characters - ex: Häagen-Dazs

I have a few tables in SQL Server Express that contain data w开发者_如何学编程ith high characters - ex: Häagen-Dazs

I've exported SQL inserts and when I run in MySQL they fail on these characters. SQL Express doesn't have DTS so I can't do an ODBC transformation.

I've used FileMaker Pro's external table functionality but the characters show up as odd characters. ex: �

Any tips would be most appreciated.


Found a fix

Replacing Smart Quotes in MySQL

0

精彩评论

暂无评论...
验证码 换一张
取 消