Using accented characterse in CodeIgniter

Asked Mar 30 '20 at 17:56

Active Mar 30 '20 at 17:56

Viewed 136 times

I have a problem with my input texts from forms. When the user enters in a text form input something like "test ăĂșșțîâ" CodeIgniter query saves to the database after getting post input something like "test ???????". I have 2 variants: 1. first is to convert "ăâîșț" and "ĂÂÎȘȚ" TO "aaist" and "AAIST". 2. to find a method to save accented characters in DB without saving like "????"

I'm already using html_purify and strip_tags to input. Does someone have some ideas?

Here is my code to GET input form:

strip_tags(html_purify($this->input->post("postandclose", true)));

asked Mar 30 '20 at 17:56

Welzix Awnie

Your database table should be utf8. Is it? – Muhammad Umair Mar 30 '20 at 17:58
is latin1_swedish_ci – Welzix Awnie Mar 30 '20 at 18:50
Try making that utf8. – Muhammad Umair Mar 30 '20 at 18:50
what is your html charset meta – umefarooq Mar 30 '20 at 19:01
@umefarooq – Welzix Awnie Mar 30 '20 at 19:11
@MuhammadUmair i can't change this in db because it's connected to multiple things and i can cause some problems – Welzix Awnie Mar 30 '20 at 19:12
1

you are sending utf8 format data from HTML to your database, best way to convert your table to utf8 first take backup of table or make copy of your table with data than convert charset of table also charset of table columns too. check here 2nd answer may be solution https://stackoverflow.com/questions/7345264/utf8-to-latin1-swedish-ci – umefarooq Mar 30 '20 at 19:26
1

It's already discussed in stackoverflow, here's another one. https://stackoverflow.com/questions/4854446/save-accents-in-mysql-database – Arun Panneerselvam Mar 30 '20 at 21:38

Using accented characterse in CodeIgniter

0 Answers0