Yes! I've issolate the problem!

[Jack K.]

Hi,

Yes. I'm getting questions marks.
Yes, I've found the problem:

SHOW VARIABLES LIKE 'character_set%':

| Variable_name | Value |
+--------------------------+-------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |

With this in place, everything works just great!

HOWEVER:

on my hosting service (which I can't touch its' configuration), the case is a little different:

| Variable_name | Value |
+--------------------------+-------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |

I have proved that character_set_server is the single issue that causes question marks (proved that by changing my local server's variable and getting the same effect)

- MySQL server version 5.0.41
- 5.0.7 .NET connector

I've tried to use the following instructions in attempt to resolve this problem:

"set character_set_database = utf8",
"set character_set_server = utf8",
"set collation_database = utf8_general_ci",
"set collation_server = utf8_general_ci",
"set session character_set_server=utf8"
"set session collation_server=utf8_general_ci"
"set names utf8"

but executing them did not change the result - question marks.

Any assistance or discussion would be greatly appreciated.



Edited 2 time(s). Last edit at 07/18/2007 05:02AM by Jack K..