2. PHPRunner General questions
  3. PHPRunner configuration
This topic is locked

PHPRunner configuration

 		7/8/2008 3:17:33 PM
PHPRunner General questions
E
 ezelino author

I am using PHPRunner4.1 having access BD ORACLE and presents two problems:

  1. In the BD the data correctly are written with special characters, but in browser it appears different

    Ex.: In the BD - comunicação

    In browser it appears - comunica??o

    (I live in Brazil and here we use these characters - ç, â , ã )
  2. In a field defined in a table as number the values they are as integer, but in browser they apear with points and commas

    Ex.: In the BD a field has tested to number appears thus - 12345

    In browser it appears thus - 12.345,00

    How to configure the PHPRunner correctly so that this problem does not occur?
Alexey admin 7/9/2008

Hi,

  1. This happens because the NLS_LANG environment variable is not set at your webserver machine.

    It should contain

    PORTUGUESE_BRAZIL.WE8ISO8859P1

    Either set it in your machine environment or add this line to the beginning of genertated include\dbcommon.php file, just after the <?phpline:
    putenv("NLS_LANG=PORTUGUESE_BRAZIL.WE8ISO8859P1");


Restart you webserver after changing the environment variable.
2. Double-click your field on the Visual Editor tab in PHPRunner and choose empty View type instead of Number.