Hi Helen,

Using the Cast() I understand but the second method you demonstrate is new
to me.

Are you saying that you can add an underscore followed by the character set
name onto the beginning of a string and the server will cast the string to
that charset before insertion?

Thanks,

Rick

----- Original Message -----
From: "Helen Borrie" <helebor@...>
> I don't doubt that's correct for the Java driver, but, making use of the
> SQL language, you can do
>
> --with parameters
> insert into charset_table (col1, col2)
> values (cast (? as varchar(10) character set WIN1252),
> cast (? as varchar(10) character set NONE));
>
> --with your literals in variables ('scuse the non_java-ish concatenation
> syntax, but you get the idea..)
>
> YourSQLString = "insert into charset_table(col1, col2) values(_WIN1252" +
Var1
> + ", _NONE " + Var2
>
> Helen