Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Fraterdominatio
Starting Member
2 Posts |
 Posted - 2012-01-24 : 07:38:04
|
| Hi FolksWe are using a development system called Servoy, and one of the tools in that environment is the ability to export a solution from our dev machine and import it to a working Servoy Server. The Servoy import should create any tables and columns missing in the deployed version, that appear in the recently exported dev version.However, since Servoy is using a java driver to do all of the DB changes, it appears that when we have a varchar column in the export it is being translated as an ntext column in the actual server.We believe this is because the driver is polling the SQL Server for the default types the server is responding with these column types.Q: Can I change the default settings in MSSQL Server to make these columns varchar rather than ntext etc?Appreciate any feedback.==========SQL Server 2008 R2==========CheersIan |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-01-24 : 08:10:38
|
| As far as I know, there is no setting in SQL server which would change the columns from ntext to varchar, or instruct a client program to use varchar instead of ntext.One thing you might want to do is check the version of JDBC driver Servoy is using and whether it is a recent version that is aware of varchar(max) etc. |
 |
|
|
Fraterdominatio
Starting Member
2 Posts |
Posted - 2012-01-24 : 08:36:10
|
| I know the driver is varchar(max) aware and we use that a lot. In Servoy it uses pretty basic types, so instead of varchar - when you look inside Servoy it's called text. So it's likely Servoy taking the first text type and applying that through the driver. I thought there may be a way to default MSSQL to specific types!Thanks for the feedback though.==========SQL Server 2008 R2==========CheersIan |
|
|
|
|
|
|
Default Data Types