When I insert word "тест" it looks like "С‚РµСЃС‚" in DB.What tool did you use to look at that word?
Looks like you have a presentation problem. Version of SQL Developer used?I use v3.1.07 but actually there isn't problem with the SQL developer tool because when I use it for seeing, inserting/updating the data it works correctly. There is a problem when I try to insert or update (select ok) from a php script. I update a table from php script (which is utf8 encoded) using PDO ODBC driver but it saves the data in windows 1251. If I encode the php script to windows 1251 than it saves it in utf8. Is it possible that ODBC driver converts the charset while inserting or updating method?
923110 wrote:I'm lost. I'll try a different way of getting clarification:What tool did you use to look at that word?SQL developer last version. Also by selecting this inserted word from DB in php script and outputting it in a browser (the page is set to utf8 charset).
... "тест" it looks like "С‚РµСЃС‚"Where, exactly?
Where, exactly?Connections -> MyConnection -> Other users -> MyUser -> Tables -> MyTable -> Data Tab
Is the browser's detection of encoding working?Yes
there is only problem with new inserted/updated data from the php script.Ok this is new info, and probably closer to the problem.