Keyword

insert into k2_items

  • oasisfleeting
  • oasisfleeting's Avatar Topic Author
  • Offline
  • New Member
More
14 years 2 months ago #85486 by oasisfleeting
insert into k2_items was created by oasisfleeting
I'm attempting to insert special chars in a database table that is
charset utf8.
I cam getting the titles from
$markup = file_get_contents('sfbay.craigslist.org/ads/');
Let's say for example this is the title I get from that page and I want
to store it in the database...
_(¯`•★•´¯)_BLONDE_(¯`•★•´¯)_w4m - w4m
When i perform the insert only the first two characters get inserted,
"_(" and then nothing else is inserted into the title colum. I don't
understand why.
I've tried converting the string into utf8, and transliterate the
results, but that only results in php dropping the characters that can't
be transliterated.
$subject = iconv('UTF-8', 'ISO-8859-1//TRANSLIT//IGNORE', $subject);

Any help would be appreciated

Please Log in or Create an account to join the conversation.


Powered by Kunena Forum