Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Forum Replies Created

Viewing 1 post (of 1 total)
  • Author
    Posts
  • August 27, 2010 at 8:26 am in reply to: Field Says Binary/image, But It's Not..? #21428
    Al Jey
    Member
    'Ritesh' wrote on '26:

    If you see there is an extra in the data which means an extra NULL character in the data. You will need to strip that out. SQLyog identifies whether a data is BINARY or not by checking for a NULL character till the length sent by MySQL and there is indeed a NULL. I dont know how it came but once you remove it, it will solve the issue.

    Ritesh,

    You rock dude, you just saved my life (and I mean it), TRIM(TRAILING '' FROM columnName) totally did the trick for me; I've been fiddling with the damn thing forever… 😀 😀 😀

  • Author
    Posts
Viewing 1 post (of 1 total)