Bug #8672 Server replaces some symbols in query when coding UTF8 is used.
Submitted: 22 Feb 2005 9:33 Modified: 2 Apr 2005 12:42
Reporter: Alex Dzuba Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:1.4.9 OS:Windows (Windows XP SP2)
Assigned to: CPU Architecture:Any

[22 Feb 2005 9:33] Alex Dzuba 
Description:
When I insert utf8 string (see hexadicemal value for each byte) the server replaces some symbols in string.
	[0]	0xd0 'Р'
	[1]	0xa0 ' '
	[2]	0xd0 'Р'
	[3]	0xbe 'ѕ'
	[4]	0xd1 'С'
	[5]	0x81 'Ѓ'          // replaced to '?'
	[6]	0xd1 'С'
	[7]	0x81 'Ѓ'          // replaced to '?'
	[8]	0xd0 'Р'
	[9]	0xb8 'ё'
	[10]	0xd1 'С'
	[11]	0x8f 'Џ'          // replaced to '?'
	[12]	0x00 ''

For insert this string I using mysql_stmt_ functions.
Field type is varchar[255].

My variables:
+---------------------------------+---------------------------------------------------------+
| Variable_name                   | Value                                                   |
+---------------------------------+---------------------------------------------------------+
| back_log                        | 50                                                      |
| basedir                         | C:\Program Files\MySQL\MySQL Server 4.1\                |
| binlog_cache_size               | 32768                                                   |
| bulk_insert_buffer_size         | 8388608                                                 |
| character_set_client            | utf8                                                    |
| character_set_connection        | utf8                                                    |
| character_set_database          | utf8                                                    |
| character_set_results           | utf8                                                    |
| character_set_server            | utf8                                                    |
| character_set_system            | utf8                                                    |
| character_sets_dir              | C:\Program Files\MySQL\MySQL Server 4.1\share\charsets/ |
| collation_connection            | utf8_general_ci                                         |
| collation_database              | utf8_general_ci                                         |
| collation_server                | utf8_general_ci                                         |

How to repeat:
Insert this string into any table with UTF8
[2 Mar 2005 12:42] MySQL Verification Team 
Could you create a small test case that illustrates this problem?
[2 Apr 2005 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".