Japanese sites with shift-jis

[Amruthavakkula, Malini (CORP,Consultant)]

Hi All,     we are in the process of launching a website in Japanese. We are using charset in all our ASP pages to shift-jis. Data insertion and retrieval goes fine, but the regular string function are not giving proper results with the data inserted in database. We use oracle8i with charset = utf-8. Also server.HTMLencode doesn't work. Our database is running on Solaris.   Does it make any difference whether the database is on NT or Solaris.   Any experience with this kind of set up for website, pls. reply back, looking forward for more suggestions.   Thanks