Saturday, February 3, 2007

Korean (Unicode) ASP Application Migration

These are the things that my Team discovered when we did the migration for Korean Application from Korean Server Based System to English Server:
1. Database objects
If the tables are already using nvarchar / nchar as the field type, there should not be a problem.
But if the fields which contain korean characters are using varchar / char with korean collation, we will need to modify the field type into nvarchar / nchar.
And after changing the field type, all insert / update to these fields will have to have 'N' before the string, for example : N'This is the string'
The modification can be :
- in the code
- in the stored procedures (parameters)
2. Language Packs
The server may need to be installed with the korean language packs
3. Sending Email
The application has a tool to send out emails. There's a feature to encode the from name, subject, and body using certain charset, euc-kr is a standard charset that we are using for Korean Application.
4. ASP Application
To display the information correctly in the korean characters, we may need to set the <%@ CODEPAGE=949 %> in the top of the page.
Previously we're using the Session.CodePage=949 but still don't know why it's not working after we move the application to our server, but we tried using Session.CodePage=CP949 and it worked.
Because CODEPAGE=949 is documented in the msdn articles and Session.CodePage=CP949 is not, we decided to just use the CODEPAGE.

20 comments:

Application Migration Services said...

thanks allot for this very good blog, i think it is about application migration capabilities for legacy application redesign and re-engineer migration to multiple databases.

Logo design said...

This is an awesome blog and a great source to get updated by some of the greatest facts. The work you did in order to implement this is absolutely magnificent.
logo

Logo design said...

An best blog this is,and a quality source to get updated by some of the greatest facts,thanks to share.
dissertation

Dissertation Writing Help said...

Your blog is really helps for my search and i really like it.. Thanks a lot..:)

dissertation writing services

Logo Design said...

A beautiful and high quality information.this paper is accurate to be useful. Thanks to the author.

thesis said...

This is an awesome blog and a great source to get updated by some of the greatest facts.

Logo Design Blog said...

Thanks for this article. It's just what I was searching for. I am always interested in this subject.

Business VoIP said...

An awesome blog giving so much knowledge and very keen regarding learning. Keep it up well done.

Paper Writing Services said...

This is really good advice. i also like this! thanks so much for this post!

Software Development Company said...

That is very good comment you shared.Thank you so much that for you shared those things with us.I'm wishing you to carry on with Ur achievements.All the best.

Local Advertising said...

Excellently written article, if only all bloggers offered the same level of content as you, the internet would be a much better place. Thank you for posting.

Beauty Reviews said...

Your article is great and informative. It helped me a lot in my research. I like your way of writing. I have bookmarked your blog. Thanks for sharing.

dissertation proposal paper said...

You posted editorial which gives users bunch of information concerning meticulous subject recognition for this allocate.
Dissertation proposal paper

ASP.Net Migration said...

Nice details about asp application migration.

Hajj Packages said...

That's really very nice blog it was really interesting reading this blog post Thanks for sharing with us.

Umrah Packages said...

Great post, I enjoyed ready reading it, Keep posting good stuff like this.

Wholesale Towels said...

Really great post. I like this information really, Its very nice collection of the great information. Thanks for sharing the information.

Used Police Cars said...

Thanks for taking the time to discuss this, I feel strongly about it and love learning more on this topic. If possible, as you gain expertise.

Sana Jamal said...

Really make an impression the way Ilinktours.com. Supportive staff all ways Makkah to Madinah, Nice accommodation during the hajj, although I was not feeling well, terrible fever, but I Link Tours staff cares me a lot, very supportive staff.. Thanks Hajj Travel Agents

Anna Howell said...

I just finish your blog and I find it amusing. Write some more in same manner. I would really like to read your next post. uk essay writing

Post a Comment