UTF8 and SQL-Server 2005/2008
UTF8 and SQL-Server 2005/2008
- Subject: UTF8 and SQL-Server 2005/2008
- From: Michael DeMan <email@hidden>
- Date: Mon, 14 Nov 2011 22:58:01 -0800
Hi,
We are updating some apps to be UTF8 enabled. I have done this kind of work in the past with Oracle and MySQL, but never with SQL-Server.
I spent a couple hours earlier today googling around and realized that there are a few oddities doing this with SQL-Server. Starting with the fact that it does not natively support UTF8 encoding for char/varchar columns? I also saw some older WebObjects related posts about lack of support for nchar, nvarchar and such as well - although possibly they are obsolete?
We seem to have things running okay with FrontBase for our workstation dev environments, but our corporate deployment environment is SQL-Server 2005.
My next step is to migrate the apps over to our dev SQL-Server 2005 environment. Before I pour too many hours into that I was wondering if there are any tips & tricks I should be aware of with WebObjects + SQL-Server and UTF8.
Thanks,
- Mike DeMan
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden