Bug #19230 | mysql restore backup, after turkish characters showing question marks. | ||
---|---|---|---|
Submitted: | 20 Apr 2006 20:38 | Modified: | 3 Jul 2006 15:40 |
Reporter: | orhan sevki | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Server: Command-line Clients | Severity: | S2 (Serious) |
Version: | 4.1.18 | OS: | Windows (windows xp & centos & debian) |
Assigned to: | CPU Architecture: | Any |
[20 Apr 2006 20:38]
orhan sevki
[21 Apr 2006 0:55]
orhan sevki
Today i downloaded latest version mysql 4.1.18, still same problem. Also, when i restore my backup to 4.1.18 server, i'm getting dublicate key error. current backup is restored without problem 4.1.17 server, but not 4.1.18.
[21 Apr 2006 23:21]
orhan sevki
Hello again, I'm post to you our mysql '%char%' and '%colla%' variables, both system variables are same; | character_set_client | latin5 | | character_set_connection | latin5 | | character_set_database | latin5 | | character_set_results | latin5 | | character_set_server | latin5 | | character_set_system | utf8 | | character_sets_dir | /usr/local/share/mysql/charsets/ | | collation_connection | latin5_turkish_ci | | collation_database | latin5_turkish_ci | | collation_server | latin5_turkish_ci we trying to restore backup to centos linux system and still same problem.
[22 Apr 2006 0:44]
orhan sevki
finally, issue solved with PHP5 mysqli extension. I think php4 & mysql4.1.x not compatible with character sets and collations.
[22 Apr 2006 14:07]
Valeriy Kravchuk
So, as problem is solved, can we close this report? As for php4 vs. php5 + mysqli, it is clearly documented (http://php.net/manual/en/ref.mysqli.php): "The mysqli extension allows you to access the functionality provided by MySQL 4.1 and above. More information about the MySQL Database server can be found at http://www.mysql.com/". The problem can be also with mysqlclient library your php4 was linked with.
[24 Apr 2006 23:20]
orhan sevki
Dear Sir, do not close please, because problem still persist with php4 and mysql4.1.18 Also, all turkish peoples having same problem, i can help you fixing this issue, please investigate.
[3 Jun 2006 15:40]
Valeriy Kravchuk
OK, so, it is not PHP-related problem. Please, send the echo $LANG command results from the same shell window you run mysqldump and mysql command line clients. Please, provide the smallest possible but complete test case that shows incorrect behaviour you described. With CREATE DATABASE, CREATE TABLE, INSERT for some data, exact mysqldump and mysql commands used to dump and restore.
[3 Jul 2006 23:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".