• support[@]kurinchilion.com
  • +1 (888) 666-4252

Tags

MySQL garbled data due to UTF-8 double encoding

Mar 18, 2019 - by kurinchilamp / MySql / Post Comment
For example, you may have table with varchar, text or longtext fields and you may see garbled data in it. Though the text appears correctly on web pages, inside MySQL junk characters may appear. CREATE TABLE `my_news` ( `nid` bigint(10) NOT NULL DEFAULT '0', `title` text, `short_news` longtext) ENGINE=MyISAM DEFAULT CHARSET=utf8; In order to correct this error, try to alter the table in the following sequence. (more…)
Continue Reading

Strange character sequence when parsing XML

Jun 07, 2009 - by kurinchilamp / / Post Comment
When XML files are read from RSS feeds or from other sources, it is necessary that they both use the same standard encoding. When there is a conflict, strange characters like ‘, ’ gets shown on the browsers. In RSS feeds, UTF-8 is the standard encoding scheme that is used and if a browser using ISO-8859-1 tries to read and display the data from the feed then these characters get passed on to the display. To avoid having this strange characters displyed on screen (where ISO-8859-1 encoding is used), PHP's iconv function comes in handy and you can use it like echo iconv("UTF-8","ISO-8859-1//TRANSLIT", $temp_item['encoded']); and this will remove those characters and replace it with the nearest possible character during its tranliteration.
Continue Reading

TECHNOLOGY DEV STACK

Following are some of the technologies that we use to build and maintain solutions for our clients.