RE: Storing Chinese data in Char/Varchar dat types

From: Mike Epprecht (SQL MVP) (mike_at_epprecht.net)
Date: 09/27/04 

Date: Mon, 27 Sep 2004 05:33:01 -0700

Hi

You need to store that data in ncahr/nvarchar fields. char/varchar do not
support the full eastern cahrater sets.

Regards
Mike

"Sunil" wrote:

> Hi,
> My environment
> Server : Windows 2000 Server
> SQL : SQL Server 2000 with SP4(Chinese)
>
> I created an SQL Server2000 database. While creating the database I
> mentioned the collation as Chinese_PRC_Stroke_CI_AI.
> I created a table containing Varcahr and Nvarchar data types with
> collation Chinese_PRC_Stroke_CI_AI.
> I am able to insert chinese data into nvarchar field through
> Enterprise Manager. But when I try to insert same chinese data to
> vrachar field through EM, it throws back error " The value you entered
> is not consistent with datatype".
>
> My question is : How we can store chinese data into cahra
> field/varchar field. Is it possible by specifying some collation?
>
> Regards
> Zunil
> Cordys
>

Relevant Pages

  • RE: How to store the out put in StringBuffer
    ... Regards ... How to store the out put in StringBuffer ... E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. ...
    (perl.beginners)
  • Re: info store stopped unexpectedly
    ... Regards ... >> Ben Hoffman ... see Help and Support Center at ... >>> The Microsoft Exchange Information Store service terminated ...
    (microsoft.public.exchange.admin)
  • Re: Getting web service dataset into xml
    ... How can I then store the local dataset into an access table locally? ... Regards ... >> I need to access to a web service method that returns a dataset type. ...
    (microsoft.public.dotnet.framework.aspnet.webservices)
  • Re: Storing Chinese data in Char/Varchar dat types
    ... But when I try to insert same chinese data to ... By setting Arial Unicode Font in Query Anlyzer, I am able to display ... Char/vrachar dat is displayed as some junk like 一地现的世. ...
    (microsoft.public.sqlserver.server)
  • Re: Adding rich text in CDOEX Appointment body
    ... Jude ... >> code the BodyPart could not be saved to the store. ... >> I flushed the stream after updating and then save the appointment item to ... >> Best regards, ...
    (microsoft.public.exchange2000.development)
Loading