Help!! International Website Development


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 6 of 6

Thread: Help!! International Website Development

  1. #1
    Jessie Guest

    Help!! International Website Development


    I am trying to input Chinese characters from my asp forms, into SQL Server7.
    However, I'm getting invalid buffer errors.
    How can I get this data into the DB?
    Platform: Windows 2000, IIS5

    Thanks in advance

  2. #2
    Ruth Guest

    Re: Help!! International Website Development


    I have not tried myself, but I think all Chinese characters are in two bytes
    format if your form uses "GB2312". Try to catch two bytes for each character,
    and put them in the DB. Then see if you can redisplay it correctly. Hope
    this can give you some help.

    Ruth

    "Jessie" <mail@mail.com> wrote:
    >
    >I am trying to input Chinese characters from my asp forms, into SQL Server7.
    > However, I'm getting invalid buffer errors.
    >How can I get this data into the DB?
    >Platform: Windows 2000, IIS5
    >
    >Thanks in advance



  3. #3
    Jessie Guest

    Re: Help!! International Website Development


    My form has the Charset for GB2312 and the session.codepage=936. But when
    I try to submit the data, nothing is added to the database and I get the
    invalid buffer error. Any ideas?

    Thanks.


    "Ruth" <rzhai@bigpond.com> wrote:
    >
    >I have not tried myself, but I think all Chinese characters are in two bytes
    >format if your form uses "GB2312". Try to catch two bytes for each character,
    >and put them in the DB. Then see if you can redisplay it correctly. Hope
    >this can give you some help.
    >
    >Ruth
    >
    >"Jessie" <mail@mail.com> wrote:
    >>
    >>I am trying to input Chinese characters from my asp forms, into SQL Server7.
    >> However, I'm getting invalid buffer errors.
    >>How can I get this data into the DB?
    >>Platform: Windows 2000, IIS5
    >>
    >>Thanks in advance

    >



  4. #4
    Javier Guest

    RE: Help!! International Website Development

    Are your DB table's columns defined as NCHAR and/or NVARCHAR?
    Regards


    "Jessie" <mail@mail.com> escribió en el mensaje
    news:3acddda7$1@news.devx.com...
    >
    > My form has the Charset for GB2312 and the session.codepage=936. But when
    > I try to submit the data, nothing is added to the database and I get the
    > invalid buffer error. Any ideas?
    >
    > Thanks.
    >
    >
    > "Ruth" <rzhai@bigpond.com> wrote:
    > >
    > >I have not tried myself, but I think all Chinese characters are in two

    bytes
    > >format if your form uses "GB2312". Try to catch two bytes for each

    character,
    > >and put them in the DB. Then see if you can redisplay it correctly.

    Hope
    > >this can give you some help.
    > >
    > >Ruth
    > >
    > >"Jessie" <mail@mail.com> wrote:
    > >>
    > >>I am trying to input Chinese characters from my asp forms, into SQL

    Server7.
    > >> However, I'm getting invalid buffer errors.
    > >>How can I get this data into the DB?
    > >>Platform: Windows 2000, IIS5
    > >>
    > >>Thanks in advance

    > >

    >




  5. #5
    LN Guest

    Re: Help!! International Website Development


    we have never got this problem with the sql7 chinese version.

  6. #6
    Jessie Guest

    RE: Help!! International Website Development


    I made my database columns nvarchar, and the data input and retrieval is correct.
    I'm working off a US English machine and English Sql Server with Simplified
    Chinese support.


    But I was wondering, if all users will have Windows 2000 machines with Simplified
    Chinese as the default, will I need to use unicode (nchar, nvarchar) to store
    the data and display and input from the web?

    The same for a VB form. Will the data be stored correctly if the user has
    a machine with Simplified Chinese as default?

    Thanks!


    "Javier" <ggyy_ar@yahoo.com.ar> wrote:
    >Are your DB table's columns defined as NCHAR and/or NVARCHAR?
    >Regards
    >
    >
    >"Jessie" <mail@mail.com> escribió en el mensaje
    >news:3acddda7$1@news.devx.com...
    >>
    >> My form has the Charset for GB2312 and the session.codepage=936. But

    when
    >> I try to submit the data, nothing is added to the database and I get the
    >> invalid buffer error. Any ideas?
    >>
    >> Thanks.
    >>
    >>
    >> "Ruth" <rzhai@bigpond.com> wrote:
    >> >
    >> >I have not tried myself, but I think all Chinese characters are in two

    >bytes
    >> >format if your form uses "GB2312". Try to catch two bytes for each

    >character,
    >> >and put them in the DB. Then see if you can redisplay it correctly.

    >Hope
    >> >this can give you some help.
    >> >
    >> >Ruth
    >> >
    >> >"Jessie" <mail@mail.com> wrote:
    >> >>
    >> >>I am trying to input Chinese characters from my asp forms, into SQL

    >Server7.
    >> >> However, I'm getting invalid buffer errors.
    >> >>How can I get this data into the DB?
    >> >>Platform: Windows 2000, IIS5
    >> >>
    >> >>Thanks in advance
    >> >

    >>

    >
    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center