gtbikerider
Technical User
I'm trying to store foreign characters in mySQL 4.1 and ColdFusion.
Until recently I used Access. The user entered "ö" into a form and "ö" got stored in the database.
Now I'm trying to move to mySQL 4.1. The user enters say "Malmö" in a form field and "Malm" gets stored in mySQL (in other words, its trunacted).
Elsewhere I use fckeditor (a WYSIWYG editor) and if I enter "Malmö" into that, then "Malmö" gets stored in the mySQL 4.1 database.
I guess what I need to do is convert from "ö" to "ö" when saving and retrieving from mySQL.
Please help!
--
John
Until recently I used Access. The user entered "ö" into a form and "ö" got stored in the database.
Now I'm trying to move to mySQL 4.1. The user enters say "Malmö" in a form field and "Malm" gets stored in mySQL (in other words, its trunacted).
Elsewhere I use fckeditor (a WYSIWYG editor) and if I enter "Malmö" into that, then "Malmö" gets stored in the mySQL 4.1 database.
I guess what I need to do is convert from "ö" to "ö" when saving and retrieving from mySQL.
Please help!
--
John