Displaying of Korean on a english OS web, database server RSS

• • Reply
  bruceng

  None

  0 Points

  2 Posts

  Displaying of Korean on a english OS web, database server

  Jun 17, 2005 02:41 AM|bruceng|LINK

  I'm migrating an existing ASP application from Korean OS to English OS.
  
  The asp application already have the following:
  <meta http-equiv="Content-type" content="text/html; charset=euc-kr">
  <%session.CodePage=949%>
  This application displays Korean both in hard-coded HTML, as well as extracted from the database
  
  The MSSQL database server contains Korean & the collation is set to Korean_Wansung_CI_AS
   Using query analyser, I'm able to see the Korean, but when it comes to the web page, I can only see the hard-coded Korean, while the database extracted Korean is seen as strings of "???".
  
  Would anyone be able to help?
  Thanks in advance!
  
  

• • Reply
  Caddre

  Contributor

  4150 Points

  5249 Posts

  Re: Displaying of Korean on a english OS web, database server

  Jun 17, 2005 11:48 PM|Caddre|LINK

  "???" is called Character conversion the easy way to fix is use note pad to save your code as Unicode and change your datatype in the database to NChar, NVarchar and NText, the former is limited to 4000.  Try the link below and download the Localization Tool kit.  Hope this helps.
  
  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnaspp/html/entloctoolkit.asp
• • Reply
  bruceng

  None

  0 Points

  2 Posts

  Re: Displaying of Korean on a english OS web, database server

  Jun 19, 2005 01:46 AM|bruceng|LINK

  Yes you're right!!
  I've changed the datatype to nvarchar & it works!!!
  
  Thank you very much. Really appreciated it [:D]