insert utf8 values
Posted by: David Engler
Date: March 01, 2011 07:28PM

Hi

I'm trying to insert utf8 values but it doesnt work. my database, tables, html and headers are all set to utf8

this is the code:

$sql = "SET CHARACTER SET utf8";
odbc_exec($conn,$sql);
$sql = "insert into translation (queue_id, lang_id, subject, text) values ($queue_id, $lang_id, '$subject', '$content')";
echo $sql;
$rs = @odbc_exec($conn,$sql);

this is the web page output:

insert into translation (queue_id, lang_id, subject, text) values (990, 5, 'עעעע', 'יייייבבבבב')

this is what phpadmin showing:
id queue_id lang_id subject text
47 990 5 עעעע יייייבבבבב

any help will be greatly appreciated
Thanks
David.

Options: ReplyQuote


Subject
Views
Written By
Posted
insert utf8 values
6891
March 01, 2011 07:28PM
1922
March 02, 2011 10:26PM
1794
March 02, 2011 11:43PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.