Hi folks,

Platform : Win2k (english and japanese)
Problem : Trying to use UTF8 and japanese

I am new to sybase but I have loads of experience with Oracle and MsSQL and they cope quite well with this and it ain't rocket science to get those 2 working. I was expecting a similar experience with sybase but this has proved not to be that case. The data in the script below is just going in as question marks even though I have everything (I think) set up as utf8. Am I missing something? any help would be appreciated. (Please don't refer me to sybase documentation. I've been through it and it ain't no help.

Thanks

Marc

<%@ CodePage=65001 Language=JavaScript%>
<%

ADO=new ActiveXObject('ADODB.RecordSet');

s='�³‚ê‚é';

c='Provider=Sybase.ASEOLEDBProvider.2;Initial Catalog=mydb;User ID=sa;Data Source=myds;Password=;Character Set=utf8';

//comment the following line out after the first run
ADO.Open("create table test(utf nchar(40))",c);

//ADO.Open("update test set utf=N'�³‚ê‚é'",c);

ADO.Open("insert into test (utf)values('�³‚ê‚é')",c);

ADO.Open('select * from test',c);

s=ADO.Fields('utf')+'';

Response.Write(s);

%>