[PHP-DB] Text corruption when storing to MySql

[Gaby T.]

I am running into a problem where as I want to store test form a text field
to a database (MySql in this case, sql type text).
Apparently, if people are cutting and
pasting text from another document (typically MS WORD) into the textfield,
the text gets only partially saved. I am assuming wierd characters are being
introduced in this manner (I definitively know this is a problem with 
rounded quotes) and although I am using the basic addslashes function, 
it's not enough.
Has anyone seen this before and is there a fix?
Thanx
Gaby

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Text corruption when storing to MySql

[Gaby T.]

I am running into a problem where as I want to store test form a text field
to a database (MySql in this case, sql type text).
Apparently, if people are cutting and
pasting text from another document (typically MS WORD) into the textfield,
the text gets only partially saved. I am assuming wierd characters are being
introduced in this manner (I definitively know this is a problem with 
rounded quotes) and although I am using the basic addslashes function, 
it's not enough. Has anyone seen this before and is there a fix?
Thanx
Gaby

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Join Sentences

[Gaby]

No, I know how manage the functions  I said for exemple :

If I need insert or delete data in two tables, and one of them returns
error, the data stay inconsistent. I know that languages like Oracle have
sentences ROLLBACK, but I work in Mysql and I think this not works very
well.

A acuse of it, I ask me if PHP can control this for a group of sentences, in
other situations, like add un global array element, or similar. If the
function starts, modify this global variable, and after returns error, it's
necessary rollback the actions made.

You understand now ??

Thank you a lot.

Gaby
http://www.atrivia.com


- Original Message -
From: Jorge Santos [EMAIL PROTECTED]
To: Gaby [EMAIL PROTECTED]
Cc: PHP-DB [EMAIL PROTECTED]
Sent: Friday, February 09, 2001 2:17 PM
Subject: Re: [PHP-DB] Join Sentences


 Hi  Gaby,

 Your best bet is to probably place the statements you want into a
function.
 Then, when the function is called if any one statement fails you simply
 return from the function with an error code.

 Hope this answer helps you...

 --
 (No Espanol mas Portugues)
 O melhor a fazer e para por as declaracoes numa funcao. Depois quando
chamar
 a funcao, se alguma declaracao erra, regresse da funcao com um codico
 proprio.

 Espero que esta resposta lhe pode ajudar.

 Later,
 Jorge
 [EMAIL PROTECTED]
 - Original Message -
 From: Gaby [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Friday, February 09, 2001 7:59 AM
 Subject: [PHP-DB] Join Sentences


 Hi,

 ( Excuse me for my english )

 I wish execute in PHP some consecutives sentences , but if one of them
 returns un error, the program must'n execute anyone. I need one set of
 sentences that executes the code like one.

 I don't know if I explain ... Thanks a lot.
 ---
 Por si acaso alguien me entiende mejor en espaol :
 Lo que me gustaria es ejecutar un grupo de sentencias como si fueran solo
 una




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]