« Previous Next »

Thread: UTF-8 chars not reading in from Sybase ASE15 correctly.

Last post 07-01-2009 6:52 AM by Leo Tang - MSFT. 1 replies.

Average Rating Rate It (5)

RSS

Page 1 of 1 (2 items)

Sort Posts:

  • 06-27-2009, 11:47 AM

    UTF-8 chars not reading in from Sybase ASE15 correctly.

    Hi all,

     I have a problem where we are making our ASP web international character aware.  I have made the changes in all the ASP pages to set the Response.CharSet and CodePage, Session.CodePage, and the page directive codepage also.  

     Users can now enter special chars (namely French accented ones, 0206) and I can store them into the DB correctly.  However another page I have that reads that data and displays it pulls it in from Sybase as char 0215.  

    Does anyone know of anything I could be missing, any other directives or anything to tell ADODB to use utf-8 charset when talking to the DB.

    I greatly appreciate any help any can give and if I've left out any info that's needed, just tell me and I'll append it.

    Thanks again!

    Bill Bryant

  • 07-01-2009, 6:52 AM In reply to

    Re: UTF-8 chars not reading in from Sybase ASE15 correctly.

    Hi,

    Have you added <%@ language="VBScript" codepage=65001 %>  at the top of the page, and specified the response format by the following code?

    Response.CodePage = 65001
    Response.CharSet = "UTF-8"

    Also, make sure the page is saved in UTF-8 format.

    Leo Tang
    Microsoft Online Community Support

    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Page 1 of 1 (2 items)