Perl DBI/Mysql Unicode Bug -

-

I'm not sure whether this is a bug or I'm doing something wrong:

I've read the data Copy 

  open my $ FH, "& lt ;: encoding (ISO-Latin1)", $ file or dead "$ file failed to open: $!";

The $ file is definitely in the ISO latin1.

So I check the mysql table 

  engine = InnoDB AUTO_INCREMENT is = 53072 default charset = latin1

I connection settings : 

  $ dbh- & gt; ("Show variables");

What does 

  character_set_client, latin1 character_set_connection, latin1 character_set_database, latin1 character_set_filesystem, binary character_set_results, latin1 character_set_server, latin1 character_set_system, UTF8  < /   
  •  The data iso-latin 1 (now the pearl must be internal letter format) 
    •  
  •  / li> 
  •  Connection information is correct settings 
    •  
  •  STDOUT (output terminal Iso- is Latinl) straight 
    •   
     but the data in the table is plain UTF8 (possibly internal format in the case of Pearl). 
     
     Do I miss something this is probably a bug in DBI / DBD :: MySQL?

    My guess would be that you are right and this data is in the internal character of Pearl. The sequence goes like this.

    • The data stored in the input file as Latin-1 bytes
    • The encoding options input file and automatically convert Pearl characters your open statement
    • the data referred to as the Pearl characters to MySQL
    • MySQL getting a bit rather than UTF8 confused with Latin-1, but also the best way it Store it

    Before sending your unavailable stage to the database, you need to type the Pearl characters. It's encoding back into the Latin 1. Be clear solution in the encode ( "ISO -885 901, is $ string) on every value to call it would be nice if someone types into the self-encode options. But I can not find anyone.

    Of course, if your data is going to be Latin-1, then you can only consider ignoring any decoding / encoding problems. All this should work without that complexity.


    Comments

    Post a Comment

    Popular posts from this blog

    winforms - C# Form - Property Change -

    -
    I have a form that has a property named car A class with many properties. The Properties is being displayed on the current car on the basis of some user actions that are being displayed. So I have to know whether the property has been allocated or set to zero. I'm aware of INotifyPropertyChanged , but in my case I'm not sure that since this change I have changed my car properties car do not want to monitor the property. Any idea how to accomplish this? In advance thank you If you have created a true asset in your class then You should be a great and setter, you can add the code directly to the form property in order to take action on the basis of "form": Public partial category Form 1: form {public form 1 () {InitializeComponent (); } // define car square public class car {public string name = string. Empty; } // private car to keep the value of the current car private variable _car = null; // Property of public form which you can ru...
    Read more

    c# - NewtonSoft JArray - how to select multiple elements with LINQ -

    -
    Image
    I have some Jason which I then parsed the Jerry object. I want to filter Jerere so that he has only two properties, title and bodytext. But whatever I try I can only select a value using LINQ [HttpGet] Public JsonResult AjaxGetNewsItems () {string json = JsonConvert.SerializeObject (news.GetNewsItems (), Formatting: formatting.Indented); Var v = Jairo Purse (jason); // arrow item = // v.Where (// X =>.! // X ["title"] ToString () = string.Empty & amp; //X ["BodyText"] ToString ()! = String.Empty) // Select (x = & gt; x ["title"]) // .toList (); Var title = (string) v [0] ["title"]; Var titleBodytext = v selectively v [0] ["title"] ["bodytext"]; Foreach (item in titleBodytext) {} // Title: Biodtext = // v [0] ["title"] ["BodyText"] by c // // Group c // new selection from c in gram // {}; // JArray a = JArray.FromObject (news.GetNewsItems ()); // string titlebodietext = (string) news item [...
    Read more

    javascript - amcharts makechart not working -

    -
    I am trying to create an amiratars serial chart on my Durandal single page application. This chart was working fine on Chrome browser but it is not working on IE. Can you please help me in this regard. Error while using Amcharts. The Macchart () method does not support the object in this object in IE.
    Read more