Re: UTF8 and SQL-Server 2005/2008
Re: UTF8 and SQL-Server 2005/2008
- Subject: Re: UTF8 and SQL-Server 2005/2008
- From: Chuck Hill <email@hidden>
- Date: Tue, 15 Nov 2011 10:25:58 -0800
Hi Michael,
On 2011-11-14, at 10:58 PM, Michael DeMan wrote:
> 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.
I don't recall having any UTF-8 problems with SQL Server 2005 or 2008.
> 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.
You may want my plugin for SQL Server:
http://www.global-village.net/chill/ms_sql_server_eof_plugin
Chuck
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
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