Subject | Dialect problem?? |
---|---|
Author | sllimr7139 |
Post date | 2004-02-04T21:01:34Z |
Where do I find information about what characters valid for what
dialects?
I'm asking because I've run into the situation where, it appears, the
dollar sign character is not being allowed into a varchar field. I'm
trying to convert a blob column to a varchar(32000) column.
I get the error message:
ICS ERROR CODE:335544321
ICS ERROR MESSAGE:
arithmetic exception, numeric overflow, or string truncation
Cannot transliterate character between character sets
If I remove the $ characters then I can manually insert the data with
no problem. Is this even a dialect problem?
Here is the data I'm trying to insert: (with out the []'s)
[We billed out Imperial Oil for some labor, OT, and contract labor.
The total that aims added it up to was $4669.75 incl. GST When in fact
the total was supposed to come to $4113.35 I want to do a credit for
that invoice, but I am not sure how I am to do that when the credit
amount won't add up to the invoice amount, unless I change the
dollar
amount/hr. that the labor is billed out at? Please advise.]
Any help would be appreciated.
dialects?
I'm asking because I've run into the situation where, it appears, the
dollar sign character is not being allowed into a varchar field. I'm
trying to convert a blob column to a varchar(32000) column.
I get the error message:
ICS ERROR CODE:335544321
ICS ERROR MESSAGE:
arithmetic exception, numeric overflow, or string truncation
Cannot transliterate character between character sets
If I remove the $ characters then I can manually insert the data with
no problem. Is this even a dialect problem?
Here is the data I'm trying to insert: (with out the []'s)
[We billed out Imperial Oil for some labor, OT, and contract labor.
The total that aims added it up to was $4669.75 incl. GST When in fact
the total was supposed to come to $4113.35 I want to do a credit for
that invoice, but I am not sure how I am to do that when the credit
amount won't add up to the invoice amount, unless I change the
dollar
amount/hr. that the labor is billed out at? Please advise.]
Any help would be appreciated.