Hey everyone! I have a Filemaker Pro database table that needs to be imported to SQL Server (product data for online store). In order to do this, I tried two approaches.
1.> Export data from FMP in CSV format, then import to SQL Server 2.> Set up ODBC connection to FMP, then import to SQL Server Both are successful - in that they import the data without "errors". The problem is that some columns in the original FMP data contain many "special characters" (Unicode?), such as bullets, carriage returns, TM symbols, etc. Using the first approach, these characters are preserved in the database after completing the import, but are then displayed on pages as either bizarre symbols or the letter "N", depending on the machine accessing the page (see example below). Using the second approach (ODBC), the characters are removed completely during the import. Is there any way that I can preserve/convert the characters for output? It will be a *ton* of work for my client if I use the second approach and they have to manually insert carriage returns, TM's, etc. for thousands of products. Sample HTML output using approach 1 (note the "N's"): Six Feet Underground 2. Big Shot Dead 3. Know What I Mean? 4. Whatâs Wrong With You (featuring Lady Tigra) 5. A Strong Woman 6. Rough Enough 7. Whatâs The Meaning? 8. Gotta Stay Strong 9. Home Of The Brave 10. Playerâs Theme 11. Burn In Hell 12. Break What? 13. Along In The Graveyard 14. Barking Up The Wrong Tree 15. I Understand That Thanks! Mike ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223218 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
