Chinese character in the field (Sql 7)

24 Nov 2005 12:03 AM

tractng

Guys,

I have to replace some old chinese characters (words) with some new
ones. In the database, the fields are displayed as ???.

The current chinese characters will display fine when you retrieved the
fields through the website. As soon as I cut and paste the new chinese
characters onto the field that I want to replace, the website will
display ??? with the fields that I just updated.

I have installed the Chinese (Taiwan) letters and enable my language
toolbar. During the cut and paste process, I also switched to "CH".

Any idea?

Please help.

Thanks in advance,
Tony

24 Nov 2005 3:48 PM

Kenneth

Hi,

You can try to use CAST(0xABCD1234 as NVARCHAR(4)) etc. instead of copy and
paste.
Replace the 0xABCD1234 with the binary code of the Chinese characters.

Kenneth

<trac***@gmail.com> wrote in message
Show quote

news:1132790630.847208.228190@z14g2000cwz.googlegroups.com...
> Guys,
>
> I have to replace some old chinese characters (words) with some new
> ones. In the database, the fields are displayed as ???.
>
> The current chinese characters will display fine when you retrieved the
> fields through the website. As soon as I cut and paste the new chinese
> characters onto the field that I want to replace, the website will
> display ??? with the fields that I just updated.
>
>
> I have installed the Chinese (Taiwan) letters and enable my language
> toolbar. During the cut and paste process, I also switched to "CH".
>
> Any idea?
>
> Please help.
>
>
> Thanks in advance,
> Tony
>

28 Nov 2005 8:55 PM

tractng

Kenneth,

Can you explain, how I can do this. I am a newbie.

Thanks,
Tony