Home All Groups Group Topic Archive Search About

Passing chinese characters



Author
7 Jul 2006 7:52 PM
MrMoMo
How do I Pass chinese characters, charset GB2312 and BIG5, from Form to
SQL using asp?

My field in SQL is already set to nvarchar.

Any help is much appreciated.

Thanks.

Author
8 Jul 2006 8:37 PM
Anthony Jones
"MrMoMo" <chairman_mow***@yahoo.com> wrote in message
news:1152301925.683356.194850@m79g2000cwm.googlegroups.com...
> How do I Pass chinese characters, charset GB2312 and BIG5, from Form to
> SQL using asp?
>
> My field in SQL is already set to nvarchar.
>
> Any help is much appreciated.
>
> Thanks.
>

The page to which the form posts needs to have it's codepage set
appropriately so:-

<%@ codepage="950" %>
<%@ codepage="936" %>

Also set the form to use method="POST"

Now the unicode values retrieved for the Form values will be encoded
correctly.

Anthony.
Author
10 Jul 2006 2:00 AM
MrMoMo
Tried this and got error.

But <% session.codepage = 936 %> works.


Anthony Jones wrote:
Show quote
> "MrMoMo" <chairman_mow***@yahoo.com> wrote in message
> news:1152301925.683356.194850@m79g2000cwm.googlegroups.com...
> > How do I Pass chinese characters, charset GB2312 and BIG5, from Form to
> > SQL using asp?
> >
> > My field in SQL is already set to nvarchar.
> >
> > Any help is much appreciated.
> >
> > Thanks.
> >
>
> The page to which the form posts needs to have it's codepage set
> appropriately so:-
>
> <%@ codepage="950" %>
> <%@ codepage="936" %>
>
> Also set the form to use method="POST"
>
> Now the unicode values retrieved for the Form values will be encoded
> correctly.
>
> Anthony.
Author
10 Jul 2006 2:00 AM
MrMoMo
Tried this and got error.

But <% session.codepage = 936 %> works.


Anthony Jones wrote:
Show quote
> "MrMoMo" <chairman_mow***@yahoo.com> wrote in message
> news:1152301925.683356.194850@m79g2000cwm.googlegroups.com...
> > How do I Pass chinese characters, charset GB2312 and BIG5, from Form to
> > SQL using asp?
> >
> > My field in SQL is already set to nvarchar.
> >
> > Any help is much appreciated.
> >
> > Thanks.
> >
>
> The page to which the form posts needs to have it's codepage set
> appropriately so:-
>
> <%@ codepage="950" %>
> <%@ codepage="936" %>
>
> Also set the form to use method="POST"
>
> Now the unicode values retrieved for the Form values will be encoded
> correctly.
>
> Anthony.

AddThis Social Bookmark Button