#20962 [Com]: ibase_query don't work with varchar character set win1251
| From: | hristo at teacher dot com | Date: | Sat, 14 Dec 2002 15:52:49 +0000 |
| Subject: | #20962 [Com]: ibase_query don't work with varchar character set win1251 | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-27700@lists.php.net to get a copy of this message | ||
ID: 20962
Comment by: hristo@teacher.com
Reported By: hristo@teacher.com
Status: Feedback
Bug Type: InterBase related
Operating System: win 2000
PHP Version: 4.2.3
New Comment:
I'm sorry, but I fix my mistake.
$db_con = ibase_connect($HOST:$DB_PATH, $USER, $PASS, 'win1251');
not
$db_con = ibase_connect($HOST:$DB_PATH, $USER, $PASS);
and it's OK
Previous Comments:
------------------------------------------------------------------------
[2002-12-12 11:14:03] sniper@php.net
Please try using this CVS snapshot:
http://snaps.php.net/php4-latest.tar.gz
For Windows:
http://snaps.php.net/win32/php4-win32-latest.zip
------------------------------------------------------------------------
[2002-12-12 10:14:28] hristo@teacher.com
CREATE TABLE CATEGORIES (
CAT_ID INTEGER NOT NULL,
CYR_TEXT VARCHAR (100) character set WIN1251);
<?php
$any_cyrilic_text = 'òåêñò íà êèðèëèöà';
$update_stmt = "update categories set cyr_text='".$any_cyrilic_text."'
where cat_id=".$edit_id;
ibase_query($db_link, $update_stmt);
?>
after executing this code
Warning: InterBase: arithmetic exception, numeric overflow, or string
truncation Cannot transliterate character between character sets
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=20962&edit=1