| Problems with special HTML characters and PLSQL packages [message #329743] |
Thu, 26 June 2008 07:14  |
xokas11
Messages: 28
Registered: January 2008
Location: Guadalajara, Spain
|
Junior Member |
|
|
Hello
I'm having problems with an insert procedure. The thing is the procedure is called from a PHP5 script that receives it´s parameters from a WYSIWYG HTML editor. I'm working in Spain and here we use a couple of characters (ñ,Ñ,á,Á,e,É,í,Í,ó,Ó,ú,Ú) that in HTML are represented like this:
ñ,Ñ -> ñ,Ñ
á,Á -> ´,&Acute;
ó,Ó -> &ocute;,&Ocute;
é,É -> &ecute;,&Ecute;
í,Í -> &icute;,&Icute;
ú,Ú -> &ucute;,&Ucute;
So when I try to insert them the insert fails but if I call the procedure from SQL Developer and use the "SET DEFINE OFF" or "SET DEFINE $" it works.
My question: Is there any possibility to call the "set define off" command from outside the SQL Developer, preferably from PHP5 or is there any command that alters these behaviors permanently, for example, changing the variable define character or being able to disable defining variables
Thanks, Joaquín.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
