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.
Saturday, February 3, 2007
Korean (Unicode) ASP Application Migration
Subscribe to:
Post Comments (Atom)
22 comments:
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.
A beautiful and high quality information.this paper is accurate to be useful. Thanks to the author.
This is an awesome blog and a great source to get updated by some of the greatest facts.
Thanks for this article. It's just what I was searching for. I am always interested in this subject.
An awesome blog giving so much knowledge and very keen regarding learning. Keep it up well done.
This is really good advice. i also like this! thanks so much for this post!
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.
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.
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.
You posted editorial which gives users bunch of information concerning meticulous subject recognition for this allocate.
Dissertation proposal paper
Nice details about asp application migration.
That's really very nice blog it was really interesting reading this blog post Thanks for sharing with us.
Great post, I enjoyed ready reading it, Keep posting good stuff like this.
Really great post. I like this information really, Its very nice collection of the great information. Thanks for sharing the information.
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.
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
Thank you for the good information and very helpful. That's very interesting. I like all the things you share.
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 .
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.
Amazing and informative post.
Men Brown Leather Jacket
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.
This post is really amazing and informative. I would like to see this type of post in the future.