Unanswered: Saving japanese characters using ASP pages into SQL 2K
I am building an application with ASP pages and SQL 2K and running into problem when i save the japanese characters using ASP -> ODBC-> SQL 2K
We get the translated data into japanese in excel spreadsheets which i upload to the SQL DB tables. In enterprise mgr this can be seen fine (since i do have japanese font installed on my client machine)
When I pull this data onto ASP pages, I use
Codepage : 932
CharSet : shit_jis
It shows up fine, but I have an admin interface where users can change this data and save it back to the database. This is where I run into problem.
The data shows up in japanese (pulled from SQL 2K db) into the textboxes on asp page but when I save the same back to the DB, it saves it as ???????????
Can Someone PLEASE tell me where am i going wrong or what setting am i missing?... thanks a ton,