Re: EOF and MS SQLServer?
Re: EOF and MS SQLServer?
- Subject: Re: EOF and MS SQLServer?
- From: René Bock <email@hidden>
- Date: Thu, 28 Feb 2019 09:19:34 +0000
- Thread-topic: EOF and MS SQLServer?
Hi,
unless you need to use ERXMigrations for schema creation, you may simply use
the com.webobjects.jdbcadaptor.MicrosoftPlugIn.
If you need ERXMigrations, things become bit hairy, since Microsoft did some
strange sql extensions:
utf-8 Support: varchar don't support UTF-8 characters. You have to use
nvarchar, ntext, columns if you need to store utf-8 characters
text-bolb: text (and ntext) are deprecated. Microsoft encourage to use
varchar(MAX), which is not really standard sql :-( At least I wasn't able
varchar(max) text blobs using the default EOSchemaGeneration mechanism.
Chuck once did write an (experimental) ERXMicrosoftPlugIn, to address
migration-support. Unfortunately, didn't find it's way into WOnder.
Fortunately I got a copy of chucks plugin and added the nvarchar/ntext
migration support. But my implementation required some changes in
ERPrototypes, which are not backward compatible...
Am 27.02.2019 um 10:40 schrieb Markus Ruggiero
<email@hidden<mailto:email@hidden>>:
We are about to get a new project but the customer requires the application to
run against an existing Microsoft SQL Server (version not yet known). When I
create a new EOModel there is no selection for an MS SQL Server plug-in. No
support in Wonder for Microsoft?
Does anyone have experience running a Wonder App against a Microssoft database?
Please help and advise
---markus---
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list
(email@hidden<mailto:email@hidden>)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
Mit freundlichen Grüßen
René Bock
--
Telefon: +49 69 650096 18
salient GmbH, Lindleystraße 12, 60314 Frankfurt
Telefon Zentrale: 069 / 65 00 96 - 0 |
www.salient-doremus.de<http://www.salient-doremus.de>
_______________________________________________
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