Welcome Guest, Not a member yet? Register   Sign In
1.60 - save mysql-text field problem
#1

[eluser]vince.s.wong[/eluser]
There's weird problem with text-record field,
Quote:can't save the text with contains character '- )-
only the text before that character will save to record.
#2

[eluser]Derek Allard[/eluser]
Hi Vince, welcome to CodeIgniter.

Is this an error message you're generating? Where and doing what? Could you give some code?
#3

[eluser]vince.s.wong[/eluser]
[quote author="Derek Allard" date="1201859929"]Hi Vince, welcome to CodeIgniter.

Is this an error message you're generating? Where and doing what? Could you give some code?[/quote]

Only posting record from text input form,
It was running well on 1.54, but in 1.60 can't post the text content if contains
' )-, but probably for another special characters.
The result of record is the start of the content before this characters.

Note: I got have no any error message.

Thanks Smile
#4

[eluser]Kurai[/eluser]
It's the same for me, it seem to have problem with all non-ascii character. Being an Italian, accented letters don't work, either.
#5

[eluser]Derek Allard[/eluser]
are you both saying that
Code:
$this->db->insert('functions',  array('field' => '-)'));
fails for you?
#6

[eluser]vince.s.wong[/eluser]
[quote author="Derek Allard" date="1201905580"]are you both saying that
Code:
$this->db->insert('functions',  array('field' => '-)'));
fails for you?[/quote]

Hai...
Hope this can figure that's i mean:

controller:
Code:
$defaultVal_tb_content    = $this->input->post($ctlName_tb_content,true);
models:
Code:
function insert_news($ID,$TITLE,$CONTENT)
    {
        $sql_query = " INSERT INTO ".
                     " news ".
                     " (ID,TITLE,CONTENT)".
                        " values (?,?,?) " ;
        
        $this->db->query($sql_query,array($ID,$TITLE,$CONTENT));
    }
views:
Code:
...
    <tr>
    <td valign="top">Content</td><td valign="top">&lt;? print $param_obj['control_binding']['tb_content']?&gt;</td>
  </tr>
...

Try to type non asci characters in text input box...




Theme © iAndrew 2016 - Forum software by © MyBB