Re: What datatype to use for 0-255 char set?

From: <jonathanwalden_at_my-deja.com>
Date: Tue, 31 Aug 1999 23:45:06 GMT
Message-ID: <7qhpdv$fpj$1@nnrp1.deja.com>

What character set did you use when creating your database? What locale version of NT/9x are you using?

In article <37cb9da8.0_at_news.cyberway.com.sg>, "Jasmine TAN" <tjasmine_at_starnet.gov.sg> wrote:
> I tried to update, for e.g., "®ØÝá" into a table with column
> varchar2(4) using ADODB through VB.
>
> However, when I do a query into the table, I cannot get back those
> characters exactly as they were.
>
> Also, I have tried declaring the table with datatype of nvarchar2(4)
> and VB will give me "character set mismatch" error message when I
> tried to insert those characters into the table.
>
> Kindly advise on which datatype should I use in order to insert and
> get back those characters mentioned. Thanks.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Aug 31 1999 - 18:45:06 CDT