Well folks, I'm a bit stuck with retrieving data from a mySQL-datasource which was exported from ms-access via a little nifty utility called MyAccess. The problem is that the text in the db has german special characters. Since I exported the data to mySQL I'm able to retrieve all the data but the special-chars are shown as symbols 'n' stuff. I took textpad and looked into the data-files mySQL generates for the datasource and they do contain the german chars. Any help out there?
Patric PS> Hi Jerry, PS> thanks for your reply. I'll make sure to have a close look at the PS> db-structure before converting. PS> Patric JJ>> I've done this on 5 projects, now. JJ>> The three things that bit me repeatedly: JJ>> Boolean types in Access were not the same in mySQL. Went with int (1/0). JJ>> Filenames are case sensative all of a sudden. We thought we had followed good naming conventions. We had, but not perfectly! Most significant were image files and rollovers. JJ>> Moving the dbs was interesting, making sure the dbs were ported in the correct order. (constraints forced the proper sequence) JJ>> But it really wasn't very difficult. JJ>> Jerry Johnson >>>>> [EMAIL PROTECTED] 05/21/02 08:33AM >>> JJ>> Hi fellows, JJ>> i looking for some advice on migrating websites of one of my customers JJ>> from windows to linux. The customers has it's own CF4.5Pro-Server and JJ>> 'cause he switched his entire office to linux he's also chenging the JJ>> webserver to linux with apache. The nice thing is, that is will JJ>> purchase/update to CF5 or MX. Now my question is will the applications JJ>> i wrote under Windows+Access run under Linux+MySQL without bigger JJ>> problems??? i have a event-calendar-app which will probably make no JJ>> trouble. but i have a little shopping-cart-like app with session-vars JJ>> and a full-text-search with verity. JJ>> So if anyone can share experience i would be really glad for any JJ>> input! JJ>> TIA -- Patric Stumpe mailto:[EMAIL PROTECTED] ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
