Subject Re: [firebird-php] Re: error when including on firebird because accent
Author Jochem Maas
anna_ppalm wrote:
> Char set is set to win1252

I'm willing to bet that you script and/or the string your trying to
stuff into the DB is not encoded with the same charset. this
causes problems with anything other than those chars found in the ASCII
range (pardon my terminology).

you can try a number of things:

1. specify the charset in the ibase_connect() function (as Lester mentioned)
2. use iconv() to translate the string into the win1251 charset before stuffing
it into the database.
3. recreate your database using a charset that matches whatever is used by
your scripts.



>
> :)
>
> Anna
>
>
>
>
>
>
>
> --- In firebird-php@yahoogroups.com, Jochem Maas <jochem@...> wrote:
>
>>anna_ppalm wrote:
>>
>>>
>>>I am not too sure why, but I am getting the following error when
>
> trying
>
>>>to include the word "Guaruj√°" into the DB.
>>>
>>>
>>>ibase_query(): arithmetic exception, numeric overflow, or string
>>>truncation Cannot transliterate character between character sets
>>
>>what is the charset of the DB and if explicitly set the field in
>
> question?
>
>>>As soon as I take the accent out it works.
>>>
>>>Any idea??
>>>
>>>Thanks
>>>
>>>Anna
>>>
>>>
>>>
>>>[Non-text portions of this message have been removed]
>>>
>>>
>>>
>>>
>>>Yahoo! Groups Links
>>>
>>>
>>>
>>>
>>>
>>>
>>
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>