Re: [PHP] php interbase problem.....

2003-07-23 Thread Wei
I already set the charset but still cannot work. By the way, I can retrieve
the data in other program.

Anyway, thanks for your reply


Curt Zirzow [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
 * Thus wrote Wei ([EMAIL PROTECTED]):
  Hope someone can solve my problem.
 
  I'm using Interbase as a database. I get error message when  I retrieve
data
  from the database (ibase_fetch_row) which contain chinese character.
 
  Warning: ibase_fetch_row(): arithmetic exception, numeric overflow, or
  string truncation Cannot transliterate character between character sets
in
  .

 Not sure if this helps:

 http://bdn.borland.com/article/0,1410,29891,00.html

 then this should:

 http://php.net/ibase_connect

 snip
 int ibase_connect ( string database [, string username [, string
 password [, string charset [, int buffers [, int dialect [, string
 role]])
 /snip

 Notice the charset parater, you need to set that to the appropriate
 charset chinese is defined as. (Big5, Big5HKHCS, etc...)


 Curt
 -- 
 I used to think I was indecisive, but now I'm not so sure.



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



[PHP] php interbase problem.....

2003-07-22 Thread Wei
Hope someone can solve my problem.

I'm using Interbase as a database. I get error message when  I retrieve data
from the database (ibase_fetch_row) which contain chinese character.

Warning: ibase_fetch_row(): arithmetic exception, numeric overflow, or
string truncation Cannot transliterate character between character sets in
.

If  I select the record without the field that contain the chinese
character, it works..

The datatype for the field that contain chinese character is varchar(20).

(I use program written in Delphi to enter the data into the database and now
I want to use php to retrieve the data)



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



Re: [PHP] php interbase problem.....

2003-07-22 Thread Curt Zirzow
* Thus wrote Wei ([EMAIL PROTECTED]):
 Hope someone can solve my problem.
 
 I'm using Interbase as a database. I get error message when  I retrieve data
 from the database (ibase_fetch_row) which contain chinese character.
 
 Warning: ibase_fetch_row(): arithmetic exception, numeric overflow, or
 string truncation Cannot transliterate character between character sets in
 .

Not sure if this helps:

http://bdn.borland.com/article/0,1410,29891,00.html

then this should: 

http://php.net/ibase_connect

snip
int ibase_connect ( string database [, string username [, string
password [, string charset [, int buffers [, int dialect [, string
role]])
/snip

Notice the charset parater, you need to set that to the appropriate
charset chinese is defined as. (Big5, Big5HKHCS, etc...)


Curt
-- 
I used to think I was indecisive, but now I'm not so sure.

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