Character not supported?

[Paul Sharpe]

I get errors anytime I try to insert any record that contains the ' character.

EXAMPLE: O'Brien

The program will accept Obrien, O"Brien or even O+Brien but NOT O'Brien

Can someone please help me with this problem?

THANKS

 

[Paul Sharpe]

I made the following changes to the php.ini file:

php_flag magic_quotes_sybase On
php_flag magic_quotes_runtime On
php_flag magic_quotes_gpc On

NOW.......I can insert a record which contains an apostophe. However, the database shows the correct entry but DaDaBik produces a different result in the search report.

EXAMPLE:

Database shows O'Brien
DaDaBik shows O"Brien

All entries in the database that contain an apostrophe produce a " in DaDaBik.

Any suggestions on how to fix this?

THANK-YOU

 

[Paul Sharpe]

OK......I've starting to learn a little about the way PHP handles the apostrophe. Before importing the database into DaDaBik, I added a \ before each '

This can be done easily by using the "search and replace" feature found in most text editors/word processors.

EXAMPLE: O'Brien became O\'Brien

I then used .htaccess to set the php.ini file as follows:

php_flag magic_quotes_sybase Off
php_flag magic_quotes_runtime Off
php_flag magic_quotes_gpc On

I imported the database into DaDaBik and PHP took care of the rest.

O\'Brien becomes O'Brien and my problem is fixed! All data displayed in DaDaBik is formatted correctly. I can now import, insert and search data that contains an apostrophe.

Hope this info can help someone else.

 

[Eugenio]

Paul Sharpe wrote:
>
> OK......I've starting to learn a little about the way PHP
> handles the apostrophe. Before importing the database into
> DaDaBik, I added a \ before each '
>
> This can be done easily by using the "search and replace"
> feature found in most text editors/word processors.
>
> EXAMPLE: O'Brien became O\'Brien
>
> I then used .htaccess to set the php.ini file as follows:
>
> php_flag magic_quotes_sybase Off
> php_flag magic_quotes_runtime Off
> php_flag magic_quotes_gpc On

The settings are ok.
With these settings (which are the default) you don't need to escape or replace anything, everything is already handled by PHP. So you can safety insert value containing quote (').

Eugenio.

(Latest version of DaDaBIK when this message was posted: 2.2.1)

>
> I imported the database into DaDaBik and PHP took care of the
> rest.
>
> O\'Brien becomes O'Brien and my problem is fixed! All data
> displayed in DaDaBik is formatted correctly. I can now
> import, insert and search data that contains an apostrophe.
>
> Hope this info can help someone else.