2. PHPRunner General questions
  3. [SOLVED]  Rich Text Field RTE data problem SQL Server
This topic is locked
[SOLVED]

 Rich Text Field RTE data problem SQL Server

 		5/7/2014 7:20:48 AM
PHPRunner General questions
M
 mattd1 author

Worked on a very small application at home on PC, SQL Server Express 2008, ODBC. Implemented in the office and with a few tweaks managed to get it working. Sort of.
Differences:

  1. MS SQL Server Enterprise in office.
  2. Microsoft IIS running PHP Apache plug in in office, rather than Apache at home.
  3. Possible (need to check but can't just now) PHP version difference.
    Built with PHPRunner 6.1 (I know, miles out of date <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=22255&image=1&table=forumtopics' class='bbc_emoticon' alt=':o' />)
    Problem is with apparent "funny characters" when using the RTE editor. Other field types are OK.
    One issue came up when running the application first time (other than my ODBC connection string needing change). That was "Hex2Bin" cannot be re-declared, hence my thinking (3) is the issue.
    And, perhaps that function is used by Rich Text Fields ... and explains the unusual output.
    For example, I typed: "Test." And got "œ‚h!"
    Then when editing some other examples the update queries fail due to quote problems.
    Any ideas? Maybe not Hex2Bin but an issue with html fields via IIS/PHP?
    Thanks all.
M
 		mattd1 author 5/7/2014

UPDATE ...
The data in the DB is actually appearing OK. It's the presentation in the UI that's the problem. So "Test." appears as funny characters.
Also, the speed of the RTE functionality is really slow/issues with it - When typing nothing appears, have to move focus away from the box and back ... have tooltip on the box which may be associated/known issue?
Still I'm stuck though - any ideas?
Thanks.
Sergey Kornilov admin 5/7/2014

Older version of PHP doesn't have Hex2Bin function and PHPRunner 6.1 had to implement it on his own. PHP 5.4 and later do have this function included. If you want to run this application under PHP 5.4 or better you need to get the latest version of PHPRunner.
M
 		mattd1 author 5/7/2014

Thanks Sergey (that could be a business case for me!) - what's the upgrade price from 6.1? It's been a while since I last upgraded!
So, just to confirm, do you think that would explain the specific RTF symptoms I am experiencing in IIS/PHP 5.4 here - it works OK when running at home on Apache/older PHP.
Thanks again!
Sergey Kornilov admin 5/7/2014

You can see all upgrade options here:

http://xlinesoft.com/phprunner/upgrade_guide.htm