preserving character encoding before going to mysql db
Posted: Tue Jan 19, 2010 10:41 pm
hi.
i have some data that i capture and send to a MySQL db. It is not uncommon that much of this data will be of foreign characters with accents and other marks. My concern is two fold. Can i just pass this data straight over to the DB or must i wrap it with a method (encode, etities, etc) before adding to the DB. One thing to note...much of the data will be rendered on mobile devices and not in browsers. So currently, based on how i have things i am getting characters that are not converting correctly but rather giving me their unicode equiv (S?bastien insted of Sebastien with an accent) . Any ideas on how to resolve this?
i have some data that i capture and send to a MySQL db. It is not uncommon that much of this data will be of foreign characters with accents and other marks. My concern is two fold. Can i just pass this data straight over to the DB or must i wrap it with a method (encode, etities, etc) before adding to the DB. One thing to note...much of the data will be rendered on mobile devices and not in browsers. So currently, based on how i have things i am getting characters that are not converting correctly but rather giving me their unicode equiv (S?bastien insted of Sebastien with an accent) . Any ideas on how to resolve this?