| Question: |
Good day, please Help to understand why my characters only to place a large letter ? in the place of a small letter and no characters. Here is saskana: http://epiks.ru/catalog/file/1.jpg |
| Answer: |
Hello. Provide a link where you can see the problem. |
| Question: |
http://epiks.ru/loads/material/id/50или тутhttp://epiks.EN/ |
| Answer: |
How to create a page through the admin panel or CMS on the local computer, and then downloaded to the server? |
| Question: |
On the computer via Notepad, then upload via FTP to the server. UTF 8 without BOM |
| Answer: |
try this http://www.levik.info/mysql-utf8-charset-names-i-sh.htm |
| Question: |
I do not understand what to change and where? Tell me how full the kettle: what and where to prescribe? |
| Answer: |
the website You were transferred or built from scratch? |
| Question: |
I wrote this on the COH main page: $Query = mysqli_query($Connect, `UPDATE `text` SET `load` = REPLACE(`load`,CONCAT( CHAR(209), CHAR(63) ),CONCAT( CHAR(209), CHAR(136) ));$Query = mysqli_query($Connect, `UPDATE `text` SET `load` = REPLACE(`load`,CONCAT( CHAR(208), CHAR(63) ),CONCAT( CHAR(208), CHAR(152) ));but the site is best not to pokerboat - Error |
| Question: |
from scratch wrote |
| Answer: |
I mean from scratch? it is Your development? try the solution with SET NAMES ` utf8′ |
| Question: |
Write the code which I have to write to the SQL table from phpmyadmin ? |
| Question: |
I studied the videos. try solution with SET NAMES ‘utf8′how to do it? I can definitely write my code? |
| Answer: |
this is code insert it after connecting to the database after connecting to the database, specify mysql_query(\"SET NAMES` utf8′\"); in the script where you connect to database |
| Answer: |
as you select the encoding when filling? where exactly are those data which are displayed nekorektno? on the website or in the database? |
| Question: |
on the website, I get links to written and even screen with the website to create one |
| Question: |
update the website look at glhanoi page epiks.ru |
| Answer: |
where did they come from? in the page code or database? if from a database then which database and which table? how to complete таблица7 what encoding you used when filling? |
| Question: |
in file of podkluchenie to the database written like this:
|
| Question: |
the data from the database table:$Row = mysqli_fetch_assoc(mysqli_query($CONNECT, `SELECT `name`, `added`, `date`, `read`, `text`, `active`, `download`, `dimg`, `link`, `zero` FROM `load` WHERE `id` = `.$Param[`id`])); |
| Answer: |
originally filled with data? |
| Answer: |
You database is in utf8 and the data in it in 1251 open the table in phpmyadmin and use the decoder http://www.artlebedev.ru/tools/decoder You will see that data is filled correctly |
| Question: |
If understand correctly, I wrote this code:mysqli_query($Connect, \"UPDATE `load` SET `utf8`\");put it in page podkluchenie to the database and the page with materialom but ieroglify not disappeared |
| Question: |
and how do I fix this? |
| Question: |
I shows the table data Collation utf8_general_ci |
| Answer: |
Try to add the entry now. |
| Question: |
I do not understand how the data I decode to utf8 and why they are there in 1251? here are all Dunn in tablizer§S PS R±With\" RSS S R±WITH\"RIC€SS RRR€RS, RSR¶RR SR°R·Rrarr°S SSS Re SS R°RRR SSS R\"SS‡€RR, RRR° RR RRR S R°R SS RRR¶We°RS` PEP·RSS RS\"R # R±R\"RRR, R±RRR±PEP\"Rrarr SRRs Srrr, R\"R RRR Restr. RR SS RRR¶We°RS` S‡S PS RR°RR RRR\"SRES S Srrr No. SRS†PEP°R\"SRS\"R # SS R°S Cs, S PS RSS S RSS S\"RERR°SRS\"R # SSR, Rers RR\"R\"RRS SR°R\"SRS\"R # Re With\"PEP·RES‡Rser no. RRR\"SRR |
| Question: |
on the website prezhdnemu error, do you have Skype or Thai? I don`t understand what you obesnite me, I asked how full the kettle obiasnite, and you just like professional say the 2 words I don`t understand you |
| Answer: |
the problem is not solved in 2 words . add an entry now and see how it is displayed |
| Question: |
added all pridesa, Skype or Thai? will be more productive, my Skype: viorel4321 or Thai 556034883 |
| Answer: |
of Those.support is available only on tickets.
as You add and where you see this? |
| Question: |
in the decoder the entry from the database written R? R?\"RIR°S\"R°pressed decoder to Decode CP1251 → UTF-8 and I wrote �? �?Avaya |
| Question: |
my website http://epiks.ru/ right on the main page, the first news. Add news a user have only me as admin and we need odobriti and all |
| Answer: |
You cann`t provide the database dump to import? |
| Question: |
don`t understand the question, you prosite FTP username and passwords? |
| Question: |
awww |
| Answer: |
No. Database you imported or was filled? |
| Question: |
filled through the site, and the site codes can connect to the database and import records via the website itself. I told every user of site can add news |
| Question: |
what would I do?) |
| Answer: |
you need to recreate the database and again to fill it. on the server, hundreds of sites use UTF-8 encoding |
| Question: |
how do I create a database in utf8 ? I wrote the code mysqli_query($Connect, \"UPDATE `load` SET `utf8`\"); added news but on the website prezhdnemu ieroglify. Maybe the problem is file .htaccess :it is written:RewriteEngine onRewriteBase /Options All-IndexesRewriteCond %{REQUEST_FILENAME} -s [OR]RewriteCond %{REQUEST_FILENAME} -l [OR]RewriteCond %{REQUEST_FILENAME} -dRewriteRule ^resource/(.*)$ resource/$1 [L]RewriteRule ^catalog/(.*)$ catalog/$1 [L]RewriteRule ^.*$ [NC,L]RewriteRule ^.*$ index.php [NC,L]How do I fix the site? What is the error? Will recreate the database but this is where the utf8 encoding to write? I have the whole website written using Notepad utf WITHOUT BOM! I don`t understand what you do not correctly create one? How is it that the base recorded in 1251 ? |
| Question: |
HOW! ????? |
| Answer: |
no, the problem is the data in your database and display them in Your script. try to clear the database and fill it again. |
| Answer: |
Try to recreate the database and then in phpMyAdmin proposte encoding and try to fill it. Specify the path to the script that fills the database. |
| Question: |
as for phpMyAdmin to register the encoding? You said: Check the path to the script that fills the database. I mean? I mean? |
| Question: |
In column Operations Section Collation base danys ( this is where nastroitj all the bases) I have written utf8_general_ci , I deleted the entire database! Now :as for phpMyAdmin to register the encoding? You said: Check the path to the script that fills the database.I mean? I mean? |
| Question: |
The base encoding UTF8 ! WHY DO YOU HAVE THE KANJI LETTER AND LARGE? |
| Answer: |
what page are added comments? You deleted the database? You still in the database records are stored in the form: R–PµR"PµR·RSS‹R # RSE |
| Question: |
I DELETED the ENTIRE DATABASE CHANGED the CODING and uploaded the table vseravno ieroglify! the comments loaded to the page the comments, And here comentari?? |
| Answer: |
which table and where You downloaded? |
| Question: |
backup created previously |
| Answer: |
so You get loaded again tainted data. |
| Question: |
Why is the data corrupt? Encoding all fail УТФ8 ! |
| Question: |
Here I will write the whole site again, spend Ishe 2 months and what is the difference between this table and that will create a new? |
| Answer: |
the problem You have in coding. you download already tainted data. try to make changes again without loading your dump |
| Question: |
with the hand wrote with the coding УТФ8 ! |
| Answer: |
most likely that`s the problem. to fill the need. |
| Question: |
How can they be corrupted if all fail this script! and the news that are added are written to the database using Add news to the site! |
| Answer: |
You have a database record in wrong encoding originally |
| Question: |
Cleaned all the tables, Chat, news, a registered user have, comments, all tables cleared, zaregistrirovali over to the site added a news and that you think shows? HIEROGLYPHS! |
| Answer: |
base initially as it was filled? |
| Question: |
the name of the tables and columns of tables with the parameters via phpmyadmin but the tables are filled via the website: first of registrary then add news |
| Answer: |
Give a link to the page where you fill. |
| Answer: |
then You need to check the encoding in which Your website sends the data |
| Question: |
http://epiks.ru/loads/add then I fill. I have you the link of my ` 4th races write! you bastard 1 races go and it is easier to ask the link 4 times? what Brady are you talking about? what does the page fill? Tama still using the model all done! Well, it can send data to 1251 if Notepad in UTF form and sending the data only for upravou data, where the encoding is not written when sending data! FUCK YOU TH SO STUPID I`M WITH YOU ALREADY ; WRITTEN HOURS AND YOU ASK A STUPID QUESTION, BITCH |
| Answer: |
please do not speak. |
| Question: |
Or fix your glitch with the letter and Or I go to another host! |
| Answer: |
we Have a glitch. a glitch with Your script. the server runs several hundred sites and anywhere similar is not a problem. Your script we can fix it for You can`t. |
| Answer: |
http://epiks.ru/loads/material/id/52 Check - text are populated correctly. |
| Question: |
�? AI and here`s another : is This correct? |
| Answer: |
you use two connection to the database: In the file /home/doinita/public_html/index.php $CONNECT = mysqli_connect(HOST, USER, PASS, DB); I added a rule for it: mysqli_query($CONNECT, \"SET NAMES `utf8`;\"); the file /home/doinita/public_html/page/index.php you also have a connection to the database but under a different variable $Connect Register in PHP has a difference. $Connect = mysqli_connect(HOST, USER, PASS, DB); I added a rule for it: mysqli_query($Connect , \"SET NAMES `utf8`;\"); Your problem is described on the forums: http://www.levik.info/mysql-utf8-charset-names-i-sh.htm you instead of module mysql mysqli just Needed to specify the desired module: mysqli_query(); |
| Answer: |
please Check now. |
| Question: |
Yes, it works great, thanks |
| Answer: |
Thank you, that appealed to customer support. |
