At 09:01 PM 4/02/2004 +0000, you wrote:

>Where do I find information about what characters valid for what
>dialects?

Character validity has to do with character set, not SQL dialect.

>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?

No. But you *will* get a transliteration problem if you are trying to put
a dollar sign into a varchar, if the database default character set does
not include a dollar sign.
Note that the character set parameter of the client must be same as the
default character set of the database.

>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.

Show the SQL statement you are using to "convert" and "insert". A blob is
not a string. You can't convert a blob to a varchar without using an
external function - but you still won't be able to use a character that is
not in the character set.

/heLen