MySQL Bugs: #24493: I tried to import sql file that contains romanian characters

Bug #24493	I tried to import sql file that contains romanian characters
Submitted:	22 Nov 2006 0:04	Modified:	23 Nov 2006 7:44
Reporter:	Sebastian Betea	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	5.0.24a	OS:	Linux (Ubuntu-Debian)
Assigned to:		CPU Architecture:	Any

Description:
Warning: mb_strpos() [function.mb-strpos]: Unknown encoding or conversion error. in /usr/share/phpmyadmin/libraries/string.lib.php on line 112

Warning: mb_strpos() [function.mb-strpos]: Unknown encoding or conversion error. in /usr/share/phpmyadmin/libraries/string.lib.php on line 112

Warning: mb_strpos() [function.mb-strpos]: Unknown encoding or conversion error. in /usr/share/phpmyadmin/libraries/string.lib.php on line 112
Error
There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below:

How to repeat:
import a sql file with romanian characters

Suggested fix:
include romanian coverter or encoder

----BEGIN CUT---- to ----END CUT----

Attachment: mysql_error.txt (text/plain), 22.05 KiB.

Thank you for the report.

Please try with current 5.0.27 version available at http://dev.mysql.com/downloads/mysql/5.0.html and if you can repeat it provide your sql file with romanian characters.

I was able to successfully import the sql file but instead of displaying Romanian characters is displays "?". I would more than happy to supply the sql file but it is about 4MB in size. I will try to cut it down. Funny thing is that i'm able to import the sql file with no problems in Windows using the same version MySQL.

It is not MySQL bug. Please check this manual page: http://dev.mysql.com/doc/refman/5.0/en/charset-mysql.html and your phpMyAdmin settings.