Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-01-23 : 08:51:06
|
| Mark writes "When I try to display Japanese data from the MSSQL on an ASP page it writes out ???, the collation on MSSQL is set correctly, I have tried setting the code page etc in the ASP file too but no change in it. Please advise." |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2003-01-24 : 00:46:52
|
quote:
Mark writes "When I try to display Japanese data from the MSSQL on an ASP page it writes out ???, the collation on MSSQL is set correctly, I have tried setting the code page etc in the ASP file too but no change in it. Please advise."
We had the same problem at my place ,I don't remember how we solved it but there were some settings to be don in the code page and I had set the locale regional settings as japanes for the server.Expect the UnExpected |
 |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2003-01-24 : 05:16:43
|
Mark: What OS are you using? If you are using WINNT Server then the OS needs to be Japanese Localised or Enabled. If you are using Win2K Server, make sure the Japanese codepage is installed (from Regional Settings) and it is the default codepage of the Server. This is because IIS uses the default codepage of the OS to decode & encode the data it receives from SQL Server. We face the same problem with Arabic all the while. But there is a caveat there: changing the default codepage to Japanese will affect the formatting of nearly everything in the OS, particularly how it (read IIS) formats dates and currency. I have seen a few examples of how you can edit the metabase to make IIS use a different codepage from the default in the OS, but I never had the guts to try it  . You might try using the Session.LCID to change the formatting options at a Session Level.HTHOS |
|
|
|
|
|
|
Display Japanese data from the MSSQL to ASP page