Re: Inserting Arabic data into Oracle DB

2010-12-09 Thread cricket
2010/12/9 osamo101 : > No, there is no particular reason for using query(), I am using it for > testing only after the Cake's way failed. > > I wrote a plain PHP script and the problem still exist. So it's not a Cake thing. I just did a quick google and saw that there seems to be some issue with O

Re: Inserting Arabic data into Oracle DB

2010-12-09 Thread osamo101
No, there is no particular reason for using query(), I am using it for testing only after the Cake's way failed. I wrote a plain PHP script and the problem still exist. On Dec 9, 3:09 am, cricket wrote: > 2010/12/8 osamo101 : > > > In DATABASE_CONFIG I added the following line > > 'encoding' =>

Re: Inserting Arabic data into Oracle DB

2010-12-08 Thread cricket
2010/12/8 osamo101 : > In DATABASE_CONFIG I added the following line > 'encoding' => 'UTF8' Are you sure that Oracle wants 'UTF8' and not something else (eg. 'utf-8', 'UTF-8', etc.)? > and the insertion code is as follows > $this->Activity->query("INSERT INTO TMSACTIVITIES(name, arabic_name) > VA

Re: Inserting Arabic data into Oracle DB

2010-12-08 Thread osamo101
Yes On Dec 9, 12:34 am, Ryan Schmidt wrote: > On Dec 8, 2010, at 16:30, osamo101 wrote: > > > In DATABASE_CONFIG I added the following line > > 'encoding' => 'UTF8' > > > and the insertion code is as follows > > $this->Activity->query("INSERT INTO TMSACTIVITIES(name, arabic_name) > > VALUES('some

Re: Inserting Arabic data into Oracle DB

2010-12-08 Thread Ryan Schmidt
On Dec 8, 2010, at 16:30, osamo101 wrote: > In DATABASE_CONFIG I added the following line > 'encoding' => 'UTF8' > > and the insertion code is as follows > $this->Activity->query("INSERT INTO TMSACTIVITIES(name, arabic_name) > VALUES('some_name', 'خخخ')"); Is this PHP file also saved with UTF-8

Re: Inserting Arabic data into Oracle DB

2010-12-08 Thread osamo101
In DATABASE_CONFIG I added the following line 'encoding' => 'UTF8' and the insertion code is as follows $this->Activity->query("INSERT INTO TMSACTIVITIES(name, arabic_name) VALUES('some_name', 'خخخ')"); On Dec 8, 3:42 pm, Ryan Schmidt wrote: > On Dec 8, 2010, at 04:22, osamo101 wrote: > > > I am

Re: Inserting Arabic data into Oracle DB

2010-12-08 Thread cricket
On Wed, Dec 8, 2010 at 5:22 AM, osamo101 wrote: > Hi > > I am trying to insert Arabic characters into oracle db but i got > question marks inserted instead, I mad sure that the db accepts Arabic > characters, I created a sample ASP application and it inserted the > Arabic characters correctly. Do

Re: Inserting Arabic data into Oracle DB

2010-12-08 Thread Ryan Schmidt
On Dec 8, 2010, at 04:22, osamo101 wrote: > I am trying to insert Arabic characters into oracle db but i got > question marks inserted instead, I mad sure that the db accepts Arabic > characters, I created a sample ASP application and it inserted the > Arabic characters correctly. > > Can you pl

Inserting Arabic data into Oracle DB

2010-12-08 Thread osamo101
Hi I am trying to insert Arabic characters into oracle db but i got question marks inserted instead, I mad sure that the db accepts Arabic characters, I created a sample ASP application and it inserted the Arabic characters correctly. Can you please help me, I spent more than two days in trying t