php - German Umlaute in Mysql/Phpmyadmin -

-

I have a Flex application with UT 8-encoding. I am sending it back to the server (PHP), and the data MySQL (UT8 charset, utf8_general_ci) is written in I have no problem writing / reading all / UMMOT from database

I have only realized the data with the APMMadmin that the ummat has been modified in some way:

ö => ö ü => ü etc.

As I said, I had no problem at all. The odd thing is that when I write the example with the PHPmyAdmin directly in the database, they are displayed correctly

Now I am printing a PDF, and to display me correctly For all values, call ut8_decode (). However, they manually enter DB (which are correctly displayed in phpmyadmin), they are not decoded.

I think they have not been written in DB in DT because they are due to the decoding defects?

  1. ) But why are this strange way for the first time in UT 8-encoded values ​​in DB? 2.) How can I enter data in MySQL with PHPmyAdmin in UTF-encoding? (I have set the connection to ut8.)

Thx, Martin

I struggled with the same problem for a long time. As soon as you are connected to the database, to run this query and your web application will display the letters as they appear in phpmyadmin:

SET NAMES 'utf8'

MySQL set up for some reason is encoded as Latin 1 to capture input and output on my system, which means that when I send it to UF 8 input it stores it incorrectly in the database Is but why Gets Nki is reversed for conversion output, then undo the mess and it is displayed correctly in the browser while (except that using phpmyadmin, which show it to be honest). This is true only when the conversion results in letters that are allowed in the character set used in the database field, so that you can get errors, unless you stop this conversion from the above query.


Comments

Post a Comment

Popular posts from this blog

c++ - Linux and clipboard -

-
After selecting the copies of the buffer in Linux, after the text, we can click and paste the button between the mouse. I think there is a special buffer for this, I want to use it. Programming Language: C ++ Your Library: Qt Thanks. There is just one more correct answer than Paul Dixon, which answers your needs: / P > QClipboard * clipboard = QApplication :: clipboard (); CastString Selected Text = Clipboard-> Text (QClipboard :: Selection);
Read more

What is expire header and how to achive them in ASP.NET and PHP? -

-
I have examined the performance statistics of my website today. I have received a warning (or error may occur) that is given below Add Terminal Headers Here are 15 static components without a 15-futures end date * (no end) Http://www.example.com/video/css/global.css * (no time limit) http://www.example.com/video/js/global.js * (no expiration ) Http: //www.example.com/video/images/main-bg.png what it means and how to achieve it both in PHP and ASP.Net. I am on a shared hosting server, so please tell me some ways to use the code, because I can not make any modifications at the end of the server. If I expire the header, then there is no chance that if I make changes to the CSS, then the user will not be able to remove them immediately because CSS and other files have a fixed time limit (1 month, week ) Are cached for. Is Is there any harm to using PHP? $ time = time () + 3 * 24 * 60 * 60; // 3 day headings ('End:'. GMDAT ('D, D MYH: i: s \ g \ m \ t',
Read more

sql server - How can I determine which of my SQL 2005 statistics are unused? -

-
After a few years, one of my biggest databases has deposited 73 figures out of its largest tables. With Indexes, I can run many types of reports and queries, how often / heavily specific indexes are used. What is an equivalent for data? We are running SQL 2005. To make statistics automatically managed and honest, I would like to "update statistics", "create statistics" and There is no information about any management except "drop statistics" orders. In theory, UPDATE should handle the addition and removal of statistical data. In addition, I've never heard about the amount of storage or storage taking in large amounts, so I'm not sure whether there is any reason for the alarm or not. If you are seeing a potential problem, then I would suggest running an update before, if it does not clean it, it is leaving and then it appears to be safe operation (because it is the only query optimizer Is for). I will not leave "left" in the
Read more