Storing Data in SQL from an ASP Form

  • Hi All,

    Any help would be much appreciated.

    We have SQL2K setup to handle Chinese characters (using nvarchar etc.), we can succesfully store chinese characters within SQL.

    However, whenever our clients submit data via our ASP Forms the data is being either 'converted/corrupted' when it's stored within SQL (maybe it's the browsers?)

    Does anyone know how this can be done succesfully?  SQL stores Chinese characters without a problem (I can paste Chinese text in and it appears fine).

    Kind regards,

    Gary.

  • Just a WAG but do you maybe have to set the encoding for the FORM tag in your ASP page?  Entering "html form encoding chinese" in Google yields some info, of which http://tech.irt.org/articles/js133/ looks promising but every time I go to the page it locks up my browser...

  • Use the utf-8 encoding for all pages.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply