Which character set do you use with mysql? (MySQL Server has a server character set and a server collation. These can be set at server startup and changed at runtime. Initially, the server character set and collation depend on the options that you use when you start *mysqld*).
I use UTF-8 for MySQL charset, latin1_swedish_ci as collation. I also use the "useUnicode=true&characterEncoding=iso-8859-1" in advanced settings for the connection and åäö works fine for me with this setup. / daniel >Hi! > >I have massive problems with german umlaute as: ä ö ü ß within my project. >I'm using CFMX 701, mySQL and Farcry b232. >When I first load the (already existing and migrated) text within my soeditor, >everything is fine. But when I click "Save" in the >plp step, the umlaute are replaced by ? signs. > >I tried to make a Replace(output.body, "ä", "ä", "all") ... For all >umlaute but, at this point they can't be distinguished and >got all replaced by the first replace statement. > >My hoster is crystal tech. >I also tried to add >useUnicode=true&characterEncoding=ISO-8859-1 >To the advanced database settings (I found this in a blog or so), but this >didn't work... > >Perhaps somebody already got this up! > >Thanks in advance! > >Bye, >Fritz > > >°================================ >| Fritz Dimmel >| Gassnergasse 14 >| 2020 Hollabrunn >| ------------------------------- >| Porzellangasse 44-46/14 >| 1090 Wien >| ------------------------------- >| phone +43-660-6000069 >| mail fritz(at)dimmel(dot)at >| web http://www.dimmel.at >°================================ > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "farcry-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/farcry-dev -~----------~----~----~----~------~----~------~--~---
