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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to