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.

22 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...

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.

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

shop Now said...

Thank you for the good information and very helpful. That's very interesting. I like all the things you share.

Anonymous said...

Thanks for writing such an informative post. It is not just for me but for many other people. but when I talk about fashion, the thing that instantly comes in our mind is styling with leather jackets so Shop Now .

Global News said...

Wow, this is amazing. The details are explained very well. Thank you so much for this one. This is what I need right now. keep posting.

Jennifer Smith said...

Amazing and informative post.
Men Brown Leather Jacket

noahdaniel said...


The Allure of the Brown Hoodie
Brown hoodies offer a timeless aesthetic that complements a wide range of skin tones and can be effortlessly integrated into both casual and smart-casual ensembles. Men’s Brown Hoodie Zip-up The warm and earthy tones of brown evoke a sense of comfort and versatility, making brown hoodies a popular choice for men seeking a versatile and stylish garment.

Ecommerce Website Development said...

This post is really amazing and informative. I would like to see this type of post in the future.

Post a Comment