I'm getting this problem with the info sent to MySQL database. Every special character is not correctly shown. If I put "Pós-Graduação", the info stored in DB is "Pós-Graduação".
How can I correct this?
Thanks!
Krebs
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have created the database, and the instal.php has created the table. Actually I don't know how the character type are different.
Could you give some clue to solve this problem?
When I enter MyphpAdmin, I can see an option about characters.
MySQL charset: UTF-8 Unicode (utf8)
MySQL connection collation: utf8_unicode_ci
The table created show the latin1_swedish_ci charset for each field and for the whole table (seems that those are different configuration). So bellow I have the chance to change the charset (collation) for all the table. It's default configuration is latin1_swedish_ci.
It's something abou this configuration? The form uses what type o charset?
I'm on the right way? Some clue will be very handy
Thankyou very much.
Krebs
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
You are on the right track. Unfortunately I am not experienced enough in alternate character sets to be able to explain exactly what to do. I would have to experiment with it myself in order to get it working.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
It really could be a problem with those configs. Is this problem happening only with me?
An important info is that I'm running a phpBB forum on the same server. Why my forum doesn't have tihs problem and the form does? I was thinking that some fixes on the generator could solve this problem. Maybe on the instal.php, I don't really know.
It doesn't make sense to get the problem solved for me and it still be there to other users.
Regards,
Krebs
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Well. Until today I'm experiencing these problems with special characters.
I concluded that the problem is in the communication between the form page to the database.
The same problem remains. When I wrote "João" in the form, it writes on the DB "João". Note that the problem isn't in the DB, cause when I manually edit the value to "João", it is correctly stored on DB, "João". If the DB were not compatible with special characters, this test would not work.
At phpMyAdmin, every collation values are default seted to UTF8_bin
I really appreciate if someone could give some light over my problem. I'm using this software just because I don't know how to work with those things. I guess I'm smart enough to understand the solutions.
I need to have this form working very much.
Thanks very much for any answer.
Krebs
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
People.
I'm getting this problem with the info sent to MySQL database. Every special character is not correctly shown. If I put "Pós-Graduação", the info stored in DB is "Pós-Graduação".
How can I correct this?
Thanks!
Krebs
Special characters is MySQL needs to be managed carefully. All aspects of the form and SQL data storage must adhere to the same character type.
Hi, tnteveret1.
Thankyou for answer.
I have created the database, and the instal.php has created the table. Actually I don't know how the character type are different.
Could you give some clue to solve this problem?
When I enter MyphpAdmin, I can see an option about characters.
MySQL charset: UTF-8 Unicode (utf8)
MySQL connection collation: utf8_unicode_ci
The table created show the latin1_swedish_ci charset for each field and for the whole table (seems that those are different configuration). So bellow I have the chance to change the charset (collation) for all the table. It's default configuration is latin1_swedish_ci.
It's something abou this configuration? The form uses what type o charset?
I'm on the right way? Some clue will be very handy
Thankyou very much.
Krebs
You are on the right track. Unfortunately I am not experienced enough in alternate character sets to be able to explain exactly what to do. I would have to experiment with it myself in order to get it working.
Hi, tnteveret.
It really could be a problem with those configs. Is this problem happening only with me?
An important info is that I'm running a phpBB forum on the same server. Why my forum doesn't have tihs problem and the form does? I was thinking that some fixes on the generator could solve this problem. Maybe on the instal.php, I don't really know.
It doesn't make sense to get the problem solved for me and it still be there to other users.
Regards,
Krebs
Well. Until today I'm experiencing these problems with special characters.
I concluded that the problem is in the communication between the form page to the database.
The same problem remains. When I wrote "João" in the form, it writes on the DB "João". Note that the problem isn't in the DB, cause when I manually edit the value to "João", it is correctly stored on DB, "João". If the DB were not compatible with special characters, this test would not work.
At phpMyAdmin, every collation values are default seted to UTF8_bin
I really appreciate if someone could give some light over my problem. I'm using this software just because I don't know how to work with those things. I guess I'm smart enough to understand the solutions.
I need to have this form working very much.
Thanks very much for any answer.
Krebs