Re: data in my database appear like (????????)
Posted by: Alexander Barkov
Date: June 19, 2006 11:56PM

alex_alex, I need more information to be able to answer:

1. Please include "SHOW CREATE TABLE" for the relevant table.

2. Run this query:
SELECT hex(your_column) FROM your_table WHERE ... LIMIT 10;

(use a proper WHERE clause to include records having Cyrillic letters,
record with only Latin letters are not interesting)

3. Also, I guess you run "SHOW VARIABLES LIKE 'character_set%'" in MyPHPAdmin.
Please also do the same query in Navicat.

4. And also it's interesting to see your web server headers:

On Unix, you can do this:

wget -s http://yoursite/path/to/page.html

Then open the file in a text editor, cut HTTP headers and paste them here.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.