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

Can you please tell me how to find out the character set for the database, which my DBA has created.

Kindly enlighten me which character set and locale version that I should use instead. Thanks again.

jonathanwalden_at_my-deja.com wrote in message <7qhpdv$fpj$1_at_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 Wed Sep 01 1999 - 06:43:10 CDT